Last updated on NOVEMBER 28, 2016
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.
***Checked for relevance on 29-May-2013***
Symptoms
Starting up database fails with:
ORA-00600: internal error code, arguments: [adbdrv_inconsist_dbkey], [], [],[], [], [], [], [], [], [], [], []
Call Stack looks as follows:
$cold_adbdrv <- opiexe <- opiosq0 <- kpooprx <- kpoal8
<- opiodr <- ttcpip <- opitsk <- opiino <- opiodr
<- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
<- main_opd_entry
<- opiodr <- ttcpip <- opitsk <- opiino <- opiodr
<- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
<- main_opd_entry
Changes
Dropped 2 datafiles that were not being used as follows:
SQL> select file# from v$datafile where status like 'RECOVER';
FILE#
----------
83
84
SQL> alter database datafile 83 offline drop;
Database altered.
SQL> alter database datafile 84 offline drop;
Database altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /opt/apps/oracle/database/11.2.0.2/dbs/arch
Oldest online log sequence 40
Current log sequence 42
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [adbdrv_inconsist_dbkey], [], [],
[], [], [], [], [], [], [], [], []
Process ID: 12294
Session ID: 191 Serial number: 3
FILE#
----------
83
84
SQL> alter database datafile 83 offline drop;
Database altered.
SQL> alter database datafile 84 offline drop;
Database altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /opt/apps/oracle/database/11.2.0.2/dbs/arch
Oldest online log sequence 40
Current log sequence 42
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [adbdrv_inconsist_dbkey], [], [],
[], [], [], [], [], [], [], [], []
Process ID: 12294
Session ID: 191 Serial number: 3
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms