Nagios plugin for Oracle databases

27 June 2007 1 min read

check-oracle is a Nagios plugin for checking basic Oracle health checks. It previously existed as check_oracle .

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.

Examples:

Github Repo