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. HP-UX: if [ -s "ORAerr.tmp" ] then exit fi grep ORA- /u01/app/oracle/admin/orcl/bdump/alert_sid.log > ORAerr.tmp if [ -s "ORAerr.tmp" ] then cat crlf.txt /u01/app/oracle/ORAerr.tmp | /usr/sbin/sendmail -CsendmailORA.cf -F"Oracle dbsrv1 alert error" username @company.com <mailto:[EMAIL PROTECTED]> fi WINdoze: find "ORA-" c:\orant\rdbms80\trace\*ALRT.LOG* > e:\dbwork\alerts.txt if errorlevel 1 goto NEXT rem net send dba "An ORACLE error has been found in the alert file. Please check the alerts.txt file on dbsrv2" blat e:\dbwork\alerts.txt -t dba @company.com <mailto:[EMAIL PROTECTED]> -s "Oracle (dbsrv2) alert" :NEXT find "ORA-" c:\orant\rdbms80\trace\orcl\*ALRT.LOG* > e:\dbwork\alertsorcl.txt if errorlevel 1 goto END rem net send dba "An ORACLE error has been found in the ORCL alert file. Please check the alerts.txt file on dbsrv2" blat e:\dbwork\alertsorcl.txt -t dba @company.com <mailto:[EMAIL PROTECTED]> -s "Oracle ORCL alert" erase c:\orant\rdbms80\trace\orcl\orclalrt.tmp rename c:\orant\rdbms80\trace\orcl\orclalrt.log orclalrt.tmp :END
-----Original Message----- Sent: Friday, March 21, 2003 11:40 AM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).