[Spacewalk-list] Contrib: Simple nagios plugin for DB size checks

[James Hogarth]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_spacewalk_size.sh
Type: application/x-sh
Size: 1862 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100514/adfd09e5/attachment.sh>