Hi,
I am trying to set up a custom monitor to tell me if my Oracle TNS Listener
is operating.
If I was on the command line, I would type in:
TNSPING <service name>
The response for a successful TNSPING (Run from the WhatsUp Server) would be
like this:
TNS Ping Utility for 32-bit Windows: Version 9.2.0.4.0 - Production
on 11-MAR-20
04 10:24:58
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
<path to SQLNET Directory>\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)
(HOST = <ip address>)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME =
<service name>)))
OK (140 msec)
I am looking for the "OK" on the last line.
I went in WhatsUp Gold v8 --> Configure --> Monitors & Services --> New
Service Name: TNS-Listener
Service Type: TCP/IP Service
Network Type: TCP
Port Number: 1521
Timeout: 5
Script:
SEND=TNSPING <service name>
Expect=~.*OK.*
I then set this service to be checked during polling.
I ran the debug log during polling and got this response:
Checking <machine name> : 02 : TNS-Listener
[<ip address>] >>> TCP COHS CHECK 1521 on <ip address>
[<ip address>] connected
[<ip address>] >>> TCP COHS CHECK 1521 on <ip address>
[<ip address>] 000: Send=TNSPING <service name>
TNSPING <service name>
[<ip address>] 001: Expect=~.*OK.*
[<ip address>] <<< TCP COHS EXIT=14
TCP/IP Service check complete. FAILED
Check Complete (-1) <machine name> : 02 : TNS-Listener
I know the service is currently running, but WhatsUp continues to say that
the service is down.
Can anyone shed any light on what I'm doing wrong or tell me a better way to
do this?
Regards,
David S Simms
Developer
ASM Research, Inc.
Fairfax, VA 22031
[EMAIL PROTECTED]
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
