<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
On 14/05/10 13:54, James Hogarth wrote:
<blockquote
cite="mid:AANLkTinBM5kRubwXsBEzAr7FCuF-qJcwfG4xcd4N5mqH@mail.gmail.com"
type="cite">
<pre wrap="">Hi,
Thought I'd share this one in case there is interest...
The Oracle XE database as we know has the 4GB table limit for user
data (including system data related to that such as indexes).
To monitor my systems so I don't fall into the seemingly common
pitfall of spacewalk suddenly stopping working I've knocked out a
simple nagios plugin that includes performance data as well for the
likes of pnp4nagios or other processing systems.
It's written in bash and relies on a working sqlplus and bc.
Just amend the user/pass/SID variables in it as appropriate for your
environment.
It is designed to be run locally on the oracle server as it stands
right now... but given it access the database via sqlplus and SID it
could conceivably work remotely provided the tnsnames and so on is
correctly configured for the user running the command. I'm running it
here via nrpe for instance....
Hope it helps out with others....
James
</pre>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Spacewalk-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a>
<a class="moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre>
</blockquote>
Cheers James - works great, thanks!<br>
<br>
/Jonas<br>
</body>
</html>