<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#000000 size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I need to monitor an oracle database ( on debian ). I played with the "check_oracle --tns 127.0.0.1" over ssh</FONT></DIV>
<DIV><FONT face=Arial size=2>And thats returns green ok ! So far so good. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>But what other checks are useful to do or even better like the --login option or do need to check them all </FONT></DIV>
<DIV>
<DIV><FONT face=Arial size=2>... i'm not home at oracle stuff.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>regards </FONT></DIV>
<DIV><FONT face=Arial size=2> Tommy</FONT></DIV>
<DIV> </DIV></DIV>
<DIV>Usage:<BR> check_oracle --tns <Oracle Sid or Hostname/IP address><BR> check_oracle --db <ORACLE_SID><BR> check_oracle --login <ORACLE_SID><BR> check_oracle --cache <ORACLE_SID> <USER> <PASS> <CRITICAL> <WARNING><BR> check_oracle --tablespace <ORACLE_SID> <USER> <PASS> <TABLESPACE> <CRITICAL> <WARNING><BR> check_oracle --oranames <Hostname><BR> check_oracle --help<BR> check_oracle --version</DIV>
<DIV>Check Oracle status</DIV>
<DIV>--tns SID/IP Address<BR> Check remote TNS server<BR>--db SID<BR> Check local database (search /bin/ps for PMON process) and check<BR> filesystem for sgadefORACLE_SID.dbf<BR>--login SID<BR> Attempt a dummy login and alert if not ORA-01017: invalid username/password<BR>--cache<BR> Check local database for library and buffer cache hit ratios<BR> ---> Requires Oracle user/password and SID specified.<BR> ---> Requires select on v_ and v_<BR>--tablespace<BR> Check local database for tablespace capacity in ORACLE_SID<BR> ---> Requires Oracle user/password specified.<BR> ---> Requires select on dba_data_files and dba_free_space<BR>--oranames Hostname<BR> Check remote Oracle Names server<BR></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>