Here's something that was posted to the forum about 6 months ago...
RE: [WhatsUp Forum] TNS PingI asked this a while back. Someone gave me this answer,
and it works for me.
A while back somebody did the research and actually got the connect string that
tnsping uses to check oracle.
It has worked for us for about 90% of our Oracle base. This works on any platform
running standard oracle listener on 1521.
Just copy and paste the following in to the services.ini in your Whatsup directory.
Good luck.
Regards,
Juan
[Oracle]
CLSID={72B6D231-D71E-11d2-8F74-0040054D7C1D}
Lines=2
Line000=Send=%0%87%0%0%1%0%0%0%1%54%1%44%0%0%8%0%127%255%163%10%0%0%1%0%0%29%0%58%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%2%8%0%0%0%1%0%0%0%0%0%0%0%0(CONNECT_DATA=(COMMAND=ping))
Line001=Expect=.*DESCRIPTION.*LISTENER.*
TYPE=0
PORT=1521
TIMEOUT=5
UseInDiscovery=true
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Simms
Sent: Thursday, March 11, 2004 10:29
To: '[EMAIL PROTECTED]'
Subject: [WhatsUp Forum] Custom Monitor in WhatsUp Gold v8
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/
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/
