ORA-06512: OIM Database Schema Upgrade Failure
(Doc ID 2264098.1)
Last updated on FEBRUARY 27, 2019
Applies to:Identity Manager - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
During the process of upgrading OIM from 220.127.116.11.0 - 18.104.22.168.0 and during the PSA part for Oracle_IDM1 an error occurs for *_OIM account.
The issue can be reproduced at will with the following steps:
1.Open sqlplus using sys
2. Run the below command
SELECT owner, object_name FROM all_objects WHERE status='INVALID';
3. Check any INVALID objects appeared or not. If appeared then run the below command from the same sql prompt to recompile all the INVALID objects.
4. Again repeat the step III to check for the INVALID objects. Now all the INVALID objects should be gone.
5. From command shell move to <MW_HOME>/oracle_common/bin
6. Run ./psa
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