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.
Thank you! This helped me today.
ReplyDelete