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

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-16061: Log file status has changed

1 2977

ORA-16062: DGID from standby not in Data Guard configuration

1 3742

ORA-16063: remote archival is enabled by another instance

1 7139

ORA-16064: remote archival is disabled by another instance

1 3050

ORA-16065: remote archival disabled at standby destination

1 3028

ORA-16066: remote archival disabled

1 2901

ORA-16067: activation identifier mismatch in archive log string

1 4042

ORA-16068: redo log file activation identifier mismatch

2 8940

ORA-16069: Archive Log standby database activation identifier mismatch

1 4093

ORA-16070: parameter string contains an invalid REGISTER attribute value

1 3155

ORA-16071: dependency archived log file not found string

1 2858

ORA-16072: a minimum of one standby database destination is required

1 8745

ORA-16073: archiving must be enabled

1 3663

ORA-16074: ARCH processes must be active

1 3034

ORA-16075: standby database destination mismatch

1 3816

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2486

RMAN-05017: no copy of datafile number found to recover

2410

hp asking for replication floppy to do reinstall 25254 server assistant

2882

How will you Handle Error in SQL SERVER 2008?

2403

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

2801

NZE-28890: Entrust Login Failed

1882

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2802

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2802

ORA-26032: index string.string loading aborted after string keys

2107

ORA-16626: failed to enable specified object

2218

what is the instrument that used in Mechanical Energy??

2680

[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

ORA-26027: unique index string.string partition string initially in unusable state

6746

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1679

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2733

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