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.
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.
- Copy the files to the Manager.
- To change to the directory for the application:
cd /app/clarity
- If it is not already, set the umask to 0022:
umask
0022
- To create directories:
mkdir oracle-instantclient-32
mkdir oracle-instantclient-32/lib
mkdir oracle-instantclient-32/bin
- To change to the directory for the Oracle Instant Client:
cd /app/clarity/oracle-instantclient-32
- 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. - 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/
- (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
- Update the system dynamic linker cache:
- Create the ld.so.conf file for oic:
echo /app/clarity/oracle-instantclient-32/lib > /etc/ld.so.conf.d/oic.conf
- Refresh the linker cache:
ldconfig
- Verify that OIC libs are visible by the linker:
ldconfig -p | grep clarity
- Switch to user
clarity
and check that libs are available:
su - clarity -c '/sbin/ldconfig -p | grep clarity'
- 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.
- Create the ld.so.conf file for oic:
- 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:
Comments
Log in or register to comment.