Oracle-L: Re: Set Email alert at NT

From: Mitchell <mitchell.lee_at_rogers.com>
Date: Fri, 21 Feb 2003 11:59:48 -0800
Message-ID: <F001.0055523F.20030221115948@fatcity.com>

The following sh is one I used for monitoring all 20 instances on unix boxes(aix and sun). So I could receive the ora message by palm. Now there are 2 nt box with Oracle 8.17 installed. I have no idea how to do it in windows. Any idea?

This is my ksh and run as cron job every 30 min.

if [$(cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log | grep 'ORA' | wc -l) -gt 0 ]; then

cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log | grep 'ORA' > $HOME/alert_me
mailx -s " Warning: ${ORACLE_SID} Oracle Alert: ORA_error !!!" mlee_at_internet.cgocable.net <mailto:mlee_at_internet.cgocable.net> < $HOME/alert_me
fi

Thanks in advance.

Mitchell

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mitchell
INET: mitchell.lee_at_rogers.com

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: ListGuru_at_fatcity.com (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). Received on Fri Feb 21 2003 - 13:59:48 CST