ODI 12 C Installation Steps

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)

Download 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.

12c1

 

Since I was in hurry to see the UI, I installed it in my existing Weblogic Home which is of 11g version.

12c2

12c3

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.
12c4

12c5

12c6

12c7

12c8

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.
12c8_err

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.
12c10

Yes, I want to import preference from previous installation.
12c11

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.

12c12

This something new introduced in 12c. Well no one wants to compromise in terms of security. So lets create the wallet password.
12c13
12c14

I can see my old preference available in the drop down list.

12c15
12c16

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

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

22 comments

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

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

Ravindra Kumar / Reply

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

Leave a replay to Niharika Cancel reply

required*

Are you a human? *