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.

Note down the upgrade key and save it in notepad. This will be used for future reference

Once I logged into my upgraded repository, I found all my projects available without any issues/missing references.