check_oracle

[Marc Powell]

On Jan 20, 2009, at 8:48 AM, Anirudh Srinivasan wrote:

>
> usage of check_oracle plugin . what is it used to check excatly.

If this isn't exact enough, you can peruse the source code of  
course... It is assumed that you know what these mean with respect to  
Oracle.

[ libexec]$ ./check_oracle --help
check_oracle (nagios-plugins 1.4.3) 1.14
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 <Oracle Sid or Hostname/IP address>
   check_oracle --db <ORACLE_SID>
   check_oracle --login <ORACLE_SID>
   check_oracle --cache <ORACLE_SID> <USER> <PASS> <CRITICAL> <WARNING>
   check_oracle --tablespace <ORACLE_SID> <USER> <PASS> <TABLESPACE>  
<CRITICAL> <WARNING>
   check_oracle --oranames <Hostname>
   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_ and v_
--tablespace
    Check local database for tablespace capacity in ORACLE_SID
        --->  Requires Oracle user/password specified.
        		--->  Requires select on dba_data_files and dba_free_space
--oranames Hostname
    Check remote Oracle Names server
--help
    Print this help screen
--version
    Print version and license information

> and if that plugin gives the critical how to troubleshoot that issue.

Depends on what's broken and is beyond the scope of this list. Your  
Oracle DBA or an Oracle list would be a better source.

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null