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 install the Oracle Instant Client

To support the connection between BMC Database Automation and the data warehouse database, you must install the Oracle Instant Client on the Manager as follows:

1. Download the instantclient-basic-linux32-10.2.0.3-20061115.zip and instantclient-sqlplus-linux32-10.2.0.3-20061115.zip files from Oracle: http://www.oracle.com/technetwork/topics/linuxsoft-082809.html (http://www.oracle.com/technetwork/topics/linuxsoft\-082809.html) 

   Note

   To download the files, you must sign into the Oracle Technology Network (OTN).

2. Copy the files to the Manager.
3. To change to the directory for the application:
   cd /app/clarity
4. To create directories:
   mkdir oracle-instantclient-32
   mkdir oracle-instantclient-32/lib
   mkdir oracle-instantclient-32/bin
5. To change to the directory for the Oracle Instant Client:
   cd /app/clarity/oracle-instantclient-32
6. To unzip the Instant Client files, use the following format:
   unzip path/instantclient-basic-linux32-10.2.0.3-20061115.zip
   unzip path/instantclient-sqlplus-linux32-10.2.0.3-20061115.zip
   
   In this example, path is the location where the .zip files are stored.
7. To move the Instant Client files:
   mv instantclient_10_2/*.so* lib/
   mv instantclient_10_2/genezi instantclient_10_2/sqlplus instantclient_10_2/glogin.sql bin/
8. (Optional) To clean up any JAR files left behind:
   rm -fr instantclient_10_2
9. 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: