Update to NagiosXI 5.4.1 and started getting oracle errors

[gdolidze]

The server is a 64bit vm, centos 6.7

CRITICAL - cannot connect to 67.111.179.146:1521/dtl1.digital.cjh.org. install_driver(Oracle) failed: Cant load /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so for module DBD::Oracle: libocci.so.11.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.

before the update
check_xi_oraclequery /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$
check_xi_oracleserverspace /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$
check_xi_oracletablespace /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$


after the update
check_xi_oraclequery /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$
check_xi_oracleserverspace /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$
check_xi_oracletablespace /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$

I tried
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

[tgriep]

Can you run the following on the Xi server and post the output?

Code: Select all

cat /etc/hosts
hostname

Then can you run the following and upload the /tmp/ls.txt file?

Code: Select all

ls -lR /usr/lib/oracle/ >/tmp/ls.txt
ls -l /usr/lib64/perl5/ >>/tmp/ls.txt

Also, can you post the /usr/local/nagios/etc/commands.cfg file?
Thanks

[gdolidze]

[root@nagios nagiosxi]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

[gdolidze]

Solved the issue it was such a simple over looked mistake,

check_xi_oraclequery-----------/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$

had to add the 64 to the client.

[tgriep]

Thanks for reporting back. If you don't have any other questions, shall I close and lock up this post?

[gdolidze]

you can go ahead and lock this up.