#!/bin/bash

PROGNAME=`/bin/basename $0`
PROGPATH=`echo $0 | /bin/sed -e 's,[\\/][^\\/][^\\/]*$,,'`
. $PROGPATH/utils.sh

#export PATH=$PATH:/usr/lib64/nagios/plugins:/usr/lib/nagios/plugins:/usr/lib/oracle/11.2/client64/bin
#export ORACLE_HOME=/usr/lib/oracle/11.2
#export TNS_ADMIN=/etc
#export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

USER=$1
PASS=$2
ORATNS=$3
WARNING=$4
CRITICAL=$5

OUTPUT=$(sqlplus -s $USER/$PASS@$ORATNS <<END
     set pagesize 0
     set feedback off
     set verify off
     set heading off
     set echo off;
select count(*) from testtable;
END
)

# Clean up output - remove leading and trailing whitespaces
COUNT=${OUTPUT//[[:space:]]/}

if (( "$COUNT" >= $CRITICAL )) ; then
      echo "CRITICAL - Value is $COUNT"
      exit $STATE_CRITICAL
elif (( "$COUNT" >= $WARNING )) ; then
      echo "WARNING - Value is $COUNT"
      exit $STATE_WARNING
elif (( "$COUNT" == 0 )) ; then
      echo "OK! Current Value: $COUNT"
      exit $STATE_OK
else
      echo "UNKNOWN! Company Group Check (QV). Current Value: $COUNT"
      exit $STATE_UNKNOWN
fi