Nagios Support Forum

Hi
I am trying to monitor, oracle connection but i am getting below error. can you let me know what should i do to resolve this error

./check_oracle_health --connect "sfpariapp30k-prd-001.cisco.com:1521\\XE" --username system --password "paridb" --mode connection-time --warning 1 --critical 5

CRITICAL - cannot connect to sfpariapp30k-prd-001.cisco.com:1521\XE. 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 ./check_oracle_health line 4755

This is most likely before you didn't set the correct environment variables prior to executing the plugin. Did you follow the oracle plugin install document? http://assets.nagios.com/downloads/nagi ... lation.pdf If so, please send the last two lines from the install.log file.

Can you please let me know the location of log file
Thanks

It should be in /tmp. Otherwise you can try running the following:

[root@sfparimon-prd-01 tmp]# ll /usr/lib | grep -i oracle
drwxr-xr-x 3 root root 4096 Sep 12 13:08 oracle

Was the other directory empty, and are you on an x86 server, not x64?

Yes the server is x86_64.
Oracle directory is not present in cd /usr/lib64/

Then considering it was not answered above, did you do the plugin install via our documentation? It would seem that it was not installed correctly, as on a x86_64 system you should have the oracle folder in lib64. Otherwise the .so files will not likely be compatible with your perl version.

i followed the documentation. Let me reinstall
Thanks

Sounds good, update us with how it goes.