Install and Configure Oracle Instant Client

In the case of remote installation and when there is no Oracle database or client on the ODI app server, you should install Oracle Instant Client.

1. Navigate to Oracle Instant Client:
   https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
2. Scroll to “Version 19.19.0.0.0 (Requires glibc 2.14) - for OL9/RH9 only” (for LINUX 9 version).
   You need 3 files: Basic Package, SQL*Plus Package, and Tools Package (either zip or rpm).
3. Move to the Instant Client installation path:

   cd <Instant client installation path>/instantclient_19_19/
   mkdir network
   chmod 755 network

4. Navigate to the network directory and create admin directory:

   cd  network
   mkdir admin
   chmod 755 admin

5. Navigate to admin directory and place the tnsnames.ora file here from the database server.
6. Navigate back to instantclient_19_19 and create a bin directory.

   cd .. / ..
   cd <Instant client installation path>/instantclient_19_19/
   mkdir bin 
   cd bin
   ln -s ../sqlplus .
   ln -s ../impdp .
   ln -s ../sqlldr .

   The last 3 commands create shortcuts to the respective app (as shown below).

   Figure -1 Oracle Instant Client shortcuts

   
   

   

   
   
7. Create a set_env_19_9.sh script with following content:

   export ORACLE_BASE=<Instant client installation path>/instantclient_19_19
   export ORACLE_HOME=<Instant client installation path>/instantclient_19_19
   export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
   export JAVA_HOME=<JDK installation path>/jdk1.8.0_391
   export PATH=$PATH:$ORACLE_HOME:$JAVA_HOME/bin

   This script should be sourced/executed before running the OHF installer.

   After the steps above are complete, start the OHF823 DMA installation.