My Oracle Support Banner

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

Last updated on NOVEMBER 19, 2017

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: 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

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


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