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

About Bhabani 86 Articles
Bhabani has 10 plus years of experience in Data warehousing and Analytics projects that has span across multiple domains like Travel, Banking and Financial, Betting and Gaming Industries. Solution areas he focuses on designing the data warehouse and integrating it with cloud platforms like AWS or GCP. He is also a Elite level contributor at OTN forum more than 9 years. He loves to do experiment and POC on different integration tools and services. Some of his favorite skills are Redshift, Big Query, Python, Apache Airflow, Kafka, HDFS, Map Reduce ,HIVE, Habse, Sqoop, Drill, Impala.

24 Comments

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

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

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

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

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

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

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

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

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

Leave a Reply

Your email address will not be published.


*