Tuesday, July 19, 2016

ODI 12c 12.2.1.0 Step by Step Install and Configuration Java EE Agent Oracle Linux 6

Install ODI 12c on OBIEE 12c server- Linux

ODI 12c 12.2.1.0 Installation and Configuration, Adding ODI server to existing Weblogic OBIEE 12c server in single domain. ODI 12c and OBIEE 12c servers are running on single Weblogic domain.
  •     Java Development Kit (JDK 8) - Required Install
  •     Oracle Database 12cR1 - Required Install
  •     Oracle Weblogic Server 12c (Fusion Middleware Infrastructure 12.2.1.0) - Required Install
  •     ODI 12c 12.2.1.0.0 - Software Install
  •     RCU - Required Install
  •     ODI 12c Configuration Java EE Agent -- Adding to existing server
  •     ODI 12c STOP and Start Services (With OBIEE Services )
Download software distributives:
         ODI 12.2.1.0.0 12c is published on OTN: download page

Java Development Kit (JDK 8):
         Follow bellow link to install Java 8 on Linux 6 64bit system
         http://sankaramaddi.blogspot.com/2016/07/install-java-8-in-linux-64bit_7.html

 Oracle Database 12cR1:
        Follow bellow link to install Oracle Database 12c on Linux 6 64bit system
        http://sankaramaddi.blogspot.com/2016/07/how-to-install-oracle-database-12cr1-on.html

 Oracle Weblogic Server 12c (Fusion Middleware Infrastructure 12.2.1.0.0):
        Follow bellow link to install Weblogic Server 12.2.1.0 (Section -4) on Linux 6 64bit system
        lhttp://sankaramaddi.blogspot.com/2016/07/install-obiee-12c-12210-oracle-linux-6.html

ODI 12.2.1.0 Software Install:
  • Install ODI 12.2.1.0.0 software, If ODI is installing on OBIEE/WebLogic server have to select the existing oracle_home location. In my case /oracle/middleware (where installed Weblogic/OBIEE 12.2.1.0). 
  • Installation Type is "Enterprise Edition" 
  • Verify the JAVA_HOME and version details, follow bellow instruction to install software
[obiee@obiee12c software]$ ls -ltr
drwxr-xr-x. 7 oracle dba       4096 Jun 10  2013 database
-rw-r--r--. 1 oracle dba 1534295400 Oct 12  2015 fmw_12.2.1.0.0_infrastructure.jar
-rw-r--r--. 1 obiee  dba 1969868068 Oct 14  2015 fmw_12.2.1.0.0_odi.jar
-rw-r--r--. 1 obiee  dba  204243433 Oct 14  2015 fmw_12.2.1.0.0_odi2.jar
-rwxrwxrwx. 1 obiee  dba 1424038128 Mar 23 17:22 bi_platform-12.2.1.0.0_linux64-2.zip
-rwxrwxrwx. 1 obiee  dba 2090759452 Mar 23 17:22 bi_platform-12.2.1.0.0_linux64.bin
[obiee@obiee12c software]$ echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/obiee/bin
[obiee@obiee12c software]$ export JAVA_HOME=/usr/java/jdk1.8.0_91
[obiee@obiee12c software]$ export PATH=$JAVA_HOME/bin:$PATH
[obiee@obiee12c software]$ echo $PATH
/usr/java/jdk1.8.0_91/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:
/usr/sbin:/sbin:/home/obiee/bin
[obiee@obiee12c software]$ java -version
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)
[obiee@obiee12c software]$ /usr/java/jdk1.8.0_91/bin/java -d64 -Xms4g -Xmx4g -cp fmw_12.2.1.0.0_odi2.jar -jar fmw_12.2.1.0.0_odi.jar
   
Follow bellow screens for installation selections:
Welcome Screen: 

 Installation Location:
Use this screen to specify the location of your Oracle home directory. Make sure this should be a Middleware Weblogic server 12.2.1.0 oracle_home location, which was installed for OBIEE 12.2.1.0:

 To create the topology for Java EE or standalone colocated agents, select Enterprise Installation into an existing Oracle Home directory:








RCU Install:
  • To create the Master and Work Repository (ODI_REPO) database schemas using the Repository Creation Utility (RCU).Database schemas creation is required before configure any domain for Oracle Data Integrator agent.
  • Follow the bellow instructions:
        [obiee@obiee12c bin]$ export JAVA_HOME=/usr/java/jdk1.8.0_91
        [obiee@obiee12c bin]$ export PATH=$JAVA_HOME/bin:$PATH
        [obiee@obiee12c bin]$ echo $PATH
        [obiee@obiee12c bin]$ pwd
        /oracle/middleware/oracle_common/bin
        [obiee@obiee12c bin]$ java -version
        java version "1.8.0_91"
        Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
        Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)
        [obiee@obiee12c bin]$ ./rcu
Follow bellow screens for installation selections:




If you are running RCU from an Enterprise installation and OBIE 12.2.1.0 Repositories installed, you will see the following: 









ODI 12c Configuration (Java EE Agent) -- Adding to existing server:
 ODI configuration is very simple process, invoke config.sh for ODI configuration. Do not select create domain check box, follow the screen shots.

        [obiee@obiee12c bin]$ pwd
        /oracle/middleware/oracle_common/common/bin
        [obiee@obiee12c bin]$ ./config.sh
Follow bellow screens for Update configuration selections:
Select "Update an existing domain (Don not create new domain): 
 Select following templates, which are related to ODI:





 Select Only Managed Server to add ODI Server:

ODI Server Listen port is 15101, so all ODI server and console are using 15101 port number:









ODI 12c STOP and Start Services:
  • Scripts are all located in the $ORACLE_HOME/user_projects/domains/bi/bitools/bin directory. The scripts being
·         Start.sh for start services - Starts OBIEE and ODI servers, because ODI server added into existing domain with existing configuration.
·         Stop.sh for stop services - Stops the both servers.
·         Status.sh for Status of the services

   Start Services: 
         [obiee@obiee12c bin]$ pwd
        /oracle/middleware/user_projects/domains/bi/bitools/bin
        [obiee@obiee12c bin]$ ./start.sh



Admin Server with OBIEE and ODI:

 ODI Console:  http://192.168.40.129:15101/odiconsole/

ODI Studio Installed (Software only install) on Window 7 PC: 

11 comments:

Unknown said...

Thanks, this documentation was exactly what I needed to install ODI

Unknown said...

Hi

i followed your steps on odi installation,after odi working fine,but obiee 12c services not up
please help on that.

Unknown said...

I found you are the only one having a thorough step by step to install and configure ODI 12c.2.x on the web!

You don't know how much time I saved using your instructions.

Well done! Thanks

Kwam said...

Thanks a lot mate.
Very useful post. Been looking for something like this for awhile

@prasad - if you installed schema on a pluggable database, make sure they are up. I had the same problem after a reboot (installed on windows 2008 r2).

Unknown said...

Hi,I have got stuck with bi startup, starting all servers 0 percent,I am done startup by manually then got error with bi publisher only shutdown others are up,Some time gets oracle business intelligence has stopped working, How to resolve startup problems in obiee 12c,I have installed it in windows 7,AOs is a problem? Or it's workable only windows servers? Please help me

Unknown said...

Hi Sudheer,

I have installed OBIEE 12.2.1.0 and FMW 12.2.1.0, but didn't get ODI 12.2.1.0 Software to install.

Thanks,
Prakash

SiriM said...

Hi Sankar,

This is very illustrative. Dont you face any issue having OBIEE12c and ODI 12c on the same FMW_Home? It is giving me incorrect domainhome error whenever i do ./start.sh

@Prasad have you tried installing them in 2 different FMW_Home?

is there any work around for this issue?

Anonymous said...


Great Post,really it was very helpful for us.
Thanks a lot for sharing!
I found this blog to be very useful!!
JAVA training in Bangalore

Srinu Vasu said...

Hi, I really loved reading this article. By this article i have learnt many things about ODI topic, please keep me updating if there is any update.

ODI Online Training
ODI Classroom Training
ODI Training
ODI Training in Hyderabad
Oracle Data Integrator Training

Mrbk30 said...

Very Informative blog thank you for sharing. Keep sharing.

Best software training institute in Chennai. Make your career development the best by learning software courses.

best rpa training in chennai
Docker Training institute in Chennai
devops training in chennai

Block said...

I believe there are many more pleasurable opportunities ahead for
individuals that looked at your site.
best hadoop training in chennai
software testing courses in chennai