summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rwxr-xr-xplugins-scripts/check_oracle.sh17
1 files changed, 10 insertions, 7 deletions
diff --git a/plugins-scripts/check_oracle.sh b/plugins-scripts/check_oracle.sh
index 2ac01ba..1a23eb9 100755
--- a/plugins-scripts/check_oracle.sh
+++ b/plugins-scripts/check_oracle.sh
@@ -158,7 +158,7 @@ case "$cmd" in
158 }' 158 }'
159 ;; 159 ;;
160--db) 160--db)
161 pmonchk=`ps -ef | grep -v grep | grep "^${2}$" | grep -c pmon` 161 pmonchk=`ps -ef | grep -v grep | grep ${2} | grep -c pmon`
162 if [ ${pmonchk} -ge 1 ] ; then 162 if [ ${pmonchk} -ge 1 ] ; then
163 echo "${2} OK - ${pmonchk} PMON process(es) running" 163 echo "${2} OK - ${pmonchk} PMON process(es) running"
164 exit $STATE_OK 164 exit $STATE_OK
@@ -207,6 +207,7 @@ EOF`
207 fi 207 fi
208 208
209 buf_hr=`echo "$result" | awk '/^[0-9\. \t]+$/ {print int($1)}'` 209 buf_hr=`echo "$result" | awk '/^[0-9\. \t]+$/ {print int($1)}'`
210 buf_hrx=`echo "$result" | awk '/^[0-9\. \t]+$/ {print $1}'`
210 result=`sqlplus -s ${3}/${4}@${2} << EOF 211 result=`sqlplus -s ${3}/${4}@${2} << EOF
211set pagesize 0 212set pagesize 0
212set numf '9999999.99' 213set numf '9999999.99'
@@ -221,16 +222,17 @@ EOF`
221 fi 222 fi
222 223
223 lib_hr=`echo "$result" | awk '/^[0-9\. \t]+$/ {print int($1)}'` 224 lib_hr=`echo "$result" | awk '/^[0-9\. \t]+$/ {print int($1)}'`
225 lib_hrx=`echo "$result" | awk '/^[0-9\. \t]+$/ {print $1}'`
224 226
225 if [ $buf_hr -le ${5} -o $lib_hr -le ${5} ] ; then 227 if [ $buf_hr -le ${5} -o $lib_hr -le ${5} ] ; then
226 echo "${2} CRITICAL - Cache Hit Rates: $lib_hr% Lib -- $buf_hr% Buff" 228 echo "${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"
227 exit $STATE_CRITICAL 229 exit $STATE_CRITICAL
228 fi 230 fi
229 if [ $buf_hr -le ${6} -o $lib_hr -le ${6} ] ; then 231 if [ $buf_hr -le ${6} -o $lib_hr -le ${6} ] ; then
230 echo "${2} WARNING - Cache Hit Rates: $lib_hr% Lib -- $buf_hr% Buff" 232 echo "${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"
231 exit $STATE_WARNING 233 exit $STATE_WARNING
232 fi 234 fi
233 echo "${2} OK - Cache Hit Rates: $lib_hr% Lib -- $buf_hr% Buff" 235 echo "${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"
234 236
235 exit $STATE_OK 237 exit $STATE_OK
236 ;; 238 ;;
@@ -260,19 +262,20 @@ EOF`
260 ts_free=`echo "$result" | awk '/^[ 0-9\.\t ]+$/ {print int($1)}'` 262 ts_free=`echo "$result" | awk '/^[ 0-9\.\t ]+$/ {print int($1)}'`
261 ts_total=`echo "$result" | awk '/^[ 0-9\.\t ]+$/ {print int($2)}'` 263 ts_total=`echo "$result" | awk '/^[ 0-9\.\t ]+$/ {print int($2)}'`
262 ts_pct=`echo "$result" | awk '/^[ 0-9\.\t ]+$/ {print int($3)}'` 264 ts_pct=`echo "$result" | awk '/^[ 0-9\.\t ]+$/ {print int($3)}'`
265 ts_pctx=`echo "$result" | awk '/^[ 0-9\.\t ]+$/ {print $3}'`
263 if [ "$ts_free" -eq 0 -a "$ts_total" -eq 0 -a "$ts_pct" -eq 0 ] ; then 266 if [ "$ts_free" -eq 0 -a "$ts_total" -eq 0 -a "$ts_pct" -eq 0 ] ; then
264 echo "No data returned by Oracle - tablespace $5 not found?" 267 echo "No data returned by Oracle - tablespace $5 not found?"
265 exit $STATE_UNKNOWN 268 exit $STATE_UNKNOWN
266 fi 269 fi
267 if [ "$ts_pct" -ge ${6} ] ; then 270 if [ "$ts_pct" -ge ${6} ] ; then
268 echo "${2} : ${5} CRITICAL - $ts_pct% used [ $ts_free / $ts_total MB available ]" 271 echo "${2} : ${5} CRITICAL - $ts_pctx% used [ $ts_free / $ts_total MB available ]|${5}=$ts_pctx%;${7};${6};0;100"
269 exit $STATE_CRITICAL 272 exit $STATE_CRITICAL
270 fi 273 fi
271 if [ "$ts_pct" -ge ${7} ] ; then 274 if [ "$ts_pct" -ge ${7} ] ; then
272 echo "${2} : ${5} WARNING - $ts_pct% used [ $ts_free / $ts_total MB available ]" 275 echo "${2} : ${5} WARNING - $ts_pctx% used [ $ts_free / $ts_total MB available ]|${5}=$ts_pctx%;${7};${6};0;100"
273 exit $STATE_WARNING 276 exit $STATE_WARNING
274 fi 277 fi
275 echo "${2} : ${5} OK - $ts_pct% used [ $ts_free / $ts_total MB available ]" 278 echo "${2} : ${5} OK - $ts_pctx% used [ $ts_free / $ts_total MB available ]|${5}=$ts_pctx%;${7};${6};0;100"
276 exit $STATE_OK 279 exit $STATE_OK
277 ;; 280 ;;
278*) 281*)