Tuesday 7 February 2012

ORA-00600: internal error code, arguments: [kzxcInitLoadLocal-7] in alert log file


We faced this ORA-00600 Internal issue 
Os version - Windows
Oracle Software - Oracle 11g 11.2.0.1           

ERROR at line 1: ORA-00600: internal error code, arguments: [kzxcInitLoadLocal-7], [64131], 
[ORA-64131: XMLIndex Metadata: failure during the looking up of the dictionary 
ORA-30966: error detected in the XML Index layer 
ORA-30966: error detected in the XML Index layer ], [], [], [], [], [], [], [], [], [] 
ORA-06512: at "XDB.DBMS_XDB", line 437 ORA-06512: at line 39

Recreated the XDB in order to overcome this error.
Connect as sysdba
spool xdb_reins.log
Shutdown Immediate;
Startup;
@?/rdbms/admin/catnoqm.sql
--IMPORTANT YOU HAVE TO SHUTDOWN AND STARTUP BETWEEN REMOVAL AND REINSTALL
Shutdown Immediate;
Startup;
@?/rdbms/admin/catqm.sql xdb xdb temp YES
spool off"           

It's better to do this activity after shutting down the listener. This action plan is taken from Oracle metalink, i will share the Ref doc ID asap.

1 comment: