Installing the Oracle Instant Client

Before you begin

Since Manager hosts do not require all the Oracle database pre-requisites, make sure that the OS accounts, groups, and libraries are set up according to the Oracle Installation Guide on the Oracle website. Additionally, perform the installation of the Oracle Instant Client.

For Multi-Manager environments, install the Oracle Instant Client on the required Satellite Managers.

To install the Oracle Instant Client

1. Download the instantclient-basic-linux-ORACLE_VERSION.zip and instantclient-sqlplus-linux-ORACLE_VERSION.zip files from the Oracle website.

   Notes

   • Before you install Instant Client 12.2, uninstall the earlier versions of Instant Client.
   • To download the files, you must sign in to the Oracle Technology Network (OTN).
   • Only 32-bit versions of the Instant Client are supported.
2. Copy the files to the Manager.
3. Change to the directory for the application:
   cd /app/clarity
4. Enter the following command to set unmask to 0022:
   umask
   0022
5. Create the following directories:
   mkdir oracle-instantclient-32
   mkdir oracle-instantclient-32/lib
   mkdir oracle-instantclient-32/bin
6. Change to the directory for the Oracle Instant Client:
   cd /app/clarity/oracle-instantclient-32
7. Use the following format to unzip the Instant Client files:
8. unzip path/instantclient-basic-linux-ORACLE_VERSION.zip
   unzip path/instantclient-sqlplus-linux-ORACLE_VERSION.zip
   In these examples, path is the location where the .zip files are stored.
9. Copy the libraries to the following path:
   cp -r instantclient_ORACLE_MAJOR_VERSION/* .so  /app/clarity/oracle-instantclient-32

1. Use the following commands to move the Oracle Instant Client files:
   mv instantclient_ORACLE_MAJOR_VERSION/*.so* lib/
   mv instantclient_ORACLE_MAJOR_VERSION/genezi instantclient_ORACLE_MAJOR_VERSION/ adrci instantclient_ORACLE_MAJOR_VERSION/uidrvci instantclient_ORACLE_MAJOR_VERSION/sqlplus instantclient_ORACLE_MAJOR_VERSION/glogin.sql bin/
2. (Optional) Clean up any JAR files left behind.
   This also removes everything under instantclient_ORACLE_MAJOR_VERSION, which includes the sqlplus binary:
   rm -fr instantclient_ORACLE_MAJOR_VERSION
3. Update the system dynamic linker cache:
   1. Create the ld.so.conf file for oic:
      echo /app/clarity/oracle-instantclient-32/lib > /etc/ld.so.conf.d/oic.conf
   2. Refresh the linker cache:
      ldconfig
   3. Verify that OIC libs are visible by the linker:
      ldconfig -p | grep clarity
   4. Switch to user clarity and check that libs are available:
      su - clarity -c '/sbin/ldconfig -p | grep clarity'
   5. Run the following command:
      LD_LIBRARY_PATH=/app/clarity/lib /app/clarity/perl/bin/perl -MDBI -MDBD::Oracle -e ''
      This command will return an error if something was not installed.
4. To restart the related services:
   /etc/init.d/dmanager restart
   /etc/init.d/mtd restart

You can also create a shell script and copy and paste the commands from steps 3 through 9. The following example assumes the .zip files are in /tmp: