Re: Monitoring alert.log

Hi Chuck

I used tail -f and awk to filter out ORA- lines and then to extract more detail as required based on the message, then xmail to send an email to the dba, and for some errors we set up exchange to forward the mail to the dba's mobile as a text message. Sorry i dont have the code as it was a few clients ago and i didnt keep it, but could write it again easilly as it was not too big. This was done on 8.1.6 on Sun solaris 2.7.

cheers

Pete Finnigan
www.pentest-limited.com

In article <9odghg$ckeu2$1_at_ID-85580.news.dfncis.de>, Chuck Hamilton <chuck_hamilton_at_yahoo.com> writes
>Has anyone ever tried to do real-time or near real-time monitoring of
>the alert log for new messages on a unix system? How did you do it? I
>want to do it but don't want to change the name of the alert log or
>copy it to some other file.
>
>What do you think of this idea. Run a cron job every few minutes
>that:
>1. appends a comment with an embedded sequential counter to the alert
>log.
>2. reads the previous sequential counter from a separate file
>3. uses sed to extract everything between the previous counter and
>the new counter and scans those lines for error messages
>4. writes the new counter to the separate file to be used as the
>starting point for the next time it runs.
>
>
>
>

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com