oracle odi 11g linux install,Installing Oracle Data Integrator 11.1.1.7 in Oracle Linux 6 u3(64bit)

This blog covers installing ODI 11.1.1.7 as well as Weblogic 10.3.6.

Prerequisite:

1. Oracle database 11gR2 installed.

2. sysdba privilege of Oracle database 11gR2.

3. Check ODI 11.1.1.6 for certified JRE.

Orale Linux 6 u3 ships with open-jdk 1.6 and 1.7. Please follow the other blog to install JDK

PS:

In windows, if you installed JRE instead of JDK, ODI installation program will silently end without any alert. This makes it very hard to troubleshoot.

In Linux, you'll get an error "Invalid JRE folder" which is misleading, because what ODI installation needs is JDK, not JRE.

Referenced installation guide:

Starting RCU:

Development-nly Installation(Weblogic)

Creating a Weblogic Domain

Installing Oracle Data Integrator

1. Download the following from oracle.com.

Oracle RCU - ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1.zip

Weblogic 10.3.6 Development only package - wls1036_dev.zip

ODI 11.1.17 ofm_odi_linux_11.1.1.7.0_32_disk1_1of2.zip and ofm_odi_linux_11.1.1.7.0_32_disk1_2of2

2. Creating repository in the Oracle database

2.0 Start Oracle database:

sqlplus "/as sysdba"

startup

!lsnrctl start

SQL> show rel

release 1102000100

SQL> select name from v$database;

NAME

---------

ORCL

2.1 unzip downloaded rcu zip file.

unzip ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1.zip

cd rcuHome/bin

./rcu

2.2 Running Repository Creation Utility GUI.

select "Oracle Data Integrator" and "Oracle Business Intelligence" from the "Select Componenets" screen.

Take a note of the Master Repository and Work Repository password

Enter the following information of Oracle database.

host

port

service name

schema - sys

password

Role: sysdba

During the repository creation, several schemas will be created depending on selected componenets,

please take a note of schema and password as well.

3. Installing Weblogic 10.3.6 - Development package

3.1 Preparation

mkdir wl_home

unzip wls1036_dev.zip

cd wl_home

vi README.TXT

Follow step 1 - 4 from README.txt

vi ~/.bash_profile

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_SID=orcl; export ORACLE_SID

JAVA_HOME=/usr/java/jre1.6.0_45/; export JAVA_HOME

MW_HOME=/home/oracle/wl_home; export MW_HOME

DOMAIN_HOME=/home/oracle/mydomain/mydomain; export DOMAIN_HOME

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

source ~/.bash_profile

Make sure JVM is installed - sudo yum list installed | grep java

--Installing JVM in OL6

--sudo yum search java

--sudo yum install

--Put $JAVA_HOME into your .profile

3.2 Setup a domain

Create an Oracle database schema for Weblogic security store.

SQL > create user weblogic identified by a123456;

SQL > grant dba to weblogic;

Login Linux GUI and open a terminal.

cd $MW_HOME/wlserver/common/bin

./config.sh

From the GUI, you're required to enter:

Domain name

Domain directory

Oracle database information to save to Weblogic security store

- use the schema created in the previous step

Take a note of your weblogic admin password.

From sql*plus, run $MW_HOME/wlserver/server/lib/rdbms_security_store_oracle.sql

to create security store tables.

3.3 Start Weblogic

./$DOMAIN_HOME/startWebLogic.sh