[Nagiosplug-devel] check_oracle modifications

[jmarquart at planalytics.com]

Hello all,
     I have modified the check_oracle script such that it also has the ability
to check tablespaces.

I personally like to keep track of how much space is being used in each
tablespace (in a given instance) on my DB.

I hacked this very basic support in - it provides the following changes:

it adds a "--table" command that gets invoked as follows:
     ./check_oracle --table <USER> <PASS> <INST> <TABLESPACE> <CRITICAL>
<WARNING>

this way you can simply add services for each/all your
DBs/instances/tablespaces.

the critical and warning fields are #MB that the tablespace must be above.

example:
     ./check_oracle --table username passwd INST1 MY_TABLESPACE 1000 1500

would provide OK - if MY_TABLESPACE has > 1500MB free
     WARNING - if MY_TABLESPACE has > 1000MB  && <= 1500MB
     CRITICAL - if MY_TABLESPACE has <= 1000MB

attached is the patch for your perusal

-john(See attached file: check_oracle.patch)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_oracle.patch
Type: application/octet-stream
Size: 1764 bytes
Desc: not available
URL: <http://nagios-plugins.org/archive/devel/attachments/20020716/1dcae8e6/attachment.obj>