Hmmmm

grep
http://www.cs.washington.edu/homes/wolman/nt-tools/gnugrep.zip
wc                http://www.cs.washington.edu/homes/wolman/nt-tools/wc.exe
cat
http://www.cs.washington.edu/homes/wolman/nt-tools/cat.exe
mailx (use Blat)        http://www.interlog.com/~tcharron/blat.html

You may also want to use the tail command to get past previously reported
errors

tail
http://www.cs.washington.edu/homes/wolman/nt-tools/tail.exe

Then do the .bat scripting.  Not that tough really





                                                                                       
                                     
                      [EMAIL PROTECTED]                                                
                                     
                      com.com                  To:       Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>        
                      Sent by:                 cc:                                     
                                     
                      [EMAIL PROTECTED]         Subject:  Re: Set Email alert at NT    
                                      
                                                                                       
                                     
                                                                                       
                                     
                      02/25/03 07:19 AM                                                
                                     
                      Please respond to                                                
                                     
                      ORACLE-L                                                         
                                     
                                                                                       
                                     
                                                                                       
                                     




Do a rewrite in Perl to run it on Windows.
There is am smtp module for Perl that will allow you to inject an message
straight to a mail server.

You could then use that both on Unix and windows

Cheers


--
=================================================
Peter McLarty               E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=================================================


Mitchell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
22-02-2003 05:59 AM
Please respond to ORACLE-L


        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:
        Subject:        Re: Set Email alert at NT


 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 !!!"
[EMAIL PROTECTED] < $HOME/alert_me
fi


Thanks in advance.

Mitchell








-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).

Reply via email to