Tuesday, 3 December 2013

Upgrading ODI 11.1.1.7 repository to 12c:


Upgrading ODI 11.1.1.7 repository to 12c:

As I had promised to write on upgrading 11g repository to 12c, we will discuss on all the steps from beginning to till we make the upgradation successful.

I would also like the share the problem I faced during upgradation ( couldn’t start ua.bat ), But Thanks to David for reminding me about the OPatch that needs to be applied after the successful installation. You can refer this link  to know what we discussed on Linkedin.

You can find this patch in the folder that you had downloaded from OTN. Then try calling the OPtach.bat file available in Oracle_Home\OPatch directory. But don’t forget to read the read.txt provided in patch folder. Once this is successful, call ua.bat file present in D:\Oracle\Middleware\Oracle_Home\oracle_common\upgrade\bin location.

Keep in mind that the most important thing is , you have complete backup of master and work repository. I was also unsuccessful in my 1st attempt. But my backup saved me. :) . Okay here you go.
12upgd1
12upgd2

12upgd3
12upgd4
12upgd512upgd6
12upgd7

Note down the upgrade key and save it in notepad. This will be used for future reference
12upgd8
12upgd9
12upgd10
12upgd11
12upgd12
Once I logged into my upgraded repository, I found all my projects available without any issues/missing references.
12upgd13

ORACLE DATA INTEGRATOR BLOG