OID 11g installation troubleshooting
I have done been doing OID 11g installation in windows environment recently and encountered an issue.In this case, there is also DB Vault installed with Oracle Database. So if you happen to install OID schema using RCU on such DB with Vault, then you have to follow these steps:
1. Disable DB Vault: follow this guide .
2. Install OID Schema using RCU.
3. Install OID
4. Enable DB Vault again.
If you are using Oracle DB 11.1.0.7, then you may need to patch it with this 7244497 and 7291157. You can also follow this guide. As per the guide, you would need to apply 2 patches post OID installation i.e, 7244497 and 7291157. If you are using windows machine then 7244497 is not available. However, you can simply apply 1 patch 9384493 as it covers the bugs of both patches 7244497 and 7291157.
Though it happens to be the common error while installing OID 11g (11.1.1.2.0), it fails at step Creating OID instance/ Starting OID instance.
The error may look like this
Error creating ASComponent oid1.
Cause:
An internal operation has failed: Exception in onCreate()
Action:
See logs for more details.
Step Create Oracle Internet Directory failed
Upon debugging the install logs, I found this “OID schema entry missing in schema_version_registry”.
The way to debug is to execute the following sql queries to check the no. of rows it returns.
select count(*) from schema_version_registry;
SELECT count(*) FROM all_objects WHERE object_name=’SCHEMA_VERSION_REGISTRY’ AND object_type=’VIEW’;
If both returns more than 1, then there is an issue. Hence we need to drop the OID schema using RCU and create it again.
Later, run the OID installer and it went fine.
About the Author Mahendra
I am engulfed in Oracle Identity & Access Management domain. I have expertise on providing the optimized solutions for user provisioning, web access management, Single Sign-On and federation capabilities etc., I am also well versed with complex integrations within Identity Management and other product domains. I have expertise on building demos and implementation experience on products Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Entitlement Server, Oracle Virtual Directory, Oracle Internet Directory etc., Look @ my blog: http://talkidentity.blogspot.com