Upgrading ODI 11.1.1.7 repository to 12c

Upgrading ODI 11.1.1.7 repository to 12c:

 

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

 

I would also wish to divvy up the troubles 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 doing 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.  If you can see it, then call the OPtach.bat file available in Oracle_Home\OPatch directory. Don’t forget to go though the readme.txt provided in the 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 a 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 the upgraded repository, I found all my projects available without any issues/missing references.

12upgd13

So Congratulation for the good work you have done !!

Feel free to ask me if you face any issues during the process. Have a good day and see you in  my next post.

 

 

 

0

About the author

Bhabani(http://dwteam.in) - Currently Bhabani is working as Sr Development Engineer at Harman International. He has good expertise on Oracle, Oracle Data Integrator, Pervasive Data Integrator, MSBI, Talend and Java. He is also contributing in ODI-OTN forum for last 5 years. He is from India. If you want to reach him then please visit contact us page. If you have any doubts or concerns on the above article, please put your question here. Dw Team will try to respond it as soon as possible. Also dont forget to provide your comments / suggestions / feedback for further improvement. Thanks for your time.

Similar Posts

34 comments

its working fine. Thanks Bhabani once again.

Thanks for the Update and i believe it is very effective as well.

I have few Queries regarding this as
1)can i upgrade with out upgrading my database ( i mean can i upgrade my ODI from 11g to 12c by pointing to the same Oracle 11g Database)
2)can i upgrade directly from 11.1.1.5 to 12c, if so can i upgrade from 10g to 12c as well.

Thanks Much on your response,
Kumar P

No to your both questions Kumar. Its not possible.

You can upgrade to ODI 12c from ODI 11.1.1.6 and above. If you are working with a version below 11.1.1.6 (for example, v10, 11.1.1.3, 11.1.1.5,…), please upgrade to 11.1.1.6 first. After upgrading to 11.1.1.6, you will be ready to upgrade to ODI 12c.

NADENDLA VEERANJANEYULU / Reply

YES POSSIBLE IF BOTH ARE IN SAME ORACLE DATABASE;

santosh Raviteja / Reply

Thanks for this descrption. But I would like to know if it is possible to upgrade ODI BIAPPS schemas to ODI 12C version.
This is bit urgent. Can you explain me if there is any possibility. when I tried connecting to biapps repository from ODI 12C below is the issue: ODI-10179: Client requires a repository with version 05.01.01.16 but the repository version found is 04.03.04.02.

That’s a very good article Bhabani. Keep up the good work !

Hi Bhabani,

I want to migrate ODI 11.1.1.6.0 code into ODI 12c, I have successfully installed and configure standalone agent on ODI 12c on window 7 (32 bit), can you please help the exact OPatch to be installed on windows 7 to upgrade from ODi 11g to ODI 12c.

Note: I have exported and imported the ODI 11g master and work repository from ODI 11g to ODI 12c and I am unable to run ua.sh file, before that I need to run opatch.cmd from OPatch location. So, can you please help me where can I get exact patch for migration from ODI 11g to ODI12c

Regards,
Phanikanth

When you downloaded the file from OTN, didn’t you see any patch available in the zip file ?

Hi

Can you please provide the exact URL of OTN so I can download the file and check the patch

Regards,
Phanikanth

Hi Bhabani,

I can find ODI 11.1.1.7.0 related links on below URL

http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html

Can you please share the OPatch related to ODi 11.1.1.6.0 version to my mail ID phanikanth2004@gmail.com

Regards,
Phanikanth

Hi Bhabani,

Can you please provide the steps to run the OPatch on windows 7.

Regards,
Phanikanth

Sorry, it is typical miskate it should be ua.cmd not ua.sh

i am not able to use the ua nor the patch..i am getting the following error ..when i execute the ua..please help

C:\Oracle\Middleware\Oracle_Home\oracle_common\upgrade\bin>ua.bat
Oracle Fusion Middleware Upgrade Assistant 12.1.2.0.0
Log file is located at: C:\Oracle\Middleware\Oracle_Home\oracle_common\upgrade\l
ogs\ua2014-05-08-12-28-53PM.log
UPGAST-00251: An error occured reading Upgrade Descriptor file C:\Oracle\Middlew
are\Oracle_Home\odi\plugins\upgrade\odi.xml
The file does not conform to the expected syntax.
See the secondary message for additional information. Contact Oracle Support.
UPGAST-00259: The getInitialValue method for plug-in ODI.ODI1 will not be called
due to a previous error.

hi babu ,

i am getting same error when i am upgrading odi 11g to odi 12c, How 2 resolve this error can you please explain me

Thanks
RamuNaidu

i am getting the follwing error when executing ua

C:\Oracle\Middleware\Oracle_Home\oracle_common\upgrade\bin>ua.bat
Oracle Fusion Middleware Upgrade Assistant 12.1.2.0.0
Log file is located at: C:\Oracle\Middleware\Oracle_Home\oracle_common\upgrade\l
ogs\ua2014-05-08-12-28-53PM.log
UPGAST-00251: An error occured reading Upgrade Descriptor file C:\Oracle\Middlew
are\Oracle_Home\odi\plugins\upgrade\odi.xml
The file does not conform to the expected syntax.
See the secondary message for additional information. Contact Oracle Support.
UPGAST-00259: The getInitialValue method for plug-in ODI.ODI1 will not be called
due to a previous error.

If you have downloaded from OTN then you should be able to see a folder named as odi_1212_opatch. Under this folder you can see below files.
p16926420_121200_Generic.zip
p17170540_121200_Generic.zip
p17469061_121200_Generic.zip
README.txt

hi Bhabani,

Thank you for this article.

I have a similar requirement where I have the existing project developed in ODI 11.1.1.7 and on Oracle 11g. I need to migrate it to ODI 12c and on Oracle 12c DB.

I did the below steps,
1. From existing 11g Oracle DB, I created a Dump(.DMP) file using Oracle DB Pump (expdp).
2. Imported (impdp command) to import the same .DMP file on to Oracle 12c.
3. Started the Upgradation Utility (ua.bat).
4. Followed all instructions as per the above article.

However in the ‘step 5 of 12’ where provided all the DB credentials for SYS user and where it allows to select a schema from the drop down, –> for me there is no entry for this drop down. looking at the blogs , I could find out that this drop down is populated from system.SCHEMA_VERSION_REGISTRY$.

I tried a workaround by creating a dummy master repo in ODI12c, as a result it created an entry in that dropdown. This record I modified from backend and gave it the references for my .DMP file.

Now after that I could find out the dropdown entry. however it failed in step 9 of 12. 🙁

Please let me know if there is a solution for it.

Thanks

It got resolved now. I have created one /work repo with the same name with the one which I wanted to Upgrade. Then I removed this Repo and imported the 11G repo. It now worked fine.

Thanks

Hi Deb,

i have the same problem with the system.SCHEMA_VERSION_REGISTRY$ entry.
Could you give more details on how to solve this problem?

Thanks.

Hi Denis,

ODI creates an entry in system.SCHEMA_VERSION_REGISTRY$ table when ever a Repository is created using RCU (from commandline) or ‘Create **’ from ODI studio.

In my case we have different machines for ODI 11g and ODI 12c. Hence the Repository created in ODI 11g was not available in ODI 12c machine.

To solve this Issue I followed the below steps,

1. I Installed the ODI 11g on same machine where ODI 12c was available.
2. created a DB export of Master and Work Repository.
3. On 12c Machine, created a Repository using ODI 11g with the same database schema and repository schema name as it was with the original 11g machine. Once done It should create an entry in “SYSTEM”.”SCHEMA_VERSION_REGISTRY$” table.
4. Drop the newly created Database schema created in the step 3.
5. Import the Datadump taken from 11g machine on step 2 into this ODI machine.

Once these above steps are done, you should have a valid master/work repository which is compatible in 11g ODI and ready to be upgraded to ODI 12c.

Now you can proceed with the Upgrade Assistance as defined in this tutorial and you will be able to see the entry in the Drop down in ‘ODI Schema screen’.

Hope this information is clear. Please let me know in case of any clarification.

‘Create **’ above is in fact ‘Master Repository Creation Wizard’. sorry for the typo.

Thanks
Debashish

‘Create **’ above is in fact ‘Master Repository Creation Wizard’. sorry for the typo.
Thanks
Debashish

Bhabani,

Is there any way I can migrate/upgrade a single project from 11.1.1.7 to 12C

Go with import export. There are certain object that may not be migrated. You have to fix it manually.

Continuing from the above question..without going thru the repositories? I was told repositories are DBA property and I cannot access them. and the DBA team is not interested to migrate/upgrade. Either i have to do whatever to get this project or redo the same work in 12c. Any suggestions/solutions?

Thanks
Bobby

Like I said you have to go with export import. Check this link to know what can be imported and what are not.
https://docs.oracle.com/middleware/1212/odi/ODIDG/export_import.htm#CHDIIGEF

Can you post the upgrade from ODI11.1.16 to ODI11.1.17?I didn’t find exact steps any where.I have installed ODI11.1.1.7 and imported files repositories from ODI11.1.1.6 so which patch needs to applied and please let me know the patch number and give me the linkor send me the patch in mail.

Hi Bhabani,

while generating the scenario for mapping/interface in ODI 12.1.3,we are getting below errors.

Main error: ODI-20088 : Error while generating scenario.

sub_errors below:
ODI-10182: Uncategorized exception during repository access.
ODI-10143: Error while accessing the ODI repository.
ORA-01438: value larger than specified precision allowed for this column .

Please suggest on this.

Thanks,
Vasu.

Could you please check if the issue is related to the source to target column mapping mismatch in precision?

Hi Bhabani,

I have checked source and target column mapping and found no mismatch.

Please do needful on this.

Thanks,
Vasu.

Very difficult to find the root cause without seeing. I checked in MOS for any bug/defect but nothing was there. Can you try duplicating that interface and generate a scenario?
Updates: Patch 20732018: ODI-20088: Error while generating the scenario

Hi Folks,

I have a requirement that i need to upgrade the ODI Repositories from 12.1.3 to 12.2.1.6 version & while importing the repositories in 12.2.1.6 version i’m getting the version error , could you please tell me how to do that process??

Leave a replay to Debashish Cancel reply

required*

Are you a human? *