Migrating Oracle Data Integrator (ODI) from version 11g to 12c is not straight forward as exporting and importing it into a new repository. An administrator needs to upgrade the 11g version of the repository to the 12c version so the new features can be incorporated into into the code.
Prerequisites For An ODI 11g to ODI 12C upgrade
A clone should be made of each original master and work repository on 11g. The Upgrade Assistant does not support repositories distributed on different instances of ODI.
The ODI 12c version now uses unique IDs that follow the GUID convention. This avoids collision during the import of ODI objects and allows for simpler management and consolidation of multiple repositories within any given project.
Create a backup for each master and work repository (11g). The backup will enable administrators to restore to the initial (pre-upgrade) state, if necessary.
Before the upgrade of schemas, make sure the database supports the newer version. (Note: ODI 12c supports database versions 18.104.22.168 R2 and above.)
Only repositories from versions of ODI 22.214.171.124.0 and above can be upgraded to ODI 12c. If the scenario is one where we have to upgrade ODI 10g to ODI 12C, we must first upgrade ODI 10g to ODI 126.96.36.199.0 before performing the ODI 12c upgrade.
After successfully installing ODI 12c using the odi_121200.jar file, Opatch needs to be applied from the odi_1212_opatopatch.rar file available from the same folder downloaded from Oracle Technology Network (OTN).
- Before running a Opatch, shut down all Oracle and ODI services.
- Call the OPtach.bat file available in <Oracle_Home>\OPatch directory “opatch napply <download_folder>\odi_1212_opatch”
- Once Opatch is successful, call upgrade utility “ua.bat” from <Oracle_Home>\oracle_common\upgrade\bin folder.
Installing ODI 12C
Download the 12c ODI generic version from oracle downloads. I have downloaded 12.1.2 generic version which is the current version when this post is written.
Extract this zip file. we can see the main jar for installation and patches zip file to apply the patches. Extract the patch zip file. ODI 12c installation has 2 steps.
Install ODI 12c jar
Run the jar file in command prompt for installation. we need to run this jar with admin rights in windows (run as administrator option). Also ODI 12c is certified above 1.7.0_15 or above. Be sure to use latest JDK 1.7.
In windows, to run the command with admin rights, type cmd in run and use cntrl-shift-enter to launch it. select yes in the confirmation for running the commands with admin privilege in the cmd window.
type the command java -jar odi_121200.jar (make sure java executable is from jdk 7 latest version)
Lets connect to the repository using the new 12c ODI client.
ODI client odi.exe or odi64.exe can be found in <Oracle_Home>/odi/studio. Lauch the exe for odi studio client.
Oracle has made the look and feel same for Jdeveloper 12c and ODI 12c client. It is evident that OFM is standardized across tools and infrastructure in 12c.