check_oracle

[AnotherNagiosUser]

I'm having trouble with the check_oracle plugin now. This is how it's set up at the moment.

nrpe.cfg

Code: Select all

command[check_oracle]=/usr/local/nagios/libexec/check_oracle $ARG1$

Code: Select all

define service {
        use                            generic-service
        host_name                      db1-serv
        service_description            database1
        check_command                  check_nrpe!check_oracle! '--db database1'

I get this error on nagios

(No output returned from plugin)

I think I need to specify the path to oracle in nrpe?

Code: Select all

LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client 

Not sure how I do this , or maybe i need to be doing this in the service bit.

The nagios user on the database server has the oracle enviromental settings in bash_profile.

[scottwilkerson]

Change this

Code: Select all

command[check_oracle]=/usr/local/nagios/libexec/check_oracle $ARG1$

to this

Code: Select all

command[check_oracle]=/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client /usr/local/nagios/libexec/check_oracle $ARG1$

then restart NRPE

[AnotherNagiosUser]

Change this

Code: Select all

command[check_oracle]=/usr/local/nagios/libexec/check_oracle $ARG1$

to this

Code: Select all

command[check_oracle]=/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client /usr/local/nagios/libexec/check_oracle $ARG1$

then restart NRPE

I'm still getting this message

(No output returned from plugin)
NRPE Plugin for Nagios
Copyright (c) 1999-2008 Ethan Galstad ([email protected])
Version: 2.15
Last Modified: 09-06-2013
License: GPL v2 with exemptions (-l for more info)
SSL/TLS Available: Anonymous DH Mode, OpenSSL 0.9.6 or higher required

Usage: check_nrpe -H <host> [ -b <bindaddr> ] [-4] [-6] [-n] [-u] [-p <port>] [-t <timeout>] [-c <command>] [-a <arglist...>]

[scottwilkerson]

Can you show what you have configured as your check_nrpe command on the nagios server?

[AnotherNagiosUser]

define command{
command_name check_nrpe
command_line $USER1$/check_nrpe -H $HOSTADDRESS$ -c $ARG1$ $ARG2$
}

[scottwilkerson]

So, the $ARG2$ in you service description is going to need the -a flag in it to pass the arguments, something like this

Code: Select all

define service {
        use                            generic-service
        host_name                      db1-serv
        service_description            database1
        check_command                  check_nrpe!check_oracle! -a ' --db database1'

I'm not sure what the full command you are trying to send is, but the argumnts you want to send would go in the quotes after the -a flag

[AnotherNagiosUser]

Thanks, adding the -a worked!

[scottwilkerson]

Thanks, adding the -a worked!

Excellent!

Locking thread