Nagios Support Forum

Hi,

We are getting "Service Check timedout" error for a particular Tablespace service (TSPACE - CSWAL) Whereas other Tablespace services are showing OK status.
Not sure why we are getting this error.

-bash-3.2$ ./check_oracle_basic --tnsping CSWAL
Oracle OK: Successful database tnsping test to listener.
-bash-3.2$
-bash-3.2$ ./check_oracle_basic --service CSWAL nagios xerox#12345
Oracle OK: Successful remote sqlplus login test to database via sqlnet.
-bash-3.2$
-bash-3.2$
-bash-3.2$ ./check_oracle_basic --tablespace CSWAL 85 95 nagios xerox#12345

Following is the service definition.

define service {
host_name mc0300ux006.apps.mc.xerox.com
service_description TSPACE - CSWAL
use common-notify-service
check_command common_check_db_tspace_isrve_ux006!CSWAL!85!95!!!!!
contact_groups Isrve_Group,USA BI DW PROD SUPPORT,usog90152-p,uswu51714-p
register 1
}


839 define command {
840 command_name common_check_db_tspace_isrve_ux006
841 command_line $USER1$/check_oracle_basic --tablespace $ARG1$ $ARG2$ $ARG3$ $USER38$ $USER39$
842 }

Be sure you are passing the username and password of the user who has access to that table in your service or command definition, the user MUST have access to view tables you are trying to query.