<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I just "check_oracle --login dbname"since this tells me if the server
is reachable, if the login prompt is given correctly and if there are
any problems, they are raised with the ORA-xxxx error message so at all
time I know what the exact condition or error of the database is.<br>
<br>
-h<br>
<pre class="moz-signature" cols="72">Hari Sekhon
</pre>
<br>
<br>
Mestdagh Tommy wrote:
<blockquote
cite="mid27FA63FC15F4C243A37B07D57C891E3C054F615D@ws03-exchange.iconos.be"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2900.3059" name="GENERATOR">
<div><font color="#000000" face="Arial" size="2">Hi,</font></div>
<div> </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> </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> </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> </div>
<div> </div>
<pre wrap="">
<hr size="4" width="90%">
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
<a class="moz-txt-link-freetext" href="http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV">http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV</a></pre>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Nagios-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</a>
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null</pre>
</blockquote>
</body>
</html>