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