Oracle Data Integrator Silent mode Installation

Namaste!! Welcome to Oracle Technical learnings by doing. As you know most of my experiments are easy to do on the Oracle VirtualBox and Vagrant boxes, In this experiment as well took the Oracle Linux 7 vagrant box, and which is customized by Oracle and publicly available.

What is ODI?

ODI is a powerful tool for harnessing data. It transforms, process, and manage data from complex sources.

What ODI installation contains?

 ODI Repositories - it consists of Master and Work repositories in which ODI metadata and data is stored

  ODI standalone agent- the ODI runtime process that orchestrates ETL flows

  JEE components:

•    EM FWM control plugin for ODI
•    ODI console- used to execute and monitor ODI jobs as well as browse ODI metadata 
•    JEE agent - that have full WebLogic HA capabilities, connection pool 

As Oracle Data Integrator is one of the pre-requisites for OBIEE 12c and Oracle Analytics Server (OAS). Understand the GUI based Oracle Data Integrator (ODI) 12c  installation, which can generate a responses file and it for silent mode it will be done in the following steps:

The installation of Oracle Data Integrator 12.2.1.3.0 in Silent mode

What we are going to learn from this post?

1. Downloads
2. System pre-checks
3. Install Oracle JDK 8 or latest version
4. Oracle Fusion Middleware Infrastructure silent mode
5. Oracle Data Integrator Silent mode installation
6. Verify ODI installation

Assumptions:

1. You have already signed up with Oracle, which will be asked at the time of downloading the JDK  and ODI 12c software 
2. Linux x64 bit Operating System preferable  - Oracle Linux x64 7.x above

Make sure that you have at least 16Gi memory size

$ free -g
              total        used        free      shared  buff/cache   available
Mem:             28           4           5           2          17          20
Swap:            15           2          13

Make sure you have enough disk space as well.

df -h .
Filesystem      Size  Used Avail Use% Mounted on
/dev/vdb        473G   75G  375G  17% /opt

1. Downloads

Always preferred to have the latest Oracle Critical Patch listed Java version. Here I would like to take the recent April 2020 Java 8 SE download. 

1. Java Development Kit 8
2. Oracle Fusion Middleware Infrastructure 12c
3. Oracle Data Integrator download link from OTN

for ODI 12.2.1.4 Click the downloads link as shown below:

Oracle Data Integrator 12c download

Install JDK 1.8

Download from Oracle edelivery JDK1.8.0(251) p30884160_180251_Linux-x86-64.zip

Installing latest April CPU

tar -xzvf /tmp/April2020/Jdk/1.8/jdk-8u251-linux-x64.tar.gz

Install OFMW infrastructure

Please refer to the previous Infrastructure Silent mode installation post.

[ENGINE]
Response File Version=1.0.0.0.0
[GENERIC]
ORACLE_HOME=/u01/Middleware
INSTALL_TYPE=Fusion Middleware Infrastructure
DECLINE_SECURITY_UPDATES=true
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

Now create the inventory file as oraInst.loc

inst_group=dba
inventory_loc=/home/oracle/app/oraInventory

Now we are all set to install the Middleware Infrastructure

java -jar /opt/softwares/12213_FMW_Infrastructure/fmw_12.2.1.3.0_infrastructure.jar -silent \
-responseFile /opt/softwares/12213_FMW_Infrastructure/fmw12213_infra.rsp \
-invPtrLoc /opt/softwares/12213_FMW_Infrastructure/oraInst.loc 

ODI 12c Enterprise installation 

To install Oracle Data Integrator 12c (any minor versions the same procedure). The new response file that will let the installer know

A. INSTALL_TYPE - choose any one of the choices Standalone Installation, Enterprise Installation B. ORACLE_HOME - Where you want to install

Here standalone will be a single WebLogic server to run ODI like Standalone OHS. Whereas Enterprise Install mostly used in production setups. multiple WebLogic instances will be running for ODI.

Creating a response file with the following lines:

[ENGINE]
Response File Version=1.0.0.0.0
[GENERIC]
DECLINE_AUTO_UPDATES=true
ORACLE_HOME=/u01/Middleware
INSTALL_TYPE=Enterprise Installation

You can do a trick here, Use the same oraInst.loc file used in the OFM Infrastructure by giving that path or make a copy of it.

java -jar /opt/softwares/ODI_12.2.1.3/fmw_12.2.1.3.0_odi.jar -silent \
-responseFile /opt/softwares/ODI_12.2.1.3/odi12.2.1.3_install.rsp \
-invPtrLoc /opt/softwares/ODI_12.2.1.3/oraInst.loc 

The final output will be as follows:

Oracle Data Integrator 12.2.1.3.0 Silent mode installation

Hope you enjoyed this ODI Learning post, Keep liking and sharing this to your social media to remember this wonderful activity with your learning experience If you have any ODI infrastructure related support requirement do let us know: Vybhava Technologies