Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

RMAN-06548: connected to auxiliary database: string (DBID=string)

1 2637

RMAN-06549: connected to auxiliary database: string (not mounted)

1 3108

RMAN-06550: clone database not mounted and db_name not set in init.ora

1 4334

RMAN-06551: error while looking up datafilecopy for file number: string

1 3165

RMAN-06552: newname for datafile number was set to NEW, but file was not restored

1 3179

RMAN-06553: DB_CREATE_FILE_DEST must be set for SET NEWNAME ... TO NEW

1 6861

RMAN-06554: WARNING: file string is in backup mode

1 6844

RMAN-06555: datafile string must be restored from backup created before string

1 9237

RMAN-06556: datafile string must be restored from backup older than scn string

1 12749

RMAN-06557: unable to restore archived log thread number, sequence number

1 5332

RMAN-06558: archived log size of number kb is bigger than available space of number kb

1 8130

RMAN-06559: MAXSIZE must be larger than 1 kb

1 3020

RMAN-06560: WARNING: backup set with key number will be read number times

1 5146

RMAN-06561: available space must be larger than number kb

1 5482

RMAN-06562: available space of number kb needed to avoid reading the backup set multiple times

1 4232

Un-Answered Questions { Database Errors }

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2521

NZE-28868: Peer certificate chain check failed.

2802

IMP-00064: Definition of LOB was truncated by export

6415

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2739

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2725

What is SCD (Slowly Changing Dimensions)? What are its types?

2662

ORA-26079: file "string" is not part of table string.string

1958

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2802

What is live lock, deadlock and what is Lock escalation?

2434

NZE-28890: Entrust Login Failed

1882

ORA-26076: cannot set or reset value after direct path structure is allocated

1968

ORA-16627: No standby databases support the overall protection mode.

3991

How to view the error log for any specific instance?

2486

mount: mount to NFS server failed: System Error: Connection timed out

3668

ORA-26028: index string.string initially in unusable state

3862

For More Un-Answered { Database Errors } Questions Click Here