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.