check_oracle work issue

wwanghongrui wwanghongrui at cebbank.com
Mon Jun 28 05:15:43 CEST 2010


Hi, 

My nagios server is  SUSE10-SP2 + NAGIOS 3.2.0 + nagios-plugins-1.4.13 .
I edit the ORACLE_HOME and other environment in /usr/local/nagios/libexec/check_oracle, and add tns items on tnsnames.ora .  Then, I use this plugin to check oracle server which running on Windows. I run the command "/usr/local/nagios/libexec/check_oracle --tns 10.1.88.9", it result 
OK - reply time 10 msec from 10.1.88.9. But, when I add service to nagios, nagios always return "No TNS Listener on 10.1.88.9". My nagios configuration is like below:
define host{
        host_name                      AAA
        use                             generic-host
        alias                           AAA_10.1.88.9
        address                         10.1.88.9
        hostgroups                      Windows_Servers
        check_command                   check-host-alive
        max_check_attempts                      3
        check_interval                  6
        active_checks_enabled           1
        check_period                    24x7
        contact_groups                  admins, Supervisors
        notification_interval           0
        notification_period             24x7
        notification_options            d,u,r,f,s
        notifications_enabled           1
}
define service{
        host_name                           AAA
        service_description           check_AAA_oracle  
        use                                 generic-service
        servicegroups                   Linux-Services-Group
        check_command                   check_oracle_tnsping!10.1.88.9
        max_check_attempts                      3
        normal_check_interval           6
        retry_check_interval            1
        active_checks_enabled           1
        check_period                    24x7
        notification_interval           0
        notification_period             24x7
        notification_options            w,u,c,r,f,s
        notifications_enabled           1
        contact_groups                  admins
}
define command{
        command_name                    check_oracle_tnsping
        command_line                    $USER1$/check_oracle --tns $ARG1$
}

Do you have some ideas on resolve this issue? Sorry my bad English.

Regards

Hrwang
mail:wwanghongrui at cebbank.com
2010-06-28
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100628/353b2124/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
-------------- 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


More information about the Users mailing list