summaryrefslogtreecommitdiffstats
path: root/plugins-scripts/check_oracle.sh
diff options
context:
space:
mode:
Diffstat (limited to 'plugins-scripts/check_oracle.sh')
-rwxr-xr-xplugins-scripts/check_oracle.sh27
1 files changed, 7 insertions, 20 deletions
diff --git a/plugins-scripts/check_oracle.sh b/plugins-scripts/check_oracle.sh
index ba15dc85..85425557 100755
--- a/plugins-scripts/check_oracle.sh
+++ b/plugins-scripts/check_oracle.sh
@@ -3,21 +3,8 @@
3# latigid010@yahoo.com 3# latigid010@yahoo.com
4# 01/06/2000 4# 01/06/2000
5# 5#
6# This Nagios plugin was created to check remote or local TNS 6# This Nagios plugin was created to check Oracle status
7# status and check local Database status.
8# 7#
9# Add the following lines to your object config file (i.e. commands.cfg)
10# command[check-tns]=/usr/local/nagios/libexec/check_ora 1 $ARG$
11# command[check-oradb]=/usr/local/nagios/libexec/check_ora 2 $ARG$
12#
13#
14# Usage:
15# To check TNS Status: ./check_ora 1 <Oracle Sid or Hostname/IP address>
16# To Check local database: ./check_ora 2 <ORACLE_SID>
17#
18# I have the script checking for the Oracle PMON process and
19# the sgadefORACLE_SID.dbf file.
20#
21 8
22PROGNAME=`basename $0` 9PROGNAME=`basename $0`
23PROGPATH=`echo $0 | sed -e 's,[\\/][^\\/][^\\/]*$,,'` 10PROGPATH=`echo $0 | sed -e 's,[\\/][^\\/][^\\/]*$,,'`
@@ -43,14 +30,14 @@ print_help() {
43 echo "" 30 echo ""
44 print_usage 31 print_usage
45 echo "" 32 echo ""
46 echo "Check remote or local TNS status and check local Database status" 33 echo "Check Oracle status"
47 echo "" 34 echo ""
48 echo "--tns=SID/IP Address" 35 echo "--tns SID/IP Address"
49 echo " Check remote TNS server" 36 echo " Check remote TNS server"
50 echo "--db=SID" 37 echo "--db SID"
51 echo " Check local database (search /bin/ps for PMON process) and check" 38 echo " Check local database (search /bin/ps for PMON process) and check"
52 echo " filesystem for sgadefORACLE_SID.dbf" 39 echo " filesystem for sgadefORACLE_SID.dbf"
53 echo "--login=SID" 40 echo "--login SID"
54 echo " Attempt a dummy login and alert if not ORA-01017: invalid username/password" 41 echo " Attempt a dummy login and alert if not ORA-01017: invalid username/password"
55 echo "--cache" 42 echo "--cache"
56 echo " Check local database for library and buffer cache hit ratios" 43 echo " Check local database for library and buffer cache hit ratios"
@@ -60,7 +47,7 @@ print_help() {
60 echo " Check local database for tablespace capacity in ORACLE_SID" 47 echo " Check local database for tablespace capacity in ORACLE_SID"
61 echo " ---> Requires Oracle user/password specified." 48 echo " ---> Requires Oracle user/password specified."
62 echo " ---> Requires select on dba_data_files and dba_free_space" 49 echo " ---> Requires select on dba_data_files and dba_free_space"
63 echo "--oranames=Hostname" 50 echo "--oranames Hostname"
64 echo " Check remote Oracle Names server" 51 echo " Check remote Oracle Names server"
65 echo "--help" 52 echo "--help"
66 echo " Print this help screen" 53 echo " Print this help screen"
@@ -71,7 +58,7 @@ print_help() {
71 echo "variable is set, that ORACLE_HOME/bin is in your PATH, and the" 58 echo "variable is set, that ORACLE_HOME/bin is in your PATH, and the"
72 echo "tnsnames.ora file is locatable and is properly configured." 59 echo "tnsnames.ora file is locatable and is properly configured."
73 echo "" 60 echo ""
74 echo "When checking Local Database status your ORACLE_SID is case sensitive." 61 echo "When checking local database status your ORACLE_SID is case sensitive."
75 echo "" 62 echo ""
76 echo "If you want to use a default Oracle home, add in your oratab file:" 63 echo "If you want to use a default Oracle home, add in your oratab file:"
77 echo "*:/opt/app/oracle/product/7.3.4:N" 64 echo "*:/opt/app/oracle/product/7.3.4:N"