Tags » Invalid

ORA-00600 [kqlidchg0] | ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

Recently after upgrading the dev database to 12c, I ran utlrp to compile the invalid objects and it failed with the below error

SQL> @utlrp

SQL> SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual;

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2015-06-30 03:50:27

SQL> DECLARE
  2     threads pls_integer := &&1;
  3  BEGIN
  4     utl_recomp.recomp_parallel(threads);
  5  END;
  6  /
DECLARE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [],
[], [], [], [], []
ORA-00604: error occurred at recursive SQL level 2
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated
ORA-06512: at "SYS.DBMS_UTILITY", line 1294
ORA-06512: at line 1

SQL> SELECT dbms_registry_sys.time_stamp('utlrp_end') as timestamp from dual;

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2015-06-30 03:52:10
… 522 more words
Oracle

INVALID

So you can’t swallow time to wait
Before you are used as a bait
For you have nothing but a lustful date
Before that night… 152 more words

Poetry In My The Pots