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

Jonas Bygdén jonaslistor at gmail.com
Wed May 19 14:20:08 UTC 2010


On 14/05/10 13:54, 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
Cheers James - works great, thanks!

/Jonas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100519/ef244c2d/attachment.htm>


More information about the Spacewalk-list mailing list