ODI 12 C Installation Steps:
Hello ODI Lovers!!. Its time to install ODI 12 C version. Since Oracle announced Oracle Data Integrator 12c, I was really struggling to get some free time to evaluate the newest version. I would say its another milestone for Oracle. This time you will find lot of changes ( new features ) in the UI and some what contains similarity with OWB. The complete installation took around 45 minutes for me as because I had to struggle around to resolve jdk path issue during start up. Please try it in your Dev environment and let me know if you have any issues.
Download Link
Oracle Data Integrator 12cR1 (12.1.2.0.0)
for All Platforms (including x64)
Extract the zip file. You will see two file (odi_121200.jar, odi_1212_opatch.zip) under ofm_odi_generic_12.1.2.0.0_disk1_1of1.
Go to command prompt and use below command to start the installer.
Since I was in hurry to see the UI, I installed it in my existing Weblogic Home which is of 11g version.
You can mark one thing that the ODI Studio 12.1.2.0.0 feature is coming only in Enterprise Edition not in Standalone Edition.
Congratulation!! You have successfully installed ODI 12c. Now go to the location D:\Oracle\Middleware\Oracle_Home\odi\studio and click on odi.exe. On the 1st time it will ask you to provide the jdk location. After providing the jdk path you might see below error.
Well this is somewhat outside my realm of knowledge. Not sure why it is reading jvm.dll. This was not happening in the older version of ODI. After some research on Google, I found the solution. In simple go to D:\Oracle\Middleware\Oracle_Home\odi\studio\bin and modify the odi.conf. On the 4th line you will find
AddVMOption -XX:MaxPermSize=256M. Just modify this to
AddVMOption -XX:MaxPermSize=128M
Make sure you have the correct jdk home (last line) in the same file. In my case it is
SetJavaHome C:\program1\Java\jdk1.7.0_40
Thats all. Double click on odi.exe.
There it is !! . The 1st change I can see right from here.
Yes, I want to import preference from previous installation.
Wondering after looking into the home screen ??? Well this is just the beginning. When you will create new mappings ( formerly called as interface) you will find lots of changes. Anyway lets proceed further.
This something new introduced in 12c. Well no one wants to compromise in terms of security. So lets create the wallet password.
I can see my old preference available in the drop down list.
Hmmm..You know what you have to do now. See you in my next post where we will discuss more about repository upgradation.
Thanks for reading.
Bhabani
thnks bhabani for posted of installation steps,really its helpful for who going to be install ODI12C
Thanks Bhabani today i was installing ODI 12C by following your blog and i installed it successfully.
Hi Bhabani,
thank you very much for detailed and precise recomendations for ODI 12c installation. I’ve stuck on that “Client requires a repository with version 05.01.01.16…”. Could you, pleace guide me and other colleagues thru that issue.
Best regards and many thanks
AL
Please go though below post link and let me know in case of any issues
http://dwteam.in/upgrading-odi-11-1-1-7-repository-to-12c/
Hi Bhabani,
I have installed Oracle 12C database and then i have installed ODI 12C successfully but i could not able to configure the master and work repository since i am getting the error like
“Network Adapter Couldnt establish the connection”
I have checked from the backend , i could able to connect to Database (12C) through SQLPLUS but couldnt able to do the same with SQL Developer
so can you please help me how to get rid of this issue or suggest me if any work around needs to be performed.
Many Thanks,
Kumar
Hi Pavan,
I had the same issue and found the solution after many attempts.
Driver List : Oracle JDBC Driver
Driver Name : oracle.jdbc.OracleDriver
url : jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = )) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = )))
It works for me..
Regards,
Pandi
Hi Pandi,
I’m getting the same error as Pavan, but I don’t understand your solution. Are you entering that information in the Upgrade Assistant?
Any help is much appreciated.
Jeff
while installing ODI 12c i am getting this error
dynamic module config -org.netbeans.Netbinox could not found
Which version of the software are you trying to install? with 32 bit version I did notice a similar issue. Check the java version that you are trying to use. It is not compatible with the java 7 – 1.60 version.
I had used java 7- 1.45 but after the installation, when i try to launch the studio, the software could not load certain oracle ide, netbeans related classes into the system12.1.2.0.0 folder. This folder gets created when you launch the studio for the first time in your local user profile
C:\Users\username\AppData\Roaming\odi\system12.1.2.0.0
In this folder all the relevant ides will be cached. As a work around i had copied the complete folder which got created from the 64 bit software which I installed on another machine. Then i was able to launch the studio.
Hi Bhibani,
I have to migrate ODI 11.1.1.6(on Linux) to ODI 12.1.2(on LINUX)version.
So I have installed ODI 12.1.2 ver on LINUX server …
Would you mind please sending the setps to get the ODI repository 11.1.1.6 to 12.1.2 version.
Thanks a lot
athide
Please check http://dwteam.in/upgrading-odi-11-1-1-7-repository-to-12c/
hi bhabani,
I am new to odi,when i install odi12c i didnot find the odiparam.bat file can u please help me on this.while installing i follow the document only,can u please help me out on this.
i seach in the odi(C:\Oracle\Middleware\Oracle_Home\odi\agent\internal\bin and agent\bin both the folders i didnt find the odiparam.bat(.sh)files ,can please tell me (or)send the document which i can follow where the location would be.i am using odi12.1.3.
Thanks
Sonaligupta
Hi Sonali,
ODI 12c agent configuration is bit different than 11g. Thats why you wont get any ODIPARAMS anymore. You have to do via config.bat present in the installation folder. Here we have 3 types of agent such as
Standalone Agent
Colocated Agent
JEE Agent
To know the difference between them please see http://www.ateam-oracle.com/odi-agents-standalone-jee-and-colocated/
To create Standalone Agent please refer http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_agent/index.html
To create Colocated Agentplease refer http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_agent_collocated/index.html
And for JEE agent follow the early approach.
Let me know if you face any issues.
Thanks
Bhabani
Thanks a lot for u r early response babhani,my present requirement is i have to integrate both odi&SOA,by using webservicess(WSDL),can u please guide me on this.
Thanks
Sonali.
Then you have to install weblogic 12c and create ee agent to deal with SOA. Let me know if you face any issues in the installation.
Thanks
Awesome work…am following u for ODI
I have provided wallet password, but I don’t remember the wallet password which I have provided.
How to login to ODI by retrieving the forgot password
Hi, the wallet file is named ewallet.p12 and is placed in the following directory. You can move that file to a different location and then try starting odi studio. It will ask you to enter new password.
Windows: %APPDATA%\odi\oracledi\ewallet
UNIX: $HOME/.odi/oracledi/ewallet
Yes.. It worked.. Thanks loads 🙂
Hi Bhabani,
I just got done installing ODI (64 bit) but when I click on ODI64, I get a bunch of JAVA errors. Is there somewhere it writes the error log because the window just disappears after the error and closes the dos session.
Thanks
Vish
Hi I am trying to install Oracle Data Integrator 12c in Ubuntu 15.04
I am getting the error message as “java.lang.nullpointerexception”.
I was able to successfully install Oracle 12c database and sql developer. However I am facing issues with ODI installation.
Please help
Hi Bhabhani,
Hope you are doing well!!
I want to access ODI 12c studio installed on linux server from windows machine(acting as ODI client).As in previous version(11g) ‘cwallet.sso’ and jps-config-jse.xml need to be moved from odi server to odi client machine. In case of ODI 12c the directory structure has changed and also not sure which files to move from server to client.Please suggest on this.
Appreciate your support.
Thanks!
Ravindra
I made a similar install with 12.2.1.3, posted some screenshot and issues encoutered, if you want to have a look.
Hi,
I’ve installed ODI STUDIO and agent on DB server. Now, the developer wants to access ODI agent. I cannot give them direct access to the database server. Is there a ODI client that developer can install on his machine and access the ODI repository from there just like we use sqldeveloper to connect to the database without having direct access to the database server.