

<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: check_oracle</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'>#!/bin/sh
#
# latigid010@yahoo.com
# 01/06/2000
#
#  This Nagios plugin was created to check Oracle status
#

PATH=&quot;/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin&quot;
export PATH
PROGNAME=$(basename &quot;$0&quot;)
PROGPATH=$(echo &quot;$0&quot; | sed -e &#039;s,[\\/][^\\/][^\\/]*$,,&#039;)
REVISION=&quot;2.4.9&quot;
PATH=&quot;/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin&quot;

. &quot;$PROGPATH&quot;/utils.sh


print_usage() {
  echo &quot;Usage:&quot;
  echo &quot;  $PROGNAME --tns &lt;Oracle Sid or Hostname/IP address&gt;&quot;
  echo &quot;  $PROGNAME --db &lt;ORACLE_SID&gt;&quot;
  echo &quot;  $PROGNAME --login &lt;ORACLE_SID&gt;&quot;
  echo &quot;  $PROGNAME --connect &lt;ORACLE_SID&gt;&quot;
  echo &quot;  $PROGNAME --cache &lt;ORACLE_SID&gt; &lt;USER&gt; &lt;PASS&gt; &lt;CRITICAL&gt; &lt;WARNING&gt;&quot;
  echo &quot;  $PROGNAME --tablespace &lt;ORACLE_SID&gt; &lt;USER&gt; &lt;PASS&gt; &lt;TABLESPACE&gt; &lt;CRITICAL&gt; &lt;WARNING&gt;&quot;
  echo &quot;  $PROGNAME --oranames &lt;Hostname&gt;&quot;
  echo &quot;  $PROGNAME --help&quot;
  echo &quot;  $PROGNAME --version&quot;
}

print_help() {
  print_revision &quot;$PROGNAME&quot; $REVISION
  echo &quot;&quot;
  print_usage
  echo &quot;&quot;
  echo &quot;Check Oracle status&quot;
  echo &quot;&quot;
  echo &quot;--tns SID/IP Address&quot;
  echo &quot;   Check remote TNS server&quot;
  echo &quot;--db SID&quot;
  echo &quot;   Check local database (search /bin/ps for PMON process) and check&quot;
  echo &quot;   filesystem for sgadefORACLE_SID.dbf&quot;
  echo &quot;--login SID&quot;
  echo &quot;   Attempt a dummy login and alert if not ORA-01017: invalid username/password&quot;
  echo &quot;--connect SID&quot;
  echo &quot;   Attempt a login and alert if an ORA- error is returned&quot;
  echo &quot;--cache&quot;
  echo &quot;   Check local database for library and buffer cache hit ratios&quot;
  echo &quot;       ---&gt;  Requires Oracle user/password and SID specified.&quot;
  echo &quot;       		---&gt;  Requires select on v_$sysstat and v_$librarycache&quot;
  echo &quot;--tablespace&quot;
  echo &quot;   Check local database for tablespace capacity in ORACLE_SID&quot;
  echo &quot;       ---&gt;  Requires Oracle user/password specified.&quot;
  echo &quot;       		---&gt;  Requires select on dba_data_files and dba_free_space&quot;
  echo &quot;--oranames Hostname&quot;
  echo &quot;   Check remote Oracle Names server&quot;
  echo &quot;--help&quot;
  echo &quot;   Print this help screen&quot;
  echo &quot;--version&quot;
  echo &quot;   Print version and license information&quot;
  echo &quot;&quot;
  echo &quot;If the plugin doesn&#039;t work, check that the ORACLE_HOME environment&quot;
  echo &quot;variable is set, that ORACLE_HOME/bin is in your PATH, and the&quot;
  echo &quot;tnsnames.ora file is locatable and is properly configured.&quot;
  echo &quot;&quot;
  echo &quot;When checking local database status your ORACLE_SID is case sensitive.&quot;
  echo &quot;&quot;
  echo &quot;If you want to use a default Oracle home, add in your oratab file:&quot;
  echo &quot;*:/opt/app/oracle/product/7.3.4:N&quot;
  echo &quot;&quot;
  support
}

case &quot;$1&quot; in
1)
    cmd=&#039;--tns&#039;
    ;;
2)
    cmd=&#039;--db&#039;
    ;;
*)
    cmd=&quot;$1&quot;
    ;;
esac

# Information options
case &quot;$cmd&quot; in
--help)
    print_help
    exit &quot;$STATE_OK&quot;
    ;;
-h)
    print_help
    exit &quot;$STATE_OK&quot;
    ;;
--version)
    print_revision &quot;$PROGNAME&quot; $REVISION
    exit &quot;$STATE_OK&quot;
    ;;
-V)
    print_revision &quot;$PROGNAME&quot; $REVISION
    exit &quot;$STATE_OK&quot;
    ;;
esac

# Hunt down a reasonable ORACLE_HOME
if [ -z &quot;$ORACLE_HOME&quot; ] ; then
    # Adjust to taste
    for oratab in /var/opt/oracle/oratab /etc/oratab
    do
    [ ! -f $oratab ] &amp;&amp; continue
    ORACLE_HOME=`IFS=:
        while read SID ORACLE_HOME junk;
        do
            if [ &quot;$SID&quot; = &quot;$2&quot; -o &quot;$SID&quot; = &quot;*&quot; ] ; then
                echo &quot;$ORACLE_HOME&quot;;
                exit;
            fi;
        done &lt; $oratab`
    [ -n &quot;$ORACLE_HOME&quot; ] &amp;&amp; break
    done
fi
# Last resort
[ -z &quot;$ORACLE_HOME&quot; -a -d &quot;$PROGPATH&quot;/oracle ] &amp;&amp; ORACLE_HOME=$PROGPATH/oracle

if [ &quot;$cmd&quot; != &quot;--db&quot; ]; then
    if [ -z &quot;$ORACLE_HOME&quot; -o ! -d &quot;$ORACLE_HOME&quot; ] ; then
        echo &quot;Cannot determine ORACLE_HOME for sid $2&quot;
        exit &quot;$STATE_UNKNOWN&quot;
    fi
fi
PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export ORACLE_HOME PATH LD_LIBRARY_PATH

case &quot;$cmd&quot; in
--tns)
    tnschk=$(tnsping &quot;$2&quot;)
    tnschk2=$(echo &quot;$tnschk&quot; | grep -Ec &quot;^OK \([[:digit:]]+ msec\)&quot;)
    if [ &quot;${tnschk2}&quot; -eq 1 ] ; then 
        tnschk3=${tnschk##*(}; tnschk3=${tnschk3%)*}
        echo &quot;OK - reply time ${tnschk3} from $2&quot;
        exit &quot;$STATE_OK&quot;
    else
        echo &quot;No TNS Listener on $2&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi
    ;;
--oranames)
    namesctl status &quot;$2&quot; | awk &#039;
    /Server has been running for:/ {
        msg = &quot;OK: Up&quot;
        for (i = 6; i &lt;= NF; i++) {
            msg = msg &quot; &quot; $i
        }
        status = &#039;&quot;$STATE_OK&quot;&#039;
    }
    /error/ {
        msg = &quot;CRITICAL: &quot; $0
        status = &#039;&quot;$STATE_CRITICAL&quot;&#039;
    }
    END {
        print msg
        exit status
    }&#039;
    ;;
--db)
    pmonchk=$(pgrep -f &quot;(asm|ora|xe)_pmon_${2}$&quot; | wc -l)
    if [ &quot;${pmonchk}&quot; -ge 1 ] ; then
        echo &quot;${2} OK - ${pmonchk} PMON process(es) running&quot;
        exit &quot;$STATE_OK&quot;
    #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 &quot;${2} OK - running since ${utime}&quot;
            #exit $STATE_OK
        #fi
    else
        echo &quot;${2} Database is DOWN&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi
    ;;
--login)
    loginchk=$(sqlplus dummy/user@&quot;$2&quot; &lt; /dev/null)
    loginchk2=$(echo &quot;$loginchk&quot; | grep -c ORA-01017)
    if [ &quot;${loginchk2}&quot; -eq 1 ] ; then 
        echo &quot;OK - dummy login connected&quot;
        exit &quot;$STATE_OK&quot;
    else
        loginchk3=$(echo &quot;$loginchk&quot; | grep &quot;ORA-&quot; | head -1)
        echo &quot;CRITICAL - $loginchk3&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi
    ;;
--connect)
    connectchk=$(sqlplus &quot;$2&quot; &lt; /dev/null)
    connectchk2=$(echo &quot;$connectchk&quot; | grep -c ORA-)
    if [ &quot;${connectchk2}&quot; -eq 0 ] ; then
        echo &quot;OK - login successful&quot;
        exit &quot;$STATE_OK&quot;
    else
        connectchk3=$(echo &quot;$connectchk&quot; | grep &quot;ORA-&quot; | head -1)
        echo &quot;CRITICAL - $connectchk3&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi
    ;;
--cache)
    if [ &quot;${5}&quot; -gt &quot;${6}&quot; ] ; then
        echo &quot;UNKNOWN - Warning level is less then Crit&quot;
        exit &quot;$STATE_UNKNOWN&quot;
    fi
    result=`sqlplus -s &quot;${3}&quot;/&quot;${4}&quot;@&quot;${2}&quot; &lt;&lt; EOF
set pagesize 0
set numf &#039;9999999.99&#039;
select (1-(pr.value/(dbg.value+cg.value)))*100
from v\\$sysstat pr, v\\$sysstat dbg, v\\$sysstat cg
where pr.name=&#039;physical reads&#039;
and dbg.name=&#039;db block gets&#039;
and cg.name=&#039;consistent gets&#039;;
EOF`

    if echo &quot;$result&quot; | grep -q &#039;ORA-&#039; ; then
        error=$(echo &quot;$result&quot; | grep &quot;ORA-&quot; | head -1)
        echo &quot;CRITICAL - $error&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi

    buf_hr=$(echo &quot;$result&quot; | awk &#039;/^[0-9\. \t]+$/ {print int($1)}&#039;)
    buf_hrx=$(echo &quot;$result&quot; | awk &#039;/^[0-9\. \t]+$/ {print $1}&#039;)
    result=`sqlplus -s &quot;${3}&quot;/&quot;${4}&quot;@&quot;${2}&quot; &lt;&lt; EOF
set pagesize 0
set numf &#039;9999999.99&#039;
select sum(lc.pins)/(sum(lc.pins)+sum(lc.reloads))*100
from v\\$librarycache lc;
EOF`

    if echo &quot;$result&quot; | grep -q &#039;ORA-&#039; ; then
        error=$(echo &quot;$result&quot; | grep &quot;ORA-&quot; | head -1)
        echo &quot;CRITICAL - $error&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi

    lib_hr=$(echo &quot;$result&quot; | awk &#039;/^[0-9\. \t]+$/ {print int($1)}&#039;)
    lib_hrx=$(echo &quot;$result&quot; | awk &#039;/^[0-9\. \t]+$/ {print $1}&#039;)

    if [ &quot;$buf_hr&quot; -le &quot;${5}&quot; -o &quot;$lib_hr&quot; -le &quot;${5}&quot; ] ; then
        echo &quot;${2} CRITICAL - Cache Hit Rates: $lib_hrx% Lib -- $buf_hrx% Buff|lib=$lib_hrx%;${6};${5};0;100 buffer=$buf_hrx%;${6};${5};0;100&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi
    if [ &quot;$buf_hr&quot; -le &quot;${6}&quot; -o &quot;$lib_hr&quot; -le &quot;${6}&quot; ] ; then
        echo &quot;${2} WARNING  - Cache Hit Rates: $lib_hrx% Lib -- $buf_hrx% Buff|lib=$lib_hrx%;${6};${5};0;100 buffer=$buf_hrx%;${6};${5};0;100&quot;
        exit &quot;$STATE_WARNING&quot;
    fi
    echo &quot;${2} OK - Cache Hit Rates: $lib_hrx% Lib -- $buf_hrx% Buff|lib=$lib_hrx%;${6};${5};0;100 buffer=$buf_hrx%;${6};${5};0;100&quot;

    exit &quot;$STATE_OK&quot;
    ;;
--tablespace)
    if [ &quot;${6}&quot; -lt &quot;${7}&quot; ] ; then
        echo &quot;UNKNOWN - Warning level is more then Crit&quot;
        exit &quot;$STATE_UNKNOWN&quot;
    fi
    result=`sqlplus -s &quot;${3}&quot;/&quot;${4}&quot;@&quot;${2}&quot; &lt;&lt; EOF
set pagesize 0
set numf &#039;9999999.99&#039;
select NVL(b.free,0.0),a.total,100 - trunc(NVL(b.free,0.0)/a.total * 1000) / 10 prc
from (
select tablespace_name,sum(bytes)/1024/1024 total
from dba_data_files group by tablespace_name) A
LEFT OUTER JOIN
( select tablespace_name,sum(bytes)/1024/1024 free
from dba_free_space group by tablespace_name) B
ON a.tablespace_name=b.tablespace_name WHERE a.tablespace_name=&#039;${5}&#039;;
EOF`

    if echo &quot;$result&quot; | grep -q &#039;ORA-&#039;; then
        error=$(echo &quot;$result&quot; | grep &#039;ORA-&#039; | head -1)
        echo &quot;CRITICAL - $error&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi

    ts_free=$(echo &quot;$result&quot; | awk &#039;/^[ 0-9\.\t ]+$/ {print int($1)}&#039;)
    ts_total=$(echo &quot;$result&quot; | awk &#039;/^[ 0-9\.\t ]+$/ {print int($2)}&#039;)
    ts_pct=$(echo &quot;$result&quot; | awk &#039;/^[ 0-9\.\t ]+$/ {print int($3)}&#039;)
    ts_pctx=$(echo &quot;$result&quot; | awk &#039;/^[ 0-9\.\t ]+$/ {print $3}&#039;)
    if [ &quot;$ts_free&quot; -eq 0 -a &quot;$ts_total&quot; -eq 0 -a &quot;$ts_pct&quot; -eq 0 ] ; then
        echo &quot;No data returned by Oracle - tablespace $5 not found?&quot;
        exit &quot;$STATE_UNKNOWN&quot;
    fi
    if [ &quot;$ts_pct&quot; -ge &quot;${6}&quot; ] ; then
        echo &quot;${2} : ${5} CRITICAL - $ts_pctx% used [ $ts_free / $ts_total MB available ]|${5}=$ts_pctx%;${7};${6};0;100&quot;
        exit &quot;$STATE_CRITICAL&quot;
    fi
    if [ &quot;$ts_pct&quot; -ge &quot;${7}&quot; ] ; then
        echo &quot;${2} : ${5} WARNING  - $ts_pctx% used [ $ts_free / $ts_total MB available ]|${5}=$ts_pctx%;${7};${6};0;100&quot;
        exit &quot;$STATE_WARNING&quot;
    fi
    echo &quot;${2} : ${5} OK - $ts_pctx% used [ $ts_free / $ts_total MB available ]|${5}=$ts_pctx%;${7};${6};0;100&quot;
    exit &quot;$STATE_OK&quot;
    ;;
*)
    print_usage
    exit &quot;$STATE_UNKNOWN&quot;
esac
</textarea><br><br><input type='hidden' name='archivo_editar' value='/usr/lib64/nagios/plugins/check_oracle'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fusr%2Flib64%2Fnagios%2Fplugins' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>