Anyone have a
"simple" script to scan an alert
log for errors and
email a report if found?
Customer wants
something to run "often", but only
email when an error
is found. I've got something
that does a bit of
that and runs twice a day, but
always sends
out.
Thanks.
Maks.
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
-Original Message-
From: Michael Kline
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 1:40
PM
To: Multiple recipients of list
ORACLE-L
Subject: Script to check for
errors
Anyone have a
simple script to scan an alert
log for errors and email a
report if found
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