check_oracle

[hanya.radwan]

hi,

on Nagios 2014 R1.0, oracle service failed as following:
[root@nms ~]# /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client /usr/local/nagios/libexec/check_oracle_health.txt --connect "10.100.1.176:1521/ppcalls" --username nagios_appl --password "m0n_4jawwalppcalls50937" --mode tablespace-usage --report short --warning 87 --critical 95
CRITICAL - cannot connect to 10.100.1.176:1521/ppcalls. 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 18) line 3
Compilation failed in require at (eval 18) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/nagios/libexec/check_oracle_health.txt line 4755

[root@nms ~]# telnet 10.100.1.176 1521
Trying 10.100.1.176...
Connected to 10.100.1.176.

[slansing]

Is the DBD Oracle perl module installed?:

Code: Select all

cpan

Once in CPAN run-

Code: Select all

install DBD::Oracle

[hanya.radwan]

I install oracle again:

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle//client64/lib ORACLE_HOME=/usr/lib/oracle//client64 /usr/local/nagios/libexec/check_oracle_health --connect "10.100.1.176:1521/ppcalls" --username nagios_appl --password "m0n_4jawwalppcalls50937" --mode sql --name 'select%20count%28%2A%29%20from%20v%24session%20where%20status%20%3D%20%27ACTIVE%27 ' --warning 300 --critical 400

CRITICAL - cannot connect to 10.100.1.176:1521/ppcalls. 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 /usr/local/nagios/libexec/check_oracle_health line 4755

[nealg]

I'm experiencing the same issue after upgrading to NAGIOS XI 2014R1.1. Did we ever find a fix? I've read over the Oracle plugin Install document and everything looks good to me.

[hanya.radwan]

I tried again to install oracle plugin again, but the same problem still

[nealg]

IT was a path issues with the environment variables that changed somehow during the upgrade. Added a 64 to the end of of both variables for the command.

FROM: /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$

TO: /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 $USER1$/check_oracle_health $ARG1$

[hanya.radwan]

I did that, but the problem still

[lmiltchev]

Run the following commands and show us the output:

Code: Select all

yum list installed | grep oracle
whereis oracle

Go to CCM->Commands->type "oracle" in the "search" bar, hit "Enter" and show us a screenshot of this page.

[hanya.radwan]

command.png

please find the result of the command:
[root@nms ~]# yum list installed | grep oracle
oracle-instantclient12.1-basic.x86_64 12.1.0.1.0-1 @/oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64
oracle-instantclient12.1-devel.x86_64 12.1.0.1.0-1 @/oracle-instantclient12.1-devel-12.1.0.1.0-1.x86_64
oracle-instantclient12.1-sqlplus.x86_64
12.1.0.1.0-1 @/oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.x86_64
[root@nms ~]# whereis oracle
oracle: /usr/lib/oracle /usr/include/oracle /usr/share/oracle
[root@nms ~]#

[hanya.radwan]

done after change oracle to 12.1