All pastes #900022 Raw Edit

hali

public shellscript v1 · immutable
·published 2008-02-11 16:47 UTC
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