OID 11g: ODS Schema Upgrade Fails Using PSA: OID SCHEMAUPDATE ERROR
(Doc ID 1581208.1)
Last updated on SEPTEMBER 12, 2019
Applies to:
Oracle Fusion Middleware - Version 11.1.1.2.0 to 11.1.1.9.0 [Release Oracle11g]Information in this document applies to any platform.
Symptoms
ODS schema upgrade fails while upgrading Oracle Internet Directory (OID) 11g with PatchSet Assistant (PSA).
The log shows:
[2013-09-03T15:20:43.270+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Database product version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production[[
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
]]
[2013-09-03T15:20:43.272+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Database driver name: Oracle JDBC driver
[2013-09-03T15:20:43.272+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Database driver version: 11.2.0.3.0
[2013-09-03T15:20:44.281+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Component ID=OID, Schema=ODS, Schema version=11.1.1.6.0, Status=UPGRADING, Upgraded=false
[2013-09-03T15:20:44.282+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Finished examining OID.OID11 with status: SUCCESS.
[2013-09-03T15:20:44.282+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Finished examining components.
[2013-09-03T15:21:43.532+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] Starting to upgrade components.
[2013-09-03T15:21:43.533+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] Starting to upgrade OID.OID11.
[2013-09-03T15:21:43.702+02:00] [OID] [NOTIFICATION] [] [upgrade.OID.OID11] [tid: 13] [ecid: <ECID>] OID PS6 Schema update
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] <ORACLE_HOME_DIR>/bin/sqlplus /nolog
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] WHENEVER SQLERROR EXIT SQL.SQLCODE
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] WHENEVER OSERROR EXIT SQL.OSCODE
[2013-09-03T15:21:43.709+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] connect SYS/******@<DB_HOSTNAME>:<DB_PORT>/<DB_SERVICE_NAME> AS SYSDBA
[2013-09-03T15:21:43.709+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] @<ORACLE_HOME_DIR>/ldap/admin/oidi11117.sql
[2013-09-03T15:21:44.167+02:00] [OID] [ERROR] [] [upgrade.OID.OID11] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] OID SCHEMAUPDATE ERROR
[2013-09-03T15:21:44.167+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] Finished upgrading OID.OID11 with status: FAILURE.
[2013-09-03T15:21:44.168+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] Finished upgrading components.
[2013-09-03T15:21:44.168+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] 0 components upgraded with success.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] 1 components upgraded with failure.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] 0 components already upgraded.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] 0 components skipped.
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
]]
[2013-09-03T15:20:43.272+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Database driver name: Oracle JDBC driver
[2013-09-03T15:20:43.272+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Database driver version: 11.2.0.3.0
[2013-09-03T15:20:44.281+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Component ID=OID, Schema=ODS, Schema version=11.1.1.6.0, Status=UPGRADING, Upgraded=false
[2013-09-03T15:20:44.282+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Finished examining OID.OID11 with status: SUCCESS.
[2013-09-03T15:20:44.282+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Finished examining components.
[2013-09-03T15:21:43.532+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] Starting to upgrade components.
[2013-09-03T15:21:43.533+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] Starting to upgrade OID.OID11.
[2013-09-03T15:21:43.702+02:00] [OID] [NOTIFICATION] [] [upgrade.OID.OID11] [tid: 13] [ecid: <ECID>] OID PS6 Schema update
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] <ORACLE_HOME_DIR>/bin/sqlplus /nolog
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] WHENEVER SQLERROR EXIT SQL.SQLCODE
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] WHENEVER OSERROR EXIT SQL.OSCODE
[2013-09-03T15:21:43.709+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] connect SYS/******@<DB_HOSTNAME>:<DB_PORT>/<DB_SERVICE_NAME> AS SYSDBA
[2013-09-03T15:21:43.709+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] @<ORACLE_HOME_DIR>/ldap/admin/oidi11117.sql
[2013-09-03T15:21:44.167+02:00] [OID] [ERROR] [] [upgrade.OID.OID11] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] OID SCHEMAUPDATE ERROR
[2013-09-03T15:21:44.167+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] Finished upgrading OID.OID11 with status: FAILURE.
[2013-09-03T15:21:44.168+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] Finished upgrading components.
[2013-09-03T15:21:44.168+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] 0 components upgraded with success.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] 1 components upgraded with failure.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] 0 components already upgraded.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: <ECID>] 0 components skipped.
The following upgrades succeed:
IAU Audit Service PRDOID_IAU 11.1.1.7.0 VALID Y
MDS Metadata Services PRDOID_MDS 11.1.1.7.0 VALID Y
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! |
In this Document
Symptoms |
Cause |
Solution |
References |