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/ANARDB/ANARDB/trace/ANARDB_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/ANARDB/ANARDB/incident/incdir_189939/ANARDB_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/ANARDB/ANARDB/trace 
 bash-3.2$ more ANARDB_j000_26003.trc 
 Trace file /u01/app/oracle/diag/rdbms/ANARDB/ANARDB/trace/ANARDB_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: ANARDB 
 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/ANARDB/ANARDB/incident/incdir_188865/ANARDB_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/ANARDB/ANARDB/incident/incdir_188866/ANARDB_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 
 ANARDB 
 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: