ORA-06512: OIM Database Schema Upgrade Failure
Last updated on MAY 14, 2017
Applies to:Identity Manager - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
During the process of upgrading OIM from 188.8.131.52.0 - 184.108.40.206.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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms