Title: storing credit card numbers in a database
 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  
 
 

Reply via email to