Oracle-L: RE: Oracle Alert to cell phone

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 25 Apr 2003 08:01:49 -0800
Message-ID: <F001.005895AC.20030425080149@fatcity.com>

Any monitoring tool worth it's salt, should in fact monitor the monitors as well (so if the system goes down, you actually get an alert to tell you that!). This is usually just a "game plan" issue (with multiple "agents" deployed on the network)..

Alert log monitoring is pretty standard in tools today as well (although there are differences between some, due to being "local", and not connected to via SQL*Net/Net8, to the alert file on some).

I've done this dig around before, here's what I came up with:

http://www.orsweb.com/downloads/source/339.html (a Perl script)
http://www.oracleadvice.com/Tips/UXalertlog.htm (a ksh script)
http://www.orafaq.com/scripts/perl/trlogmon.txt (good old orafaq with

another Perl script)
http://www.dbasupport.com/oracle/ora9i/alert_log.shtml (a PL/SQL solution)

These where the better of the scripts that I came across.. There is also a tool out that that focuses solely on alert log monitoring, though the name of it has escaped me right now (anyone else remember what it is? Begins with a z or something like that..).

Mark

-----Original Message-----

WILLIAMS
Sent: 25 April 2003 16:17
To: Multiple recipients of list ORACLE-L

Arvind

The method we've been using is to send an email to the cell phone or pager. This has the advantage that you can debug the script without driving yourself nuts. There are a number of commercial products to do this. My issue is that they tend to alert you for everything and you must go through and decide what threshold to use for each alert. If you are on Solaris, Teamquest is a general system administrator monitoring tool that can do the basics on Oracle and is pretty cheap per server. Myself, I've been trying to put together a script that scans the alert log and emails any new ORA errors that arise. I have found several scripts by Googling, but haven't been too happy with any one so far. Of course, if the tool runs on the server, and the server goes down you won't get notified. Fortunately our servers have been pretty reliable so that isn't too big an issue.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

Sent: Friday, April 25, 2003 3:17 AM
To: Multiple recipients of list ORACLE-L

hi all,

is there any tool which checks the oracle db health time to time and if finds any problem ,reports it to DBA's cell phone.

Thanks
Arvind kumar
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Arvind Kumar
INET: arvindk_at_sqlstarintl.com

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

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

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