Here's what I use. Pretty basic (crappy) but may be a starting point for
you. You'll have to go through and change where you alert files are stored
and to whom to send the email. I schedule them to run about every 15
minutes. blat is a mail utility you can downloaded from the internet.
Check Tim Gorman's web site, http://www.evdbt.com/tools.htm. He has a script
(chk_oerr.sh) to monitor alert.log for new ORA- errors and e-mail.
You can see how it is done and come up with your own version for your own
requirements.
- Kirti
-Original Message-
Sent: Friday, March 21,
You can try a korn shell script called chkdberr.ksh at
http://www.appsdba.com/scripts/chkdberr.ksh, it's already got the email
built in.
At 10:39 AM 3/21/2003 -0800, you wrote:
Anyone have a simple script to scan an alert
log for errors and email a report if found?
Customer wants something to
Here a fast little script I wrote that can
be ran every minute
Emails only when it finds a new message
And pages if it finds a new message
between 6pm and 5am
FPATH=/prod/dba/scr
autoload f_xmail
logfile=/prod/dba/logs/`cat
/prod/dba/sys_data/newpath`/misc_logs/chk_alerts.log
Andy:
This is a very cool script.
Thanks very much!!
Barb
--- Andy Rivenes [EMAIL PROTECTED] wrote:
You can try a korn shell script called chkdberr.ksh
at
http://www.appsdba.com/scripts/chkdberr.ksh, it's
already got the email
built in.
At 10:39 AM 3/21/2003 -0800, you wrote:
Anyone