My Oracle Support Banner

OIG 12.2.1.3.0 Upgrade Assistant Fails With ORA-00955 Errors (Doc ID 2412393.1)

Last updated on JUNE 20, 2018

Applies to:

Identity Manager - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

Before running the OIG 12.2.1.3.0 Upgrade Assistant (UA) for the first time, Patch 27692108 for OIG 12.2.1.3.0 needs to be applied after unzipping the bits and before starting the installation.

However, if the Upgrade Assistant is run for the first time without patch 27692108 then you may see ORA-00955 errors in the UA log (see example log snippet below).

These errors are seen in environments where the OIM/SOA schema db's have been backed and restored.

The following SOA and OIM sql script errors may be seen in the Update Assistant log.

SOA:

Mon Jun 4 14:55:12.093 CDT 2018 rcu:Statement Type: 'DDL Statement'
Mon Jun 4 14:55:12.114 CDT 2018 rcu:Extracted SQL Statement: [ALTER TABLE
AUDIT_TRAIL DROP CONSTRAINT AT_PK]
Mon Jun 4 14:55:12.114 CDT 2018 [SOA1#143] rcu:Extracted Statement from File
Name:
'/app/oracle/12c/soa/common/sql/soainfra/sql//oracle/upgrade_soainfra_111190_1
21300_oracle.tsql'Line Number: 4839
Mon Jun 4 14:55:12.114 CDT 2018 rcu:Statement Type: 'DDL Statement'
Mon Jun 4 14:55:12.128 CDT 2018 rcu:Extracted SQL Statement: [ALTER TABLE
AUDIT_TRAIL ADD CONSTRAINT AT_PK PRIMARY KEY(FLOW_ID,CIKEY,COUNT_ID)
]
Mon Jun 4 14:55:12.128 CDT 2018 [SOA1#143] rcu:Extracted Statement from File
Name:
'/app/oracle/12c/soa/common/sql/soainfra/sql//oracle/upgrade_soainfra_111190_121300_oracle.tsql'Line Number: 4841
Mon Jun 4 14:55:12.128 CDT 2018 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 955SQLState:42000 Message: ORA-00955: name is already used by an existing object

Error encountered executing SQL statement FileName:
'/app/oracle/12c/soa/common/sql/soainfra/sql//oracle/upgrade_soainfra_111190_121300_oracle.tsql' LineNumber: '4841'
SQL Statement: [ALTER TABLE AUDIT_TRAIL ADD CONSTRAINT AT_PK PRIMARY KEY(FLOW_ID,CIKEY,COUNT_ID)

 

OIM:

IF(counter=0) THEN
EXECUTE IMMEDIATE 'ALTER TABLE poc ADD CONSTRAINT fk_poc_pop FOREIGN KEY (pop_key) REFERENCES pop(pop_key)';
ELSE
dbms_output.put_line(' Constraint FK_POC_POP alreday exists.');
END IF;
EXCEPTION
WHEN others THEN
RAISE_APPLICATION_ERROR(-20100,'Exception
encountered!!'||CHR(10)||SUBSTR(DBMS_UTILITY.FORMAT_ERROR_STACK,1,200)||CHR(10)||SUBSTR(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE,1,200));
END;
, Error Msg = ORA-20100: Exception encountered!!
ORA-00955: name is already used by an existing object

ORA-06512: at line 374
ORA-06512: at line 468

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 24 more

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.