summaryrefslogtreecommitdiffstats
path: root/plugins-scripts/check_oracle.sh
diff options
context:
space:
mode:
authorTon Voon <tonvoon@users.sourceforge.net>2003-01-29 20:47:56 +0000
committerTon Voon <tonvoon@users.sourceforge.net>2003-01-29 20:47:56 +0000
commit53cbc4f81194f8766cad96755a9820d9c3a9eafd (patch)
tree0148a2c49de649dbdbdbf18e6fea3d07b6455c28 /plugins-scripts/check_oracle.sh
parentf3764b61369571beb18e51ef8780863b1069b330 (diff)
downloadmonitoring-plugins-53cbc4f81194f8766cad96755a9820d9c3a9eafd.tar.gz
Added cache and tablespace check (621567 - John Marquart)
git-svn-id: https://nagiosplug.svn.sourceforge.net/svnroot/nagiosplug/nagiosplug/trunk@270 f882894a-f735-0410-b71e-b25c423dba1c
Diffstat (limited to 'plugins-scripts/check_oracle.sh')
-rwxr-xr-xplugins-scripts/check_oracle.sh75
1 files changed, 75 insertions, 0 deletions
diff --git a/plugins-scripts/check_oracle.sh b/plugins-scripts/check_oracle.sh
index 7e2f6f99..998899b9 100755
--- a/plugins-scripts/check_oracle.sh
+++ b/plugins-scripts/check_oracle.sh
@@ -37,6 +37,8 @@ print_usage() {
37 echo " $PROGNAME --tns <Oracle Sid or Hostname/IP address>" 37 echo " $PROGNAME --tns <Oracle Sid or Hostname/IP address>"
38 echo " $PROGNAME --db <ORACLE_SID>" 38 echo " $PROGNAME --db <ORACLE_SID>"
39 echo " $PROGNAME --login <ORACLE_SID>" 39 echo " $PROGNAME --login <ORACLE_SID>"
40 echo " $PROGNAME --cache <USER> <PASS> <INST> <CRITICAL> <WARNING>"
41 echo " $PROGNAME --tablespace <USER> <PASS> <INST> <TABLESPACE> <CRITICAL> <WARNING>"
40 echo " $PROGNAME --oranames <Hostname>" 42 echo " $PROGNAME --oranames <Hostname>"
41 echo " $PROGNAME --help" 43 echo " $PROGNAME --help"
42 echo " $PROGNAME --version" 44 echo " $PROGNAME --version"
@@ -56,6 +58,14 @@ print_help() {
56 echo " filesystem for sgadefORACLE_SID.dbf" 58 echo " filesystem for sgadefORACLE_SID.dbf"
57 echo "--login=SID" 59 echo "--login=SID"
58 echo " Attempt a dummy login and alert if not ORA-01017: invalid username/password" 60 echo " Attempt a dummy login and alert if not ORA-01017: invalid username/password"
61 echo "--cache"
62 echo " Check local database for library and buffer cache hit ratios"
63 echo " ---> Requires Oracle user/password and SID specified."
64 echo " ---> Requires select on v_$sysstat and v_$librarycache"
65 echo "--tablespace"
66 echo " Check local database for tablespace capacity in ORACLE_SID"
67 echo " ---> Requires Oracle user/password specified."
68 echo " ---> Requires select on dba_data_files and dba_free_space"
59 echo "--oranames=Hostname" 69 echo "--oranames=Hostname"
60 echo " Check remote Oracle Names server" 70 echo " Check remote Oracle Names server"
61 echo "--help" 71 echo "--help"
@@ -191,6 +201,71 @@ case "$cmd" in
191 exit $STATE_CRITICAL 201 exit $STATE_CRITICAL
192 fi 202 fi
193 ;; 203 ;;
204--cache)
205 if [ ${5} -gt ${6} ] ; then
206 echo "UNKNOWN - Warning level is less then Crit"
207 exit $STATE_UNKNOWN
208 fi
209 result=`sqlplus -s ${2}/${3}@${4} << EOF
210 set pagesize 0
211
212select (1-(pr.value/(dbg.value+cg.value)))*100 \
213from v\\$sysstat pr, v\\$sysstat dbg, v\\$sysstat cg \
214where pr.name = 'physical reads' \
215 and dbg.name='db block gets' \
216 and cg.name='consistent gets'; `
217
218 buf_hr=`echo $result | awk '{print int($1)}'`
219 result=`sqlplus -s ${2}/${3}@${4} << EOF
220 set pagesize 0
221
222select sum(lc.pins)/(sum(lc.pins)+sum(lc.reloads))*100 \
223from v\\$librarycache lc ; `
224
225 lib_hr=`echo $result | awk '{print int($1)}'`
226
227 if [ $buf_hr -le ${5} -o $lib_hr -le ${5} ] ; then
228 echo "${3} : ${4} CRITICAL - Cache Hit Rates: $lib_hr % Lib -- $buf_hr % Buff"
229 exit $STATE_CRITICAL
230 fi
231 if [ $buf_hr -le ${6} -o $lib_hr -le ${6} ] ; then
232 echo "${3} : ${4} WARNING - Cache Hit Rates: $lib_hr % Lib -- $buf_hr % Buff"
233 exit $STATE_WARNING
234 fi
235 echo "${3} : ${4} OK - Cache Hit Rates: $lib_hr % Lib -- $buf_hr % Buff"
236
237 exit $STATE_OK
238 ;;
239--tablespace)
240 if [ ${6} -lt ${7} ] ; then
241 echo "UNKNOWN - Warning level is more then Crit"
242 exit $STATE_UNKNOWN
243 fi
244 result=`sqlplus -s ${2}/${3}@${4} << EOF
245 set pagesize 0
246
247select b.free,a.total,100 - trunc(b.free/a.total * 1000) / 10 prc \
248from ( \
249select tablespace_name,sum(bytes)/1024/1024 total \
250from dba_data_files group by tablespace_name) A, \
251( select tablespace_name,sum(bytes)/1024/1024 free \
252from dba_Free_space group by tablespace_name) B \
253where a.tablespace_name=b.tablespace_name and a.tablespace_name='${5}'; `
254
255 ts_free=`echo $result | awk '{print int($1)}'`
256 ts_total=`echo $result | awk '{print int($2)}'`
257 ts_pct=`echo $result | awk '{print int($3)}'`
258 if [ $ts_pct -ge ${6} ] ; then
259 echo "${4} : ${5} CRITICAL - $ts_pct% used [ $ts_free / $ts_total MB available ]"
260 exit $STATE_CRITICAL
261 fi
262 if [ $ts_pct -ge ${7} ] ; then
263 echo "${4} : ${5} WARNING - $ts_pct% used [ $ts_free / $ts_total MB available ]"
264 exit $STATE_WARNING
265 fi
266 echo "${4} : ${5} OK - $ts_pct% used [ $ts_free / $ts_total MB available ]"
267 exit $STATE_OK
268 ;;
194*) 269*)
195 print_usage 270 print_usage
196 exit $STATE_UNKNOWN 271 exit $STATE_UNKNOWN