Installing the Oracle Instant Client

If you plan to use the BMC Database Automation (BDA) 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 BDA and the data warehouse database, you must install the Oracle Instant Client on the Manager.

Important

Beginning with version 8.6, BDA supports only the 11g Instant Client (11.2.04). If you are upgrading to version 8.9 and are running pre-8.6 versions of BDA where the 10g instant client is installed, you must install the 11g instant client before upgrading. Failing to do so will result in an error during the upgrade because of the installation of a deprecated version of the client.

To install the Oracle Instant Client

Because Manager hosts generally do not require all the Oracle database prerequisites, in addition to performing the following installation steps, you should ensure that OS accounts, groups, and libraries are set up according to the Oracle installation guide.

Note

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

  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:
      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.
  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:

Example

cd /app/clarity
mkdir oracle-instantclient-32
mkdir oracle-instantclient-32/lib
mkdir oracle-instantclient-32/bin
cd /app/clarity/oracle-instantclient-32
unzip /tmp/instantclient-basic-linux-11.2.0.4.0.zip
unzip /tmp/instantclient-sqlplus-linux-11.2.0.4.0.zip
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/
rm -fr instantclient_11_2
/etc/init.d/dmanager restart
/etc/init.d/mtd restart

Was this page helpful? Yes No Submitting... Thank you

Comments