Oracle plugin works manually, but not inside NAGIOS


#1

Hi all, I’m trying to monitor my oracle DBs, I already configured the ping tests, and it works so fine. Now I configured all the Oracle SQLNET client and get the “check_oracle” plugin, I can execute successfully the command:
"./check_oracle --login PROD1"
But when I edit the cfg file to include this as a service, as below:

*define service{
host_name hostX.fgv.br
service_description LOGIN PROD1
is_volatile 0
check_period 24x7
max_check_attempts 5
normal_check_interval 1
retry_check_interval 1
contact_groups operacao
notification_options w,u,c,r
notification_interval 960
notification_period 24x7
check_command check_login_ora!PROD1
}
*

And the checkcommand.cfg

*define command{
command_name check_login_ora
command_line $USER1$/check_oracle --login $ARG1$
}
*
The result is always database down, I would appreciate any help.

Regards,
Júlio


#2

The “check_oracle” plugin unseted my ORACLE enviroment, I needed to re-export my ORA variables inside this plugin.

Júlio