check_oracle_health error

[bgee]

We are doing a trial with the Centros VM. Set up oracle checks yesterday, and got them to work fine. Had to restart the server this afternoon to test some other issues and now are getting this error on each oracle check:

CRITICAL - cannot connect to xxx.xxx.xxx:1521/SID. install_driver(Oracle) failed: Can't 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

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 line 4755

Since we didn't change anything, not sure what happened. Help please .

[bgee]

More info; here's the full info from one of the notifications (servername/sid changed):

CRITICAL - cannot connect to xxx.xxx.xxx:1521/SID. 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.

[sreinhardt]

Have you installed the required oracle packages? Unfortunately this is not something we can redistribute with our vm as their licensing does not permit it.
http://assets.nagios.com/downloads/nagi ... lation.pdf

[bgee]

Yes, I have installed the packages as detailed. I was able to have them work on Wednesday, but yesterday afternoon after a server restart, I began having this problem.

[abrist]

Walk back through the oracle plugin/wizard documentation. Post any errors in the install process here.

[bgee]

After removing a directory that was causing an installer script error, and reviewing each of the wizards, I found that the LD_LIBRARY_PATH and ORACLE_HOME locations had been reset to default. Upon further thinking about this, I may have downloaded a newer version of the wizards yesterday and installed.

I think this is now resolved: all Oracle services I'm checking are being monitored properly.

[abrist]

great. Good sleuthing. Closing topic, enjoy the weekend