check_oracle_v2

Project Notes

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. *****