ORA-600[kqlidchg1] ORA-00001: Unique Constraint (SYS.I_plscope_sig_identifier$) Violated (Doc ID 1127659.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms


This error occurred when running utlrp during the Post Upgrade steps of 11.1 -> 11.2.

The symptoms are described here:

The alert log shows:

Errors in file /opt/oracle/product/diag/rdbms/xxxx/XXXX/trace/XXXX_ora_29506.trc (incident=59099):
ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 2
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated
Incident details in: /opt/oracle/product/diag/rdbms/xxxx/XXXX/incident/incdir_59099/XXXX_ora_29506_i59099.trc

 The post upgrade log shows these messages:

DECLARE
2 threads pls_integer := &&1;
3 BEGIN
4 utl_recomp.recomp_parallel(threads);
5 END;
6 /
DECLARE
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error

ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 3
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated
Process ID: 4252
Session ID: 130 Serial number: 3



The trace file shows this failing statement:

ALTER PACKAGE "<SCHEMA>"."<PACKAGE NAME>" COMPILE BODY REUSE SETTINGS


The call stack in the trace file written by the error contains all or some of the following functions:

ksupop <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2
rpidrv <- rpisplu <- $cold_kqlvld <- kglgob

 

Changes

These errors occur after running the upgrade successfully, while running utlrp.sql the post upgrade step.
It can be reproduced by running utlrp.sql directly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms