Re: Set Email alert at NT

Thanks for your reply.

Yes. you are right. There is another line after send out ' mv alert_oraclesid newnaem.{date}'
There is another cron job for logflip at 12:00am everday

Mitchell

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, February 21, 2003 4:08 PM

>
> Use the NT 'AT' command to schedule a .bat file to skim your
> alert log and use BLAT (Public Domain SMTP utility) instead of
> mailx. As mentioned in the last few days batch file scripting
> is a poor substitute for a real shell but it's all do-able. The
> other problem is how to get rid of an error from the alert file
> after it has emailed you once....you haven't said how you do this
> on your Unix box...looks like it will keep emailing you the
> same error every 30 minutes, but I could be missing something =8-)
>
>
> HTH
>
> Jeff Herrick
>
> On Fri, 21 Feb 2003, Mitchell wrote:
>
> > Hi
> >
> > 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: Jeff Herrick
> INET: jherrick_at_igs.net
>
> 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).
>

-- 
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).