My Oracle Support Banner

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 to [Release Oracle11g]
Information in this document applies to any platform.


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 - 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:
[2013-09-03T15:20:44.281+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: <ECID>] Component ID=OID, Schema=ODS, Schema version=, 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:
MDS Metadata Services PRDOID_MDS VALID Y


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.