ORA-00600: internal error code, arguments: [kzvdvesjc – kzvjobinfo not valid], [], [], [], [], [], [], [], [], [], [], [] ORA-01403: no data found


Hi, 

Internal error in Oracle DB version 11.2.0.3.0. This is our test database. I have check alert log and see following error: 

Errors in file /u01/app/oracle/diag/rdbms/azkkuat/AZKKUAT/ trace/AZKKUAT_j000_14225.trc (incident=189939): 
ORA-00600: internal error code, arguments: [kzvdvesjc - kzvjobinfo not valid], [], [], [], [], [], [], [], [], [], [], [] 
ORA-01403: no data found 
Incident details in: /u01/app/oracle/diag/rdbms/azkkuat/AZKKUAT/incident /incdir_189939/AZKKUAT_j000_14225_i189939.trc 
Use ADRCI or Support Workbench to package the incident. 
See Note 411.1 at My Oracle Support for error and packaging details. 
Cheking trace file:

bash-3.2$ cd /u01/app/oracle/diag/rdbms/azkkuat/AZKKUAT/trace 
bash-3.2$ more AZKKUAT_j000_26003.trc 
Trace file /u01/app/oracle/diag/rdbms/azkkuat/AZKKUAT/trace/AZKKUAT_j000_26003.trc 
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production 
With the Partitioning, Oracle Label Security, OLAP, Data Mining 
and Real Application Testing options 
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1 
System name: SunOS 
Node name: azkktest 
Release: 5.10 
Version: Generic_147440-12 
Machine: sun4u 
Instance name: AZKKUAT 
Redo thread mounted by this instance: 1 
Oracle process number: 81 
Unix process pid: 26003, image: oracle@azkktest (J000) 


*** 2014-05-15 17:02:36.119 
*** SESSION ID:(172.15541) 2014-05-15 17:02:36.119 
*** CLIENT ID:() 2014-05-15 17:02:36.119 
*** SERVICE NAME:(SYS$USERS) 2014-05-15 17:02:36.119 
*** MODULE NAME:(DBMS_SCHEDULER) 2014-05-15 17:02:36.119 
*** ACTION NAME:(RLM$EVTCLEANUP) 2014-05-15 17:02:36.119 

Incident 188865 created, dump file: /u01/app/oracle/diag/rdbms/azkkuat/AZKKUAT /incident/incdir_188865/AZKKUAT_j000_26003_i188865.trc 
ORA-00600: internal error code, arguments: [kzvdvesjc - kzvjobinfo not valid], [], [], [], [], [], [], [], [], [], [], [] 
ORA-01403: no data found 

Incident 188866 created, dump file: /u01/app/oracle/diag/rdbms/azkkuat/AZKKUAT/ incident/incdir_188866/AZKKUAT_j000_26003_i188866.trc 
ORA-00600: internal error code, arguments: [kzvdvesjc - kzvjobinfo not valid], [], [], [], [], [], [], [], [], [], [], [] 
ORA-06512: at "EXFSYS.DBMS_RLMGR_DR", line 23 
ORA-01403: no data found 
ORA-06512: at line 1 

ORA-00600: internal error code, arguments: [kzvdvesjc - kzvjobinfo not valid], [], [], [], [], [], [], [], [], [], [], [] 
ORA-06512: at "EXFSYS.DBMS_RLMGR_DR", line 23 
ORA-01403: no data found 
ORA-06512: at line 1 
bash-3.2$

Solution:

bash-3.2$ echo $ORACLE_SID 
AZKKUAT 
bash-3.2$ 
bash-3.2$ 
bash-3.2$ sqlplus "/ as sysdba"; 

SQL*Plus: Release 11.2.0.3.0 Production on Thu May 15 18:30:34 2014 

Copyright (c) 1982, 2011, Oracle. All rights reserved. 


Connected to: 
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production 
With the Partitioning, Oracle Label Security, OLAP, Data Mining 
and Real Application Testing options 

SQL> 
SQL> 
SQL> @$ORACLE_HOME/rdbms/admin/catnoexf.sql; 

PL/SQL procedure successfully completed. 


User dropped. 


Package dropped. 


PL/SQL procedure successfully completed. 


PL/SQL procedure successfully completed. 


PL/SQL procedure successfully completed. 


PL/SQL procedure successfully completed. 

SQL> 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: