check_oracle_health stopped working after updating xi

[paltel]

Hello ,

I've updated nagios XI today to the latest version 5R1.0 , but oracle health plugn stopped working as it was ok before the upgrade .

I tried to reinstall using the documentation but the same error :

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

I got the following error output from GUI :

install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.12.1: cannot open shared object file: No such file or directory at /usr
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


again it was working perfectly before the upgrade , any ideas how to fix this one ?

Thanks

[hsmith]

Hi paltel,

Another user found the following:

We have resolved this, for some reason the upgrade changed the $ORACLE_HOME in the commands from `/usr/lib/oracle/11.2/client64` to `/usr/lib/oracle/11.2/client` which does not exist

from this thread.

Can you take a look at this and see if it is your issue as well?


If this is it, I'll let the developers know.

[paltel]

Yes thats right ,

upgrade reset ORACLE_HOME and LD_LIBRARY_PATH to the defaults , I had to change them again and it works .

Thanks

[hsmith]

I'll talk to the developers and see if this is a bug. Thanks for the follow up.