Upgrade to 12.2.0.1 Fails With Error "ORA-00001: Unique Constraint (SYS.I_DAM_LAST_ARCH_TS$) Violated" (Doc ID 2279575.1)

Last updated on JULY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Following errors are observed during the upgrade of Oracle database from 12.1.0.2 to 12.2.0.1

08:43:25 SQL>
08:43:25 SQL> declare
08:43:25 2 dbid number;
08:43:25 3 pdbguid varchar2(33);
08:43:25 4 begin
08:43:25 5 select dbid into dbid from v$containers
08:43:25 6 where name = SYS_CONTEXT('USERENV', 'CON_NAME');
08:43:25 7 select guid into pdbguid from v$containers
08:43:25 8 where name = SYS_CONTEXT('USERENV', 'CON_NAME');
08:43:25 9
08:43:25 10 execute immediate 'update sys.dam_last_arch_ts$ ' ||
08:43:25 11 'set database_id = :dbid, container_guid = :pdbguid'
08:43:25 12 using dbid, pdbguid;
08:43:25 13 commit;
08:43:25 14 end;
08:43:25 15 /
declare
*
ERROR at line 1:
ORA-00001: unique constraint (SYS.I_DAM_LAST_ARCH_TS$) violated
ORA-06512: at line 10



Changes

 Performing the upgrade to 12.2.0.1.

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