[Nagiosplug-devel] Improved check_oracle (TS check with autoe xtend)

[Voon, Ton]

Kai,

Thanks for your work. Please read the developer guidelines for submission of
patches at http://nagiosplug.sourceforge.net/developer-guidelines.html. This
sounds a useful addition to the current check_oracle.

Longer term, I am thinking of changing check_oracle from being sh based to
either perl or C because of sh incompatibilities between OS versions, but
will host that discussion to this mailing list when time allows.

Ton

-----Original Message-----
From: Poitschke Kai [mailto:kai.poitschke at axense.com] 
Sent: Wednesday, March 24, 2004 9:41 AM
To: nagiosplug-devel at lists.sourceforge.net
Subject: [Nagiosplug-devel] Improved check_oracle (TS check with autoextend)


Hello,
first of all I have to say that I'm new to the list. So please be patient
;-)

I have improved the tablespace check in the check_oracle plugin.
The check honors now the capability of Oracles autoextend feature. With this
improvement, you will not
get a WARNING/CRITICAL notification when Oracle is able to extend a database
file itself. You will get only  a notfication when the autoextend reaches
its maximum and then the tablespace reaches then its WARNING/CRITICAL
limits.
The script reports the max possible size including the autoextend. The
percentage is still calculated
from the current total allocation. So the output looks like this:

./check_oracle --tablespace scott tiger MYDB MYTS 99 98
MYDB : MYTS OK - 98% used [ 136 / 8192 MB available [max. 12288 MB] ]

This means, 136MB of the allocated 8192MB are free (--> 98%used), but
because it can autoextend to 12288MB you won't get a notification.


The second change is a minor change. I set the status code to UNKNOWN if the
tablespace could not be examined. I personally don't want to get CRITICAL
notifications when I check a tablespace and get an Oracle error, because of
a broken network connection or a database that is in shutdown/startup state
etc.

Is there a general interest to get this plugin into the main tree? If so, to
whom should I send it?
Who is the original maintainer of the plugin and is he still active?

Regards
Kai Poitschke (http://www.poitschke.de/libsqlora8/)



This private and confidential e-mail has been sent to you by Egg.
The Egg group of companies includes Egg Banking plc
(registered no. 2999842), Egg Financial Products Ltd (registered
no. 3319027) and Egg Investments Ltd (registered no. 3403963) which
is authorised and regulated by the Financial Services Authority. Egg
Investments Ltd. is entered in the FSA register under number 190518. 

Registered in England and Wales. Registered offices: 1 Waterhouse
Square, 138-142 Holborn, London EC1N 2NA.

If you are not the intended recipient of this e-mail and have received
it in error, please notify the sender by replying with 'received in
error' as the subject and then delete it from your mailbox.