Database upgrade to 12.2.0.1 of a 12.1.0.2 cloned database will generate the “ORA-00001:Unique Constraint” error.  “ORA-00001” occurred when updates the sys.I_DAM_LAST_ARCH_TS$ table at PDB level. See below screen shot.

Unique_LI

The following code failing is generating the unique constraint error.

The problem is occurred due to two rows in the sys.dam_last_arch_ts$ table. The database is cloned from other environment and then upgraded. The dbid is changed but original id is still there.

So work around is to remove the rows where the value of DBID does not match in v$database or apply “p25717371_122010_Generic.zip” patch. It’s now published Bug: 25717371.

Leave a Reply