Unable to connect to Oracle database from Oracle APM. (4044245)

Date - 10/2007
Affected Product & Version - NetVault: Backup 7.4.5 and later
Affected Module & Version - APM for Oracle (Version 5.0)
OS Version - Linux x86
Application Information - Oracle 10G


Description:
Unable to connect to Oracle database from Oracle APM.


Symptoms:
SQL*Plus connection works fine with same user and password but fails to connect browse database from Oracle APM with error -


Failed to connect to database.

Please validate database configuration and that you can connect to database with SQL*plus

- First make sure you are using the correct APM build for the relevant architecture: ie x86_64 APM version if OS is x86_64.

- Make sure that $ORACLE_HOME/lib/libclntsh.so is linked to the correct path of the Oracle library. For example,

# ls -l /lib/libclntsh.so
lrwxrwxrwx 1 oracle oinstall ... libclntsh.so -> /lib/libclntsh.so.10.1

- Also make sure that:

* /lib/orasbt.so is linked to orasbt.so under $NV_HOME/lib/orasbt.so library.

- Additionally, if "libclntsh.so.9.0" exists under /lib dir, make sure it is linked to /lib/libclntsh.so as well.