There is one main production environment where we have OID 10.1.4.0.1 installed and upgraded to 10.1.4.3 later.
We have been setting up another production environment for disaster recovery purpose and had to use the same OID DB schema used in main production server. So we just replicated the database from main prod to disaster recovery servers.
While installing OID components newly in disaster recovery setup, I got a show stopper issue because of inconsistent version of DB schema and install version. We should first install 10.1.4.0.1 , since the OID DB schema already has 10.1.4.3, you will see an error at the step “Specify Repository”. The error screenshot is given below.
I checked the existing components version in the schema using the command
select comp_id,version,status from app_registry;
Below is the screenshot for the same.
Here is the Solution:
Login to sqlplus as sys user and perform the below step.
update orasso.wwc_version$ set version='10.1.4.0.1';
Below is the screenshot for the same.
Be sure to commit the transaction otherwise you will see the same error.
Once the Oracle application server gets installed succesfully, you can upgrade the OID to 10.1.4.2 or 10.1.4.3 as per your requirement.
Before upgrading the OID, you have to perform this step.
update orasso.wwc_version$ set version='10.1.4.3.0';
and install the patch for upgrade.
Helpful Docs:
metalink note 787603.1
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