Monitoring Oracle DB's

[MSPk]

Hi Team,

We are trying to monitoring Oracle DB for a client (Its actually a PoC, we are implementing to showcase the capabilities of Nagios).

Our Nagios Server is built on Cent OS 6.4(64 bit) and I have already installed the below RPM's as suggested in your admin guide.

oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-devel-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm

In Addition to this I have also installed the below packages and the DBD::Oracle (1.70) perl library

libdbi-0.8.3-4.el6.x86_64
libdbi-drivers-0.8.3-5.1.el6.x86_64
perl-DBI-1.609-4.el6.x86_64

I have copied the below variables into the Check_xi_oracleserver commands.

ORACLE_HOME=/usr/lib/oracle/12.1/client64
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib

now I have run a test command as below

./check_oracle_health --connect xx.xxx.xxx.xxx --username nagios --password somepwd --mode tnsping

I get the below error message.

CRITICAL - cannot connect to xx.xxx.xxx.xxx. install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.12.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
at (eval 19) line 3
Compilation failed in require at (eval 19) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./check_oracle_health line 4755

the same error message comes even if I try any other mode, please suggest if we have missed on anything. Appreciate a quick reply on this as we need to demo our PoC this weekend.

[slansing]

Hmm, did the DBD::Oracle module actually install properly? Can you run through this section again:

Code: Select all

export ORACLE_HOME=<path to your Oracle which was given by the script>
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
cpan -i DBD::Oracle

[MSPk]

I did try that again, I get a message saying that the DBD:Oracle is already installed(1.70).

[MSPk]

This is the exact msg I get

CPAN: Storable loaded ok (v2.20)
Going to read '/root/.cpan/Metadata'
Database was generated on Mon, 17 Feb 2014 09:41:02 GMT
DBD::Oracle is up to date (1.70).

[slansing]

I came across a good post here, let us know if this helps:

http://stackoverflow.com/questions/8657 ... ed-library

[MSPk]

We have managed to resolve this issue and are now able to monitor Oracle DB's.

we just had to add the hostname of our monitoring server in the /etc/hosts file. Check below link.

http://chaos667.tumblr.com/post/2000635 ... lient-11-2


Close this thread as solved.