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
 |
| The installation of Oracle Data Integrator 12.2.1.3.0 in Silent mode |
What we are going to learn from this post?
- Downloads
- System pre-checks
- Install Oracle JDK 8 or latest version
- Oracle Fusion Middleware Infrastructure silent mode
- Oracle Data Integrator Silent mode installation
- Verify ODI installation
Assumptions:
- You have already signed up with Oracle, which will be asked at the time of downloading the JDK and ODI 12c software
- Linux x64 bit Operating System preferable - Oracle Linux x64 7.x above
$ 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.
- Java Development Kit 8
- Oracle Fusion Middleware Infrastructure 12c
- 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 knowA. 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
