Friends,
Following our 11g post series, a very important step is upgrade from 1og. Here is our thoughts.
The post tries to cover the method and issues related to it . I am sure this will give our viewers best idea and steps on how to move forward to newer version.
ODI 11g have an UPGRADE ASSISTANT that will help to upgrade the repository from ODI 10g to ODI 11g.
In case if you trying to upgrade by logging into the Master Repository and upgrade you will encounter the following error.
There is a Upgrade Assistant available in /bin folder . When I clicked it directly nothing happen so I knew , I need to call it using command prompt.
So I called the ua.bat being in windows and after a while an error . oops !! . hmm no idea what it is .?
I went to that path and saw that since I was using the Generic Version so I dint see any WIN 32 bit and saw only WIN64 , although I had OraInstaller.dll . I thought to myself is it a bug or can we upgrade only with 32 bit ODI version . I am sure that should not be the case , so I started looking at the certification (http://www.oracle.com/technetwork/middleware/data-integrator/odi-1111x-cert-matrix-163773.xls#’ODI ) and I found that for windows its only 32 bit which is supported.
To move on I changed the win32 to win64 and saved ua.bat I again got the error , I thought let me go for win32 ODI installation .
Moved to 32 bit ODI Installation
Launched the Upgrade Assistant from <ODI_HOME>/bin/ua.bat
I am presently upgrading only the ODI repositories and not other component.
The third options – Check that Upgrade Occurs only to Cloned Repositories , caught my attention. Still I just clicked Next and moved ahead.
In this screen I checked Database Backup completed , so I thought to myself , looks like I need to do something or I am missing something , so I searched for the Upgrade from ODI 10g to ODI 11g documentation and I found this
http://download.oracle.com/docs/cd/E14571_01/upgrade.1111/e12642/tasklist.htm#CIHDDJAH
Here they have mentioned to do the cloning or backup of the Repository of Master and Work under the Master . Rather than creating the scripts I used a simple process through SQL Developer –> Database Copy
Before doing so Create the required ODI 11g Master and Work Repository schema and assign the required tablespaces to them .Once done using the Database copy , copy the Tables and the data.
In Next step , SQL Developer lists all the steps and finally click Finish to start the copy Process. Once completed , you will able to find all the Master Repository tables created in the next Master Repository schema with the required data in it.
Keep repeating the Process for all the Work Repository under that above Master Repository. Once completed Click Next in the Upgrade Assistant to move to Step 4.
Here in Step 4 list all the details required and provide the Master Repository just created above and provide the SUPERVISOR username and Password used in ODI 10g Repository.
Once the above screen is successful , Upgrade Assistant will lists all the Work Repository under the Master . Now provide the username and password of the schema of Cloned ODI 11g schema .
[ Note in case , any of the above mentioned steps is wrong or incorrect you will get an error screen as shows below
Use the First or the Third option but never the second option as there might be chances of corruption causing issues or improper Repository setup ]
Once Work Repository schema authentication is done , Click Upgrade to start the Upgradation Process.
Finally the required tables , and LKM are upgraded and the logs can be visited by click on the link mentioned in the Upgrade Assistant .
Now login into the ODI Studio and provide the Master Repository detail and select the appropriate Work Repository and log in , you don’t need to provide the internal ID since it will use the Internal Id specified during ODI 10g setup .
As you can see all the Interface, Model , Topology, agents are all created but you would need to create the appropriate Standalone Agent script for the migrated Agent.
I wanted to test the migration so I executed an Interface and it worked.
I also had another EWR setup under my Master Repository , I logged inside it too.
I can see all the required Scenarios, topology and other ODI objects.
This are some of the simple Upgrade process from ODI 10g DWR and EWR to ODI 11g .
Hope to hear from you all how was your experience with the Upgrade Assistant and what kind of errors you encountered .
Keep looking into odiexperts for more ODI 11g series Posts.
June 29, 2011 at 3:32 AM
Hi,
In Step 5/9 of upgrade assistant, I can’t provide the username of the schema of Cloned ODI 11g work repository. The field is just disable, only password is enable. Unless I can provide the right username, the assistant fails.
Anybody’s got the same problem ?
Any Idea ?
Thanks
Micropole
July 2, 2011 at 7:59 AM
Iam not sure why the Upgrade Assistant fails . Try running the UA again and if it still shows disable , please contract Oracle.
May 25, 2011 at 2:52 AM
Hi,
We have got a totally new server to install ODI 11g and use the existing ODI 10g master and work repositories in the new instance. Hence, do we need to use the master repository / work repository under a different name or the same name since these are being used currently on a separate instance which is working fine.
What will be the impact of this if we use the same master / work repository in the other instance as well as the current instance? What is advisable in this regards?
Thanks & regards,
May 25, 2011 at 11:53 AM
Hi Manini,
Thanks for visiting us . I believe if you are planning to move the repository from ODI 10g to 11g there is an upgrade assistant available .
Please learn more about it http://odiexperts.com/11g-oracle-data-integrator-upgrading-from-10g-part-411g.
How ever you cannot use the same repository since ODI 11g creates few extra tables and completely different architecture compared to 10g , so strongly i recommend to use a different Master and Work Repository instances.
Hope i have answered your query. Please let me know if you are looking for any other information.
Thanks
Kshitiz Devendra
May 19, 2011 at 2:01 PM
Hello,
We want to migrate to OODI 11G and in the same time we’ve a big project to migrate our SQL SERVER 2000 infrastructure where all the repository of ODI are store.
Because of some hang of DESIGNER on SQL SERVER like “Generate scenario”, “Writing log on operator”, we discuss about transfer the repository on Oracle and leave SQL SERVER behind us.
What’s your point of view ?
Thanks in advance.
Best regards.
March 21, 2011 at 9:47 AM
can you please comment your points on my below requests :
a) Can a standalone agent be installed on 64Bit Windows Server 2008. Is it compatible or would there be any issues for this.?
b) If the standalone agent can be installed on 64bit Win Server 2008, Is Java -x64 version supported for this..?
Thanks in advance..
March 21, 2011 at 12:51 PM
Yes . Standalone agent can be installed on Windows Server 2008 . Also java 64/32 bit depends on your ODI Version and 64 bit java should work for 64bit ODI version.
March 15, 2011 at 8:22 AM
I have installed 32 bit version jdk and ODI studio is installed on Windows XP. ODI repository is on Oracle DB (AIX server).
March 14, 2011 at 1:23 PM
I am facing difficulty in launching ua.bat
I got error “The system cannot find the path specified.”. I made sure that ODI_JAVA_HOME variable has correct path of jdk 1.6. Im not sure where is the problem. Any thoughts?
Thanks.
March 15, 2011 at 6:17 AM
what is the operating system and are you using the 64 bit version , if so please go for 32 bit version of ODI , since 64 bit is not support for upgrade assistant.
March 6, 2011 at 11:36 PM
Hello, We are getting this error while trying to connect to HyperionPlanning through ODI.
File “”, line 32, in ? com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host [INFCH02747], port [11333], check if connect information is correct.
We have RMI port number as 11333.The Hyperion RMI registry is up.But still we r getting the same error. Wats the reason…
March 7, 2011 at 5:51 AM
I believe John would be a perfect resource for Hyperion issues -http://john-goodwin.blogspot.com/
October 21, 2010 at 1:39 AM
Just curious .. are you able to startup ODI Studio from Windows 64 bit OS?
I got errors when I tried starting Studio (something about jvm.dll). I figured out it was using the Sun JDK 64 bit.
I fixed it by installing Sun JDK 32 bit and making Studio use this instead of the 64 bit JDK.
Is this a known issue not to use 64 bit JDK for ODI Studio?
October 21, 2010 at 5:15 AM
Hi Trev, Thanks for visiting us. I would say it has to more to do Java , rather than the ODI studio. Moreover behind the ODI studio its complete java.
October 14, 2010 at 1:29 PM
Hi Cezar, I have the same problem to upgrade to odi 11g 64 bit. But i didn’t understant what you have done to Launch the Upgrade Assistant.
October 15, 2010 at 5:09 AM
Alex ,
You would need to use the 32 bit version to upgrade .