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

[Per Qvindesland]

Hi

Great work I will try this one out.

Per

On Fri, 2010-05-14 at 12:54 +0100, James Hogarth wrote:
> 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
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list