Installing the Oracle Instant Client

If you plan to use the BMC Database Automation reports function or BMC Decision Support for Database Automation to create reports for your environment, you must establish a data warehouse database to store the data used to create the reports. To support the connection between BMC Database Automation and the data warehouse database, you must install the Oracle Instant Client on the Manager.

To install the Oracle Instant Client

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

   Notes

   • If there is a pre-11.2 instant client currently installed, it must be removed prior to installing the 11.2 client.
   •  To download the files, you must sign into the Oracle Technology Network (OTN).
   • Only 32-bit versions of the Instant Client are supported.
2. Copy the files to the Manager.
3. To change to the directory for the application:
   cd /app/clarity
4. If it is not already, set the umask to 0022:
   umask
   0022
5. To create directories:
   mkdir oracle-instantclient-32
   mkdir oracle-instantclient-32/lib
   mkdir oracle-instantclient-32/bin
6. To change to the directory for the Oracle Instant Client:
   cd /app/clarity/oracle-instantclient-32
7. To unzip the Instant Client files, use the following format:
   unzip path/instantclient-basic-linux-11.2.0.4.0.zip
   unzip path/instantclient-sqlplus-linux-11.2.0.4.0.zip 
   
    In this example, path is the location where the .zip files are stored.
8. To move the Instant Client files:
   mv instantclient_11_2/*.so* lib/
   mv instantclient_11_2/genezi instantclient_11_2/adrci instantclient_11_2/uidrvci instantclient_11_2/sqlplus instantclient_11_2/glogin.sql bin/
9. (Optional) To clean up any JAR files left behind (this also removes everything under instantclient_11_2, which includes the sqlplus binary):
   rm -fr instantclient_11_2
10. 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:
       {{code language="none"}}
       LD_LIBRARY_PATH=/app/clarity/lib /app/clarity/perl/bin/perl -MDBI -MDBD::Oracle -e ''
       {{/code}}
       This command will return an error if something was not installed.
11. To restart the related services:
    /etc/init.d/dmanager restart
    /etc/init.d/mtd restart

As an alternative, you can 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: