ODI 10g( 10.1.3.5 ) to ODI11g(11.1.1.6.0) Upgrade Process on Linux Environment

This post keeps into consideration of the ODI 10g (10.1.3.5 ) to ODI11g(11.1.1.6.0) Upgrade Process on Linux Environment in two different scenarios .

1. ODI 10g Repositories Backedup Schemas 
2. Cloned ODI 10g Repositories Schemas

Upgrade process with   Backedup Repositories Schemas 

Possible Issues that can be avoided during the process.

• SQL DB Permissions 
• ORA-28000: the accountLock Issue

Solution :Provide the required permissions 

1. Corrupted Master & Work Repository Schemas
2. Duplicate\Missing Objects
3. Orphan Entries

ODI Pre Upgrade  Tasks (ODI 10.1.3.5 to 11.1.1.6.0)

Solution :To avoid the inconsistencies with ODI 10g Repository Schemas download the Repository Consistency Chequer RCC Utility to remove the above parameters.

Evaluate the ODI 10g Repository DB schema_version_registry

Login to DB with SYS Credentials and execute the below SQL Query

SQL:SELECTCOMP_ID,COMP_NAME,MRC_NAME,OWNER,VERSION,STATUS,UPGRADEDFROM schema_version_registry;