probe database using OEM event or job

Can someone help me with this?

Running Oracle 9.2.0.3 under win2000

I have an application server that occasionally looses connectivity with the listener on the database server although other application servers have no problems connecting.

I get error 'Fatal NI connect error 12535'

I would like to setup an OEM event (user defined?) or user defined job that must run from the application server having the problem which will test the connection to the listener on the database server (could be like a tnsping XXX) and if it is unsuccessful, notify me via email, pager, etc.

has anyone done this?
Can it be done with a TCL script? Any samples appreciated?

John Baylis
Database Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada

> (604) 697-6476 (Office)
> (604) 313-6054 (Cell)
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Baylis, John
  INET: JBaylis_at_mail.canfor.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).