Re: Alert Log Monitoring / Notification

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Mon, 8 Mar 2004 23:44:21 -0600
Message-ID: <%Lc3c.101521$Tn.16842@bignews5.bellsouth.net>

We use a simple Unix bourne script that basically does:

- on first run, just copy alert.log to a different file
- on subsequent runs, do the following...
- run the Unix diff command on the copy and the current alert.logs
- process the diff command output and strip out "ok messages"
- email the rest (not ok) messages
- before copying the log to the different file, check the size and if

gettting too large (100K, 10K, whatever) - if the file is getting too large, copy it off to another location for archiving and zero out the current log file by doing command - cat /dev/null > alert_SID.log

By keeping the size of the alert.log small, you can run the above script very often and not even notice it.

We run with the max size to check for of 100K and have not had any problems running every 5 minutes 7x24.

You may want to make the maxsize 24K and run every 1 or 2 minutes.

Obviously, test test test the above ....

Note: A nice thing about the above is when the server/machine reboots, you don't loose a thing in monitoring the alert.log.

-- 

"Charles Davis" <cdavis10717_at_comcast.net> wrote in message
news:Y_ydnUWWlpL5adHd4p2dnA_at_comcast.com...


> All,

>

> I would like to be notified almost immediately if Oracle 9.2 writes

certain


> messages to the Alert Log, such as any of the 'unable to extend' messages.

> An email sent at the moment of the error would be best.

>

> Can this be done somehow within Oracle v9.2??  If so, please describe it

or


> point me to the docs on this.

>

> I already have an external alert log monitor process, but am looking for

> something more immediate that its polling interval.

>

> Many thanks.

>

> charles

>

>

>

Received on Mon Mar 08 2004 - 23:44:21 CST