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