ORA-00603 ORA-00600 + [kqlidchg0] ORA-00604 ORA-00001

Today we've encountered the below error, it seems to be,

============Alert log==============
Mon Aug 25 11:08:50 2014
Errors in file /u01/app/oracle/diag/rdbms/SID_Server/SID_NAME/trace/SID_NAME_ora_40108088.trc  (incident=19385):
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
Incident details in: /u01/app/oracle/diag/rdbms/SID_Server/SID_NAME/incident/incdir_19385/SID_NAME_ora_40108088_i19385.trc
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 /u01/app/oracle/diag/rdbms/SID_Server/SID_NAME/trace/SID_NAME_ora_40108088.trc  (incident=19386):
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
Incident details in: /u01/app/oracle/diag/rdbms/SID_Server/SID_NAME/incident/incdir_19386/SID_NAME_ora_40108088_i19386.trc
Mon Aug 25 11:08:56 2014

============Trace file=============
Incident 19385 created, dump file: /u01/app/oracle/diag/rdbms/SID_Server/SID_NAME/incident/incdir_19385/SID_NAME_ora_40108088_i19385.trc
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
Incident 19386 created, dump file: /u01/app/oracle/diag/rdbms/SID_Server/SID_NAME/incident/incdir_19386/SID_NAME_ora_40108088_i19386.trc
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
kgefec: fatal error 0
opitsk: network error occurred while two-task server trying tosend break; error code = 24365

Clause:

There are dependent objects in an invalid state.

Identify:

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));

 

Solutions:

 

1. Compile the invalid objects to make it as valid or

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