#!/bin/sh
#
#NADDS Agent - http://nadds.drmadcow.net/
#Oracle Database Availablility check
#Agent Author: Dustin Downs
#Date: 2003-May-26 (V1.6)

. /usr/local/bcnu/etc/bcnuenv
. $BCNUHOME/agent/agent_head

OUTFILE=$BCNUTMP/${BCNUAGENT}.out
MSGFILE=$BCNUTMP/${BCNUAGENT}.msg
TMPFILE=$BCNUTMP/${BCNUAGENT}.tmp
CONFILE=$BCNUHOME/etc/chk_oracle.conf

rm -f $OUTFILE $MSGFILE $TMPFILE 2>/dev/null

ERR=""
WARN=""

if [ -z "$LD_LIBRARY_PATH" ]; then
export LD_LIBRARAY_PATH="/lib:/usr/lib"
fi

export ORACLE_HOME=`cat $CONFILE`
export PATH=${ORACLE_HOME}/bin:${PATH}
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}

for param in $BCNUPARAM
do
bcnu_param

user=$p1
pass=$p2
sid=$p3

echo "connect $user/$pass@$sid" | $ORACLE_HOME/bin/sqlplus -S /NOLOG >$TMPFILE
grep Connected. $TMPFILE >/dev/null

result=$?

if [ $result -eq 0 ]
	then
		echo -e "OK - Connection to $sid successful\n" >>$MSGFILE		

elif [ $result -eq 1 ]
	then
		echo -e "ERROR - Connection to $sid failed" >>$MSGFILE
		cat $TMPFILE >>$MSGFILE
		ERR=1

elif [ $result -eq 2 ]
	then
		echo -e "WARNING - Output file not found" >>$MSGFILE
		WARN=1
else
		echo -e "WARNING - Unknown grep error" >>$MSGFILE
		WARN=1
fi
		
done
if [ "$ERR" -eq 1 ]
	then
	BCNUMSG="$BCNU -m 'error - DB connection failed' -f $MSGFILE -e $BCNU_ERR -t $BCNUHOSTTYPE $BCNUHOST"
	bcnu_err_send

elif [ -z "$ERR" ]
	then	
	BCNUMSG="$BCNU -m 'ok - All DB connections passed' -f $MSGFILE -e $BCNU_OK -t $BCNUHOSTTYPE $BCNUHOST"
	bcnu_send

elif [ "$WARN" -eq 1 ]
	then
	BCNUMSG="$BCNU -m 'warning - file error' -f $MSGFILE -e $BCNU_WARN -t $BCNUHOSTTYPE $BCNUHOST"
	bcnu_warn_send
fi