Shell Programming and Scripting

#!/bin/sh
while :
do
db_check=`ps -ef|grep ${ORACLE_SID}|grep pmon|wc -l`
status=`expr $db_check`

if [ $status -lt 1 ];
then
   echo "Down" > log.txt
else
   echo "Up" > log.txt
fi

log_check=`cat log.txt | grep Up`

if [ "$log_check" = "Up" ];then
        echo "Email Up"
    else
if [ "$log_check" = "Down" ];then
       echo "Email Down"  
    fi  
fi 
done

unli loop
check database status

if database status is up 
status=up

elif database status is down 

status=down
fi

# email checker
  if $status is up 
if email_status.txt is empty or email_status.txt= down
email the database is up
up > email_status.txt
fi

  elif $status is down
if email_status.txt is empty or email_status.txt= up
email the database is down
down > email_status.txt
fi
fi

end loop

#!/bin/bash
#
# Skript to check DB status and send an email as warning
#
# Error codes:
# 0     ok
# 1     already running or lock file left over
#
# v1.0, 27.07.11
###################################################################
#set -x

DATE=`date +%Y-%m-%d", "%H:%M:%S`
SNAME=`echo $0| sed 's/^.\///'`
BASE=/home/d3xt3r
LOCKDIR=${BASE}/var/.lock
LOCKFILE=${LOCKDIR}/${SNAME}.lck
STATFILE=${BASE}/var/DB_STAT

MAILTO=d3xt3r@bla.org
INTERVAL=10

if [[ -e $LOCKFILE ]]; then
    echo "Sorry, $SNAME seems to run already; lockfile $LOCKFILE already exists."
    exit 1
else
    touch $LOCKFILE
fi

mailit()
{
    echo "$DATE - $1"
    echo "$DATE - $1"| mail -s "Database status inside..."  $MAILTO
}

writestat()
{
    echo $1 > $2
}

getstat()
{
    #DB_STAT=`ps -ef| grep -v grep| grep ${ORACLE_SID}|grep -c pmon`
    DB_STAT=`ps -ef| grep -v grep| grep -c cron`
}

## Write initial status to file
getstat
case $DB_STAT in
    "0")    writestat DOWN $STATFILE;;
    "1")    writestat UP $STATFILE;;
esac

while :; do
    getstat
    if [[ $DB_STAT > 0 ]]; then
        STAT=UP
        if [[ `cat $STATFILE` == "DOWN" ]]; then
            writestat $STAT $STATFILE
            MSG="Database is $STAT again."
            mailit "$MSG"
        else
            echo "$DATE - Database is $STAT."
        fi
        sleep $INTERVAL
        continue
    else
        STAT=DOWN
        if [[ `cat $STATFILE` == "DOWN" ]]; then
            echo "$DATE - Database is still $STAT."
        else
            writestat $STAT $STATFILE
            MSG="Database is $STAT."
            mailit "$MSG"
        fi
        sleep $INTERVAL
        continue
    fi
done

exit 0

#!/bin/bash
email_stat=stat.txt
mailbody=body.txt
mailto=dexter.com

echo "NONE" > $email_stat

while :
do

db_stat=`ps -ef|grep ${ORACLE_SID}|grep pmon|wc -l`

mail_stat=`cat stat.txt`
mail_stat="${mail_stat#"${mail_stat%%[![:space:]]*}"}"
mail_stat="${mail_stat#"${mail_stat##*[![:space:]]}"}"

if [ "$db_stat" == "1" ]; then
   if [ "$mail_stat" == "NONE" -o "$mail_stat" == "DOWN" ] 
   then
      echo "This is an email: The database is UP" > $mailbody
      echo "Do not reply on this email" | mail  -s "db status inside" $mailto < $mailbody
      echo "UP" > $email_stat
    fi
else
if [ "$mail_stat" == "NONE" -o "$mail_stat" == "UP" ] 
   then
    echo "This is an email: The database is DOWN" > $mailbody
    echo "Do not reply on this email" | mail  -s "db status inside" $mailto < $mailbody
    echo "DOWN" > $email_stat
    fi
fi
sleep 2
don