Nagios Support Forum

Having a problem getting check_oracle_health to work:

Current Status:
CRITICAL
(for 0d 0h 1m 21s)
Status Information: CRITICAL - cannot connect to 172.30.101.12:1521/prod. 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/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 /usr/local/nagios/libexec/check_oracle_health line 5877

Command line test works great

[nagios@nagios01 libexec]$ ./check_oracle_health --connect=172.30.101.12:1521/prod --username=nagios --password=z3thc0n --tablespace=SUPERVISION --mode=tnsping
OK - connection established to 172.30.101.12:1521/prod.

Nagios Check FAILING[nagios@nagios01 libexec]$ ./check_oracle_health --connect=172.30.101.12:1521/prod --username=nagios --password=z3thc0n --tablespace=SUPERVISION --mode=connected-users
OK - 17 connected users | connected_users=17;50;100

Service Configuration
define service{
use local-service
host_name devtest-db
service_description check_oracle_health_tnsping
check_command check_oracle_health!172.30.101.12:1521/prod!tnsping
notifications_enabled 1
}

Service Configuration
define service{
use local-service
host_name devtest-db
service_description check_oracle_health_connected-users
check_command check_oracle_health!172.30.101.12:1521/prod!connected-users
notifications_enabled 1
}

Command Configuration
define command {
command_name check_oracle_health
command_line $USER1$/check_oracle_health --connect=$ARG1$ --username=nagios --password=z3thc0n --tablespace=SUPERVISION --mode=$ARG2$
register 1
}

Any help would be grealty appreciated.

Derek

This gets a bit complicated from memory as you need to define environment variables as part of the check_command.

While this document is for Nagios XI, it should have the key bits of information to help you get it working:

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

Let us know how you go with this.