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

[Poitschke Kai]

Hi Ton,
thank you for the links. I will go thru it and provide a proper patch soon (without that UNKNOWN thing
which caused nearly a flame war here).

I would not recommend to do it in Perl or C. The thing is so easy and I think there are not much 
compatibility problems. Ok, when I put my developer hat on, I would like do it in Perl too, but as a 
user I don't have a benefit from it. It adds only more dependencies (DBI/DBH::Oracle) without having
more functionallity. You don't want to run nagios on a windows box anyway, so why care.

Doing things in sqlplus and shell is fine for me. The script is so easy, it shouldn't raise much compatibility issues.

I let the Perl chaos behind me. I did a real big project using also perl. Within a few years the number
of modules we depend on grew to a more than 100. Can you imagine the work when you upgrade one
module to a new version which requires then suddenly another module is needed with a certain version...
Its basically a nightmare. 
The project where I'm responsible now uses Oracle+SQL+PL/SQL and if necessary
Java in Oracle. Runs on Linux, Windows, HP-UX and installs with sqlplus. It simply runs wherever Oracle
runs. No other external modules are necessary.

Regards
Kai


-----Original Message-----
From: Voon, Ton [mailto:Ton.Voon at egg.com] 
Sent: Mittwoch, 24. März 2004 12:13
To: Poitschke Kai; nagiosplug-devel at lists.sourceforge.net
Subject: RE: [Nagiosplug-devel] Improved check_oracle (TS check with autoextend)


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.