#!/bin/bash
WARN=$2
CRIT=$3
ORACLE_SID=$1
ORACLE_HOME=`/usr/local/bin/dbhome $ORACLE_SID 2>/dev/null`
PATH="$ORACLE_HOME/bin:$PATH"
export PATH ORACLE_HOME ORACLE_SID

. /usr/local/nagios/libexec/utils.sh

if [ -z $WARN ] || [ -z $CRIT ]|| [ $CRIT -lt $WARN ]; then
        echo "Paramter missing or incorrect."
        exit $STATE_UNKNOWN
fi

if [ ! -x $ORACLE_HOME/bin/sqlplus ]; then
        echo "Could not locate sqlplus"
        exit $STATE_UNKNOWN
fi

typeset -i USERS=`sqlplus -s / <<EOF
set pages 0
set feedback off
select count(*) from v\\$session
/
EOF`
RETVAL=$?
if [ $RETVAL -gt 0 ]; then
        echo "sqlplus failed for $ORACLE_SID from path $ORACLE_HOME"
        exit $STATE_UNKNOWN
fi


if [ $USERS -gt $CRIT ]; then
        echo "CRITICAL - $ORACLE_SID has $USERS open sessions.|orases=$USERS"
        exit $STATE_CRITICAL
elif [ $USERS -gt $WARN ]; then
        echo "WARNING - $ORACLE_SID has $USERS open sessions.|orases=$USERS"
        exit $STATE_WARNING
else
        echo "OK - $ORACLE_SID has $USERS open sessions.|orases=$USERS"
        exit $STATE_OK
fi
echo "Hit the end, not sure whats going on."
exit $STATE_UNKNOWN