Upgrade Assistant fails "The ODS schema upgrade is INVALID."

(Doc ID 2115086.1)

Last updated on JUNE 21, 2016

Applies to:

Oracle Fusion Middleware - Version to [Release AS10gR2 to Oracle11g]
IBM AIX on POWER Systems (64-bit)


On : version, iAS Patchset

Upgrade assistant failed while upgrading OID from to   The log file shows the following errors:


[2016-03-09T10:32:35.777+01:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 3] [ecid: 0000LDQhlRK0vlmG8qECVx1MryVV000004,0] @/u01/app/oracle/product/oim11g_1_1_7/Oracle_IDM11g/rdbms/admin/utlrp.sql
[2016-03-09T10:33:02.516+01:00] [OID] [NOTIFICATION] [] [upgrade.OID] [tid: 3] [ecid: 0000LDQhlRK0vlmG8qECVx1MryVV000004,0] Validating OID Schema upgrade
[2016-03-09T10:33:02.517+01:00] [OID] [NOTIFICATION] [] [upgrade.OID] [tid: 3] [ecid: 0000LDQhlRK0vlmG8qECVx1MryVV000004,0] Validation Finished
[2016-03-09T10:33:02.517+01:00] [OID] [ERROR] [UPGCMP-00205] [upgrade.OID] [tid: 3] [ecid: 0000LDQhlRK0vlmG8qECVx1MryVV000004,0] The ODS schema upgrade is INVALID.
[2016-03-09T10:33:02.517+01:00] [OID] [ERROR] [] [upgrade.OID] [tid: 3] [ecid: 0000LDQhlRK0vlmG8qECVx1MryVV000004,0] Cause: Some of the packages in the Oracle Internet Directory schema were INVALID after upgrade. Action: To see which objects are invalid, log in to the Database as user 'ODS' and execute 'select object_name from user_objects where status='INVALID' '. Restore the backed up database and correct the schema before running the Assistant again.
[2016-03-09T10:33:02.525+01:00] [FrameworkMR] [ERROR] [UPGAST-01006] [upgrade.FrameworkMR] [tid: 3] [ecid: 0000LDQhlRK0vlmG8qECVx1MryVV000004,0] Schema upgrade failed for Oracle Internet Directory.


Additionally if you execute the following SQL

The issue can be reproduced at will with the following steps:
1. Installed OID in the same machine as OAS
2. Configured OID pointing to ODS 10g.
3. UA failed while upgrading OID

The issue has the following business impact:
Due to this issue, users cannot  complete upgrade from IDM to 11.1.1.X FMW IDM


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