<html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> <div class="moz-cite-prefix">Hi, Below is the service definition for all 4 cases: define service { use generic-service host_name DBIGASDS service_description Reachability via tnsping 1 check_command check_oracle_health! --connect IGAS --username ABC --password ABC --mode=tnsping --method sqlplus contacts cosmin } define service { use generic-service host_name DBIGASDS service_description Reachability via tnsping 2 check_command check_oracle_health_tnsping contacts cosmin define service { use generic-service host_name DBIGASDS service_description Connection time to DB 1 check_command check_oracle_health!--connect IGAS --username ABC --password ABC --mode=connection-time contacts cosmin } define service { use generic-service host_name DBIGASDS service_description Connection time to DB 2 check_command check_oracle_health_time contacts cosmin And this is the command definition: define command{ command_name check_oracle_health command_line $USER1$/check_oracle_health $ARG1$ define command{ command_name check_oracle_health_tnsping command_line $USER1$/check_oracle_health_tnsping } define command{ command_name check_oracle_health_time command_line $USER1$/check_oracle_health_time BUT - a huge discovery when composing this mail. The only service definition that worked from Nagios was the one which has the undocumented argument "--method sqlplus". I think i saw on some forums the use of that paramether in the beginning, and it remained in the definition. Anyway, after adding that parammeter to all other service and command definitions, they started to work miracouslly (but still, from command line, the plugin is working without --method argument) Thank you for asking for command and service definition ;) <pre class="moz-signature" cols="72"> Cosmin Neagu NOC Team Leader Str. I. G. Duca nr. 36 Otopeni, Judetul Ilfov, 075100 Romania Tel: 021 303 3159 / 0732 669 193 <a class="moz-txt-link-abbreviated" href="http://www.omnilogic.ro">www.omnilogic.ro</a> </pre> On 11/07/2012 05:48 PM, Claudio Kuenzler wrote: </div> <blockquote cite="mid:CAF-yqgidMdzfcHxJFXpX12bV95dZfXO9P0DQS7bq0aikY+7SZw@mail.gmail.com" type="cite"> <div class="gmail_quote"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div text="#000000" bgcolor="#FFFFFF"> <div> So my question for someone who has made check_oracle_healt work is: How come all 4 invocation from CLI as nagios user work, but when Nagios runs them, only 2 of them work. I know that the error message tells me that there is some env variable path problem, but why are the first 2 calls of check_oracle_healt work then? </div> </div> </blockquote> <div> Can you, for completion, show your command definitions as well as the service definition? Just fyi: On my installation I used a different way to use --connect, I used EZCONNECT. See: <a moz-do-not-send="true" href="http://labs.consol.de/lang/de/blog/uncategorized/check_oracle_health-kann-ezconnect/">http://labs.consol.de/lang/de/blog/uncategorized/check_oracle_health-kann-ezconnect/</a> My command definition: # check_oracle_health define command { command_name check_oracle_health command_line $USER1$/check_oracle_health --username $USER3$ --password $USER4$ --mode $ARG1$ --connect $HOSTADDRESS$:$ARG2$/$ARG3$ } And one of the service definitions: # Check Oracle define service{ use generic-service host_name myoraserver service_description Oracle Connections check_command check_oracle_health!connected-users!1521!SERVICENAME } </div> <div> </div> </div> <fieldset class="mimeAttachmentHeader"></fieldset> <pre wrap="">------------------------------------------------------------------------------ LogMeIn Central: Instant, anywhere, Remote PC access and management. Stay in control, update software, and manage PCs from one command center Diagnose problems and improve visibility into emerging IT issues Automate, monitor and manage. Do more in less time with Central <a class="moz-txt-link-freetext" href="http://p.sf.net/sfu/logmein12331_d2d">http://p.sf.net/sfu/logmein12331_d2d</a></pre> <fieldset class="mimeAttachmentHeader"></fieldset> <pre wrap="">_______________________________________________ Nagios-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null</pre> </blockquote> </body> </html>