Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

check_oracle_v2

Rating
0 votes
Favoured:
0
Compatible With
  • Nagios 3.x
Hits
101216
Files:
FileDescription
check_oraclePlugin
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
This check_oracle plugin is the same as check_oracle embbeded in Nagios Plugins Package (v1.4.14), BUT THIS ONE IS CAPPABLE TO MONITOR TEMP TABLESPACES TOO.
The nagios plugins come with ABSOLUTELY NO WARRANTY. You may redistribute
copies of the plugins under the terms of the GNU General Public License.
For more information about these matters, see the file named COPYING.

Usage:
check_oracle --tns
check_oracle --db
check_oracle --login
check_oracle --cache
check_oracle --tablespace
check_oracle --oranames
check_oracle --help
check_oracle --version

Check Oracle status

--tns SID/IP Address
Check remote TNS server
--db SID
Check local database (search /bin/ps for PMON process) and check
filesystem for sgadefORACLE_SID.dbf
--login SID
Attempt a dummy login and alert if not ORA-01017: invalid username/password
--cache
Check local database for library and buffer cache hit ratios
---> Requires Oracle user/password and SID specified.
---> Requires select on v_$sysstat and v_$librarycache
--tablespace
Check local database for tablespace capacity in ORACLE_SID
---> Requires Oracle user/password specified.
---> Requires select on dba_data_files,dba_tablespaces,dba_free_space and V_$temp_space_header (Updated by Eduardo Valentim)
--oranames Hostname
Check remote Oracle Names server
--help
Print this help screen
--version
Print version and license information

If the plugin doesn't work, check that the ORACLE_HOME environment
variable is set, that ORACLE_HOME/bin is in your PATH, and the
tnsnames.ora file is locatable and is properly configured.

When checking local database status your ORACLE_SID is case sensitive.

If you want to use a default Oracle home, add in your oratab file:
*:/opt/app/oracle/product/7.3.4:N

*****
UPDATE - 06/07/2010 - This script now read temporary tablespaces information. Updated by Eduardo Valentim.
*****