check_oracle_generic

Has anyone ever got this plugin to work, check_oracle_generic? It can be found at: nagiosexchange.altinity.org/n…oracle_generic

This one is stumping me. I cant get it to run through Nagios or through nrpe. nrpe returns that it cant return the output. When i configure it on the nagios server to run and go get the commands from the monitored server i get (not using nrpe) i get this errror:

**ePN failed to compile /usr/local/nagios/libexec/check_oracle_generic: "Global symbol “$SID” requires explicit package name at (eval 1) line 74,

But command line it works on both the Nagios server and the server being monitored.

Here is my checkcommands.cfg:

define command{
command_name check_oracle_generic
command_line $USER1$/check_oracle_generic -SID=$ARG1$ -dbuser=$ARG2$ -dbpassword=$ARG3$ -w=$ARG4$ -c=$ARG5$ -q=$ARG6$
}

Here is my services.cfg:

define service{
use generic-service-short
host_name server name
service_description oracle application cron
check_command check_oracle_generic!SID name!dbuser!dbpasswd!665!700!“select count(*) from c_asset_version where markup_status=‘PENDING’”

If anyone can tell me where the problem is in the way im doing this, im suspecting im missing something. If anyone can help me out with how nrpe should be set up as an alternative ill go that route as well.

Also if anyone knows of a different plugin that can perform the same query statement as this one, please let me know.

Thanks in advance

[quote=“nagiospig”][/quote]