- Solutions
- Backup/synchronization
- Git
- Log files
- Nagios ® World
- Nagwin - Nagios for Windows
- winrpe - Nagios NRPE for Windows
- Nagios NRPE Plugins for Windows
- Security
- Tools
- Online services
- Support
- Store
- Login
check_oracle - NRPE check plugin for Oracle
Download:
NAME
check_oracle - Nagios NRPE plugin for basic Oracle health checks
SYNOPSIS
check_oracle
DESCRIPTION
check_oracle works as a Nagios NRPE plugin for basic Oracle health checks like tns ping, login, cache and tablespaces
OPTIONS
- --tns
-
Performs an Oracle ping on the SID/hostname by using tnsping tool, and returns CRITICAL if not succeeded. Returns respectively CRITICAL or WARNING if tns reply time is larger than critical or warning.
- --login --sid SID
-
Attempts a dummy login on the SID and returns CRITICAL if not ORA-01017: invalid username/password returns.
- --cache --sid SID --user user --password password
-
Checks local database for library and buffer cache hit ratios on the SID, by using credentials user/password to logon. Returns respectively CRITICAL or WARNING if at least one cache ratio is below critical or warning.
- --tablespace tablespace --sid SID --user user --password password
-
Checks local database for tablespace capacity of the tablespace on the SID, by using credentials user/password to logon. Returns respectively CRITICAL or WARNING if the usage percent is more than critical or warning.
- --oraclehome home path
-
check_oracle tries to locate Oracle home directory by using ORACLE_HOME env variable or values in the registry. You can use this option if you want to override plugin's path location behaviour.
- --verbose
-
Produces detailed messages for debugging.
- --help
-
Produces a help message.
EXAMPLES
check_oracle --tns --sid MYORACLE
Pings the SID MYORACLE and returns CRITICAL if not succeeded or NORMAL otherwise.
check_oracle --login --sid MYORACLE
Performs a dummy login on the SID MYORACLE and returns CRITICAL if the server answers with a message other than ORA-01017 or NORMAL otherwise.
check_oracle --cache --sid MYORACLE --user ping --password pong --warning 99 --critical 95
Logs on by using the credentials ping/pong on the SID MYORACLE, queries system tables and calculates library and buffer cache hit ratios. Returns CRITICAL if at least one of the hit ratios is below 95%, WARNING if it is below 99% or NORMAL otherwise.
check_oracle --tablespace MYTABLE --sid MYORACLE --user ping --password pong --warning 90 --critical 95
Logs on by using the credentials ping/pong on the SID MYORACLE, queries system tables and calculates the usage ratio for the tablespace MYTABLE. Returns CRITICAL if the usage is over 95%, WARNING if it is over 90%, or NORMAL otherwise.
EXIT VALUES
0 OK 1 WARNING 2 CRITICAL 3 UNKNOWN
AUTHOR
Tevfik Karagulle http://www.itefix.net
SEE ALSO
- Nagios web site http://www.nagios.org
- Nagios NRPE documentation https://assets.nagios.com/downloads/nagioscore/docs/nrpe/NRPE.pdf
- Standard Nagios plugins, check_oracle plugin
COPYRIGHT
This program is distributed under the Artistic License. https://opensource.org/licenses/artistic-license.php
VERSION
Version 1.1, May 2011