Plugin check_oracle_health

[Cosmin Neagu]

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 ;)



  Cosmin Neagu
  NOC Team Leader
  Str. I. G. Duca nr. 36
  Otopeni, Judetul Ilfov, 075100 Romania
  Tel: 021 303 3159 / 0732 669 193
  www.omnilogic.ro

On 11/07/2012 05:48 PM, Claudio Kuenzler wrote:
>
>     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?
>
>
> 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: 
> http://labs.consol.de/lang/de/blog/uncategorized/check_oracle_health-kann-ezconnect/
>
> 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
>         }
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
> http://p.sf.net/sfu/logmein12331_d2d
>
>
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20121108/cac56528/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null