ORA-02437: Cannot Validate (CTXSYS.DRC$CLA_KEY) - Primary Key Violated (Doc ID 1457621.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Text - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Errors found in the 10.2.0.4 to 11.2.0.3 upgrade log file:

Oracle Database 11.2 Post-Upgrade Status Tool           04-25-2012 12:37:37
.
Component                               Current      Version     Elapsed Time
Name                                    Status       Number      HH:MM:SS
...
...
Oracle Text
.   ORA-02437: cannot validate (CTXSYS.DRC$CLA_KEY) - primary key violated
.   ORA-06512: at line 14
.   ORA-02437: cannot validate (CTXSYS.DRC$CLA_KEY) - primary key violated
.   ORA-06512: at line 14
.                                         VALID      11.2.0.3.0  00:03:01
..
...
Gathering Statistics
.                                                                00:32:13
Total Upgrade Time: 02:40:08

Changes

 Database was upgraded from 10.2.0.4 to 11.2.0.3.

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