Showing posts with label ODI/OBIEE. Show all posts
Showing posts with label ODI/OBIEE. Show all posts

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: