[Nagiosplug-devel] RESOLVED pb with nrpe and check_oracle
carole verdon
verdon at cict.fr
Tue Jun 8 01:49:01 CEST 2004
Hi,
I found the solution of my problem.
In fact, in my script i use a tempory file that it don't create when i
use check_nrpe. So, i indicate a path (/tmp/_...) and now it works well.
I join again my scripts if that can interest someone.
Carole.
carole verdon wrote:
> Hi,
>
> I wrote a script, check_oracle_databases.sh, that would permit to take
> dynamically into account the file /etc/oratab to verify all databases
> that it contains.
>
> This script calls the check_oracle.sh script.
>
> On remote host (HP-UX server), the script works fine:
>
> $ /usr/local/nagios/libexec/check_oracle_databases.sh
> + /usr/local/nagios/libexec/check_oracle_databases.sh
> all databases OK
>
> but on nagios server (solaris server), it don't work.
>
> if in my check_oracle_databases.sh script i put the following lines, i
> obtain that:
> if [ $result -eq 0 ] ; then
> echo "all databases OK"
> exit $STATE_OK
> else
> echo "$result"
> echo "$database_sid Database is DOWN"
> exit $STATE_CRITICAL
> fi
>
> ./check_nrpe_nossl -H telline.cict.fr -c check_oracle
> CHECK_NRPE: No output returned from daemon.
>
> if in my check_oracle_databases.sh script i put this:
> if [ $result -eq 0 ] ; then
> echo "all databases OK"
> exit $STATE_OK
> elif [ $result -eq 1 ] ; then
> echo "$result"
> echo "$database_sid Database is DOWN"
> exit $STATE_CRITICAL
> fi
>
> I obtain :
> ./check_nrpe_nossl -H telline.cict.fr -c check_oracle
> NRPE: Unable to read output
>
>
> N.B: command defined in nrpe.cfg on remote host:
> command[check_oracle]=/usr/local/nagios/libexec/check_oracle_databases.sh
>
>
> I don't understand why nrpe (compiled without ssl) don't arrive to
> read the output of plugin. All another checks (disk, load...) work well.
>
>
> Can you help me, please? It's very urgent.
>
> Thanks.
>
> Carole.
>
>
>
>
>
>
>
>
>
>
>------------------------------------------------------------------------
>
>#! /bin/sh
>#
># latigid010 at yahoo.com
># 01/06/2000
>#
># This Nagios plugin was created to check Oracle status
>#
>
>PROGNAME=`basename $0`
>PROGPATH=`echo $0 | sed -e 's,[\\/][^\\/][^\\/]*$,,'`
>REVISION=`echo '$Revision: 1.9 $' | sed -e 's/[^0-9.]//g'`
>
>. $PROGPATH/utils.sh
>
>
>print_usage() {
> echo "Usage:"
> echo " $PROGNAME --tns <Oracle Sid or Hostname/IP address>"
> echo " $PROGNAME --db <ORACLE_SID>"
> echo " $PROGNAME --login <ORACLE_SID>"
> echo " $PROGNAME --cache <ORACLE_SID> <USER> <PASS> <CRITICAL> <WARNING>"
> echo " $PROGNAME --tablespace <ORACLE_SID> <USER> <PASS> <TABLESPACE> <CRITICAL> <WARNING>"
> echo " $PROGNAME --oranames <Hostname>"
> echo " $PROGNAME --help"
> echo " $PROGNAME --version"
>}
>
>print_help() {
> print_revision $PROGNAME $REVISION
> echo ""
> print_usage
> echo ""
> echo "Check Oracle status"
> echo ""
> echo "--tns SID/IP Address"
> echo " Check remote TNS server"
> echo "--db SID"
> echo " Check local database (search /bin/ps for PMON process) and check"
> echo " filesystem for sgadefORACLE_SID.dbf"
> echo "--login SID"
> echo " Attempt a dummy login and alert if not ORA-01017: invalid username/password"
> echo "--cache"
> echo " Check local database for library and buffer cache hit ratios"
> echo " ---> Requires Oracle user/password and SID specified."
> echo " ---> Requires select on v_$sysstat and v_$librarycache"
> echo "--tablespace"
> echo " Check local database for tablespace capacity in ORACLE_SID"
> echo " ---> Requires Oracle user/password specified."
> echo " ---> Requires select on dba_data_files and dba_free_space"
> echo "--oranames Hostname"
> echo " Check remote Oracle Names server"
> echo "--help"
> echo " Print this help screen"
> echo "--version"
> echo " Print version and license information"
> echo ""
> echo "If the plugin doesn't work, check that the ORACLE_HOME environment"
> echo "variable is set, that ORACLE_HOME/bin is in your PATH, and the"
> echo "tnsnames.ora file is locatable and is properly configured."
> echo ""
> echo "When checking local database status your ORACLE_SID is case sensitive."
> echo ""
> echo "If you want to use a default Oracle home, add in your oratab file:"
> echo "*:/opt/app/oracle/product/7.3.4:N"
> echo ""
> support
>}
>
>case "$1" in
>1)
> cmd='--tns'
> ;;
>2)
> cmd='--db'
> ;;
>*)
> cmd="$1"
> ;;
>esac
>
># Information options
>case "$cmd" in
>--help)
> print_help
> exit $STATE_OK
> ;;
>-h)
> print_help
> exit $STATE_OK
> ;;
>--version)
> print_revision $PLUGIN $REVISION
> exit $STATE_OK
> ;;
>-V)
> print_revision $PLUGIN $REVISION
> exit $STATE_OK
> ;;
>esac
>
># Hunt down a reasonable ORACLE_HOME
>if [ -z "$ORACLE_HOME" ] ; then
> # Adjust to taste
> for oratab in /var/opt/oracle/oratab /etc/oratab
> do
> [ ! -f $oratab ] && continue
> ORACLE_HOME=`IFS=:
> while read SID ORACLE_HOME junk;
> do
> if [ "$SID" = "$2" -o "$SID" = "*" ] ; then
> echo $ORACLE_HOME;
> exit;
> fi;
> done < $oratab`
> [ -n "$ORACLE_HOME" ] && break
> done
>fi
># Last resort
>[ -z "$ORACLE_HOME" -a -d $PROGPATH/oracle ] && ORACLE_HOME=$PROGPATH/oracle
>
>if [ -z "$ORACLE_HOME" -o ! -d "$ORACLE_HOME" ] ; then
> echo "Cannot determine ORACLE_HOME for sid $2"
> exit $STATE_UNKNOWN
>fi
>PATH=$PATH:$ORACLE_HOME/bin
>LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
>export ORACLE_HOME PATH LD_LIBRARY_PATH
>
>case "$cmd" in
>--tns)
> tnschk=` tnsping $2`
> tnschk2=` echo $tnschk | grep -c OK`
> if [ ${tnschk2} -eq 1 ] ; then
> tnschk3=` echo $tnschk | sed -e 's/.*(//' -e 's/).*//'`
> echo "OK - reply time ${tnschk3} from $2"
> exit $STATE_OK
> else
> echo "No TNS Listener on $2"
> exit $STATE_CRITICAL
> fi
> ;;
>--oranames)
> namesctl status $2 | awk '
> /Server has been running for:/ {
> msg = "OK: Up"
> for (i = 6; i <= NF; i++) {
> msg = msg " " $i
> }
> status = '$STATE_OK'
> }
> /error/ {
> msg = "CRITICAL: " $0
> status = '$STATE_CRITICAL'
> }
> END {
> print msg
> exit status
> }'
> ;;
>--db)
> pmonchk=`ps -ef | grep -v grep | grep ${2}$ | grep -c pmon`
> if [ ${pmonchk} -ge 1 ] ; then
> echo "0"
> #echo "${2} OK - ${pmonchk} PMON process(es) running"
> #exit $STATE_OK
> #if [ -f $ORACLE_HOME/dbs/sga*${2}* ] ; then
> #if [ ${pmonchk} -eq 1 ] ; then
> #utime=`ls -la $ORACLE_HOME/dbs/sga*$2* | cut -c 43-55`
> #echo "${2} OK - running since ${utime}"
> #exit $STATE_OK
> #fi
> else
> echo "1"
> #echo "${2} Database is DOWN"
> #exit $STATE_CRITICAL
> fi
> ;;
>--login)
> loginchk=`sqlplus dummy/user@$2 < /dev/null`
> loginchk2=` echo $loginchk | grep -c ORA-01017`
> if [ ${loginchk2} -eq 1 ] ; then
> echo "OK - dummy login connected"
> exit $STATE_OK
> else
> loginchk3=` echo "$loginchk" | grep "ORA-" | head -1`
> echo "CRITICAL - $loginchk3"
> exit $STATE_CRITICAL
> fi
> ;;
>--cache)
> if [ ${5} -gt ${6} ] ; then
> echo "UNKNOWN - Warning level is less then Crit"
> exit $STATE_UNKNOWN
> fi
> result=`sqlplus -s ${3}/${4}@${2} << EOF
>set pagesize 0
>select (1-(pr.value/(dbg.value+cg.value)))*100
>from v\\$sysstat pr, v\\$sysstat dbg, v\\$sysstat cg
>where pr.name='physical reads'
>and dbg.name='db block gets'
>and cg.name='consistent gets';
>EOF`
>
> if [ -n "`echo $result | grep ORA-`" ] ; then
> error=` echo "$result" | grep "ORA-" | head -1`
> echo "CRITICAL - $error"
> exit $STATE_CRITICAL
> fi
>
> buf_hr=`echo $result | awk '{print int($1)}'`
> result=`sqlplus -s ${3}/${4}@${2} << EOF
>set pagesize 0
>select sum(lc.pins)/(sum(lc.pins)+sum(lc.reloads))*100
>from v\\$librarycache lc;
>EOF`
>
> if [ -n "`echo $result | grep ORA-`" ] ; then
> error=` echo "$result" | grep "ORA-" | head -1`
> echo "CRITICAL - $error"
> exit $STATE_CRITICAL
> fi
>
> lib_hr=`echo $result | awk '{print int($1)}'`
>
> if [ $buf_hr -le ${5} -o $lib_hr -le ${5} ] ; then
> echo "${2} CRITICAL - Cache Hit Rates: $lib_hr% Lib -- $buf_hr% Buff"
> exit $STATE_CRITICAL
> fi
> if [ $buf_hr -le ${6} -o $lib_hr -le ${6} ] ; then
> echo "${2} WARNING - Cache Hit Rates: $lib_hr% Lib -- $buf_hr% Buff"
> exit $STATE_WARNING
> fi
> echo "${2} OK - Cache Hit Rates: $lib_hr% Lib -- $buf_hr% Buff"
>
> exit $STATE_OK
> ;;
>--tablespace)
> if [ ${6} -lt ${7} ] ; then
> echo "UNKNOWN - Warning level is more then Crit"
> exit $STATE_UNKNOWN
> fi
> result=`sqlplus -s ${3}/${4}@${2} << EOF
>set pagesize 0
>select b.free,a.total,100 - trunc(b.free/a.total * 1000) / 10 prc
>from (
>select tablespace_name,sum(bytes)/1024/1024 total
>from dba_data_files group by tablespace_name) A,
>( select tablespace_name,sum(bytes)/1024/1024 free
>from dba_free_space group by tablespace_name) B
>where a.tablespace_name=b.tablespace_name and a.tablespace_name='${5}';
>EOF`
>
> if [ -n "`echo $result | grep ORA-`" ] ; then
> error=` echo "$result" | grep "ORA-" | head -1`
> echo "CRITICAL - $error"
> exit $STATE_CRITICAL
> fi
>
> ts_free=`echo $result | awk '{print int($1)}'`
> ts_total=`echo $result | awk '{print int($2)}'`
> ts_pct=`echo $result | awk '{print int($3)}'`
> if [ $ts_free -eq 0 -a $ts_total -eq 0 -a $ts_pct -eq 0 ] ; then
> echo "No data returned by Oracle - tablespace $5 not found?"
> exit $STATE_UNKNOWN
> fi
> if [ $ts_pct -ge ${6} ] ; then
> echo "${2} : ${5} CRITICAL - $ts_pct% used [ $ts_free / $ts_total MB available ]"
> exit $STATE_CRITICAL
> fi
> if [ $ts_pct -ge ${7} ] ; then
> echo "${2} : ${5} WARNING - $ts_pct% used [ $ts_free / $ts_total MB available ]"
> exit $STATE_WARNING
> fi
> echo "${2} : ${5} OK - $ts_pct% used [ $ts_free / $ts_total MB available ]"
> exit $STATE_OK
> ;;
>*)
> print_usage
> exit $STATE_UNKNOWN
>esac
>
>
--
**********************************
VERDON Carole
Ingénieur Système
CICT - Université Paul Sabatier
118, route de Narbonne
31062 Toulouse Cedex
Tél.: 05.61.36.60.44
Fax: 05.61.52.14.58
Mail: verdon at cict.fr
**********************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nagios-plugins.org/archive/devel/attachments/20040608/e4a85266/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_oracle.sh
Type: application/x-sh
Size: 7660 bytes
Desc: not available
URL: <http://nagios-plugins.org/archive/devel/attachments/20040608/e4a85266/attachment.sh>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_oracle_databases.sh
Type: application/x-sh
Size: 2119 bytes
Desc: not available
URL: <http://nagios-plugins.org/archive/devel/attachments/20040608/e4a85266/attachment-0001.sh>
More information about the Devel
mailing list