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
Comments are closed.