Base de Datos Distribuidas - FES ACATLAN

inst_mon.sh
#!/bin/sh
# inst_mon.sh - utility for
# database instances monitoring
ORACLE_HOME=/opt/ora/app/oracle/product/7.3.4
export ORACLE_HOME
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH
export PATH
cd /opt/ora/utils
umask 177
timeout=10
threshold=50
for SID in `cat instances.cfg | nawk ‘{print $1}’`
do
 ORACLE_SID=$SID
 export ORACLE_SID
 connect_string=`grep "^$SID" instances.cfg| nawk ‘{print $2}’`
 af=$SID.alarm
 log_file=$SID.log
 sqlplus $connect_string <>&1 > $log_file &
 sleep $timeout
 is_conn=`grep -c Connected $log_file`
 is_time_busy=`grep -c time_busy $log_file`
 if test $is_conn -ne 1
 then
    echo "Subject: Problems with " $SID "instance!" > $af
    echo "No connection in " $timeout " seconds." >> $af
    mail `cat admins.cfg` < $af   fi   if test $is_time_busy -eq 1   then      time_busy=`grep time_busy $log_file | nawk ‘{print $2}’`      if test $time_busy -gt $threshold      then         echo "Subject: Problems with " $SID "instance!" > $af
       echo "Dispatchers utilization:" $time_busy "%" >> $af
       echo "Tune MTS_MAX_DISPATCHERS!" >> $af
       mail `cat admins.cfg` < $af      fi   fi done exit 0

# posted by RDE @ 3:23 PM