Search This Blog

Monday, January 16, 2012

ORA-00600 + [kqlidchg0]

Today i saw below error message on my alert log files
Mon Jan 16 08:34:12 2012
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\fakpropr\fakpropr\trace\fakpropr_ora_3244.trc  (incident=72644):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg0], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

Clause:
There are dependent objects in an invalid state.

Solution:
Please run the following query and review the results.
SQL> SET LINESIZE 100
SQL> SELECT object_id, object_name, object_type, owner, status 
     FROM   dba_objects 
     WHERE  object_name IN (SELECT symrep 
                            FROM   plscope_identifier$ 
                            WHERE  obj# IN (SELECT obj# 
                                            FROM   plscope_identifier$ 
                                            MINUS  
                                            SELECT object_id 
                                            FROM   dba_objects));

2.  Drop the invalid objects.
3.  Purge the recyclebin to clear the dropped objects.
4.  Drop the table that was failing to drop.

5 comments:

kamel khelifi said...

I have this fololowing error message
Pile d'erreurs ORA- (00600[kcbzwb_4]) consignée dans /oracle/PROD/db/tech_st/10.2.0/admin/PROD_orapps01/bdump/alert_PROD.log.

and I need help to solve this issue

kamel khelifi said...

I have this fololowing error message
Pile d'erreurs ORA- (00600[kcbzwb_4]) consignée dans /oracle/PROD/db/tech_st/10.2.0/admin/PROD_orapps01/bdump/alert_PROD.log.

and I need help to solve this issue

kamel khelifi said...

I have this fololowing error message
Pile d'erreurs ORA- (00600[kcbzwb_4]) consignée dans /oracle/PROD/db/tech_st/10.2.0/admin/PROD_orapps01/bdump/alert_PROD.log.

and I need help to solve this issue

kamel khelifi said...

Hi again;
I have this bellow error when I try to execute your request sql


SQL> conn /as sysdba;
Connected.
SQL> SELECT object_id, object_name, object_type, owner, status
2 FROM dba_objects
3 WHERE object_name IN (SELECT symrep
4 FROM plscope_identifier$
5 WHERE obj# IN (SELECT obj#
6 FROM plscope_identifier$
7 MINUS
8 SELECT object_id
9 FROM dba_objects));
FROM plscope_identifier$
*
ERROR at line 4:
ORA-00942: table or view does not exist

is the anyone help me

kamel khelifi said...

I need your help