Re: probe database using OEM event or job

probe database using OEM event or jobOn unix you could do:

while true; do tnsping ALIAS > out || mail tanel_at_integrid.info < out; sleep 300; done;

(obviously you have to replace ALIAS and e-mail address there)
It will send you the tnsping output if it happens to fail. (you'll get a failure message after every 300 seconds though).

On windows, you could play around with %ERRORLEVEL% and goto cycles... You have to download sleep command though, Windows does not have such extraordinarily complicated scientific tool in standard package.

Tanel.

• Original Message ----- From: Baylis, John To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 2:14 AM Subject: 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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).