#!/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