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 10.1.2.3.0 to 11.1.1.7.0 [Release AS10gR2 to Oracle11g]
IBM AIX on POWER Systems (64-bit)

Symptoms

On : 10.1.2.3.0 version, iAS Patchset

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

ERROR
-----------------------

[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



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

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

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