XE Connection Time Error

[aravindreddy114]

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

[sreinhardt]

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.

[aravindreddy114]

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

[sreinhardt]

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

Code: Select all

ll /usr/lib | grep -i oracle
ll /usr/lib64 | grep -i oracle

[aravindreddy114]

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

[sreinhardt]

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

[aravindreddy114]

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

[sreinhardt]

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.

[aravindreddy114]

i followed the documentation. Let me reinstall
Thanks

[sreinhardt]

Sounds good, update us with how it goes.