blob: 1a4d8ab678cd5539c04cdae6a9a6fd0866c96d21 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
#!/bin/sh
#
# latigid010@yahoo.com
# 01/06/2000
#
# This Nagios plugin was created to check remote or local TNS
# status and check local Database status.
#
# Add the following lines to your object config file (i.e. commands.cfg)
# command[check-tns]=/usr/local/nagios/libexec/check_ora 1 $ARG$
# command[check-oradb]=/usr/local/nagios/libexec/check_ora 2 $ARG$
#
#
# Usage:
# To check TNS Status: ./check_ora 1 <Oracle Sid or Hostname/IP address>
# To Check local database: ./check_ora 2 <ORACLE_SID>
#
# I have the script checking for the Oracle PMON process and
# the sgadefORACLE_SID.dbf file.
#
#
# If you have any problems check that you have the $ORACLE_HOME
# enviroment variable set, have $ORACLE_HOME/bin in your PATH, and
# dont forget about your tnsnames.ora file. when checking Local
# Database status your ORACLE_SID is case sensitive.
#
PROGNAME=`basename $0`
PROGPATH=`echo $0 | sed -e 's,[\\/][^\\/][^\\/]*$,,'`
REVISION=`echo '$Revision$' | 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 --help"
echo " $PROGNAME --version"
}
print_help() {
print_revision $PROGNAME $REVISION
echo ""
print_usage
echo ""
echo "Check remote or local TNS status and check local Database 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 "--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 ""
support
}
case "$1" in
1)
cmd='--tns'
;;
2)
cmd='--db'
;;
*)
cmd="$1"
;;
esac
case "$cmd" in
--tns)
export tnschk=` tnsping $2`
export tnschk2=` echo $tnschk | grep -c OK`
export tnschk3=` echo $tnschk | cut -d\( -f7 | sed y/\)/" "/`
if [ ${tnschk2} -eq 1 ] ; then
echo "OK - reply time ${tnschk3} from $2"
exit 0
else
echo "No TNS Listener on $2"
exit $STATE_CRITICAL
fi
;;
--db)
export pmonchk=`ps -ef | grep -v grep | grep ${2} | grep -c pmon`
if [ -e $ORACLE_HOME/dbs/sga*${2}* ] ; then
if [ ${pmonchk} -eq 1 ] ; then
export utime=`ls -la $ORACLE_HOME/dbs/sga*$2* | cut -c 43-55`
echo "${2} OK - running since ${utime}"
exit $STATE_OK
fi
else
echo "${2} Database is DOWN"
exit $STATE_CRITICAL
fi
;;
--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
;;
*)
print_usage
exit $STATE_UNKNOWN
esac
|