rendered paste body#!/bin/bashWARN=$2CRIT=$3ORACLE_SID=$1ORACLE_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.shif [ -z $WARN ] || [ -z $CRIT ]|| [ $CRIT -lt $WARN ]; then echo "Paramter missing or incorrect." exit $STATE_UNKNOWNfiif [ ! -x $ORACLE_HOME/bin/sqlplus ]; then echo "Could not locate sqlplus" exit $STATE_UNKNOWNfitypeset -i USERS=`sqlplus -s / <<EOFset pages 0set feedback offselect count(*) from v\\$session/EOF`RETVAL=$?if [ $RETVAL -gt 0 ]; then echo "sqlplus failed for $ORACLE_SID from path $ORACLE_HOME" exit $STATE_UNKNOWNfiif [ $USERS -gt $CRIT ]; then echo "CRITICAL - $ORACLE_SID has $USERS open sessions.|orases=$USERS" exit $STATE_CRITICALelif [ $USERS -gt $WARN ]; then echo "WARNING - $ORACLE_SID has $USERS open sessions.|orases=$USERS" exit $STATE_WARNINGelse echo "OK - $ORACLE_SID has $USERS open sessions.|orases=$USERS" exit $STATE_OKfiecho "Hit the end, not sure whats going on."exit $STATE_UNKNOWN