OID 11g: ODS Schema Upgrade Fails Using PSA: OID SCHEMAUPDATE ERROR (Doc ID 1581208.1)

Last updated on JUNE 02, 2016

Applies to:

Oracle Fusion Middleware - Version 11.1.1.7.0 and later
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: 0000K3ZyrNI99hEpn4s1yZ1I9U6W000003,0]   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: 0000K3ZyrNI99hEpn4s1yZ1I9U6W000003,0]   Database driver name: Oracle JDBC driver
[2013-09-03T15:20:43.272+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: 0000K3ZyrNI99hEpn4s1yZ1I9U6W000003,0]   Database driver version: 11.2.0.3.0
[2013-09-03T15:20:44.281+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: 0000K3ZyrNI99hEpn4s1yZ1I9U6W000003,0] 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: 0000K3ZyrNI99hEpn4s1yZ1I9U6W000003,0] Finished examining OID.OID11 with status: SUCCESS.
[2013-09-03T15:20:44.282+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: 0000K3ZyrNI99hEpn4s1yZ1I9U6W000003,0] Finished examining components.
[2013-09-03T15:21:43.532+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] Starting to upgrade components.
[2013-09-03T15:21:43.533+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] Starting to upgrade OID.OID11.
[2013-09-03T15:21:43.702+02:00] [OID] [NOTIFICATION] [] [upgrade.OID.OID11] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] OID PS6 Schema update
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] /orahome/oracle/product/fmw/idm/bin/sqlplus /nolog
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] WHENEVER SQLERROR EXIT SQL.SQLCODE
[2013-09-03T15:21:43.708+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] WHENEVER OSERROR EXIT SQL.OSCODE
[2013-09-03T15:21:43.709+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] connect SYS/******@myoiddb:1521/mydb.mycompany.com AS SYSDBA
[2013-09-03T15:21:43.709+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] @/orahome/oracle/product/fmw/idm/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: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] Finished upgrading OID.OID11 with status: FAILURE.
[2013-09-03T15:21:44.168+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0] Finished upgrading components.
[2013-09-03T15:21:44.168+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0]   0 components upgraded with success.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0]   1 components upgraded with failure.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0]   0 components already upgraded.
[2013-09-03T15:21:44.169+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] [ecid: 0000K3Zz6Hg99hEpn4s1yZ1I9U6W000004,0]   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

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