Re: Set Email alert at NT

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: Peter.Mclarty_at_mincom.com
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


=================================================

A great pleasure in life is doing what people say you cannot do.

    - Walter Bagehot (1826-1877 British Economist)


=================================================

Mincom "The People, The Experience, The Vision"



=================================================


This transmission is for the intended addressee only and is confidential 
information. If you have received this transmission in error, please 
delete it and notify the sender. The contents of this e-mail are the 
opinion of the writer only and are not endorsed by the Mincom Group of 
companies unless expressly stated otherwise. 






Mitchell <mitchell.lee_at_rogers.com>
Sent by: root_at_fatcity.com
22-02-2003 05:59 AM
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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 !!!" 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: 
  INET: Peter.McLarty_at_mincom.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).