check_oracle

Hendrik Baecker andurin at process-zero.de
Tue Jan 20 16:32:47 CET 2009


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
Anirudh Srinivasan schrieb:
>
> usage of check_oracle plugin . what is it used to check excatly. and
> if that plugin gives the critical how to troubleshoot that issue.
> 
> Please help me with this
> 
I don't think this will help you much, but here you are for the usage
question (c&p from check_oracle --help):

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

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
 
iD8DBQFJde6flI0PwfxLQjkRAqs9AJ0XW1WrL2RKA2vwS7Cg9n/VklazXwCfbO62
swaQXpVTFtVCxOT4301hlFo=
=sFhg
-----END PGP SIGNATURE-----


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





More information about the Users mailing list