[Nagiosplug-devel] [ nagiosplug-New Plugins-689679 ] New plugin: check_oracle_tbs

[SourceForge.net]

New Plugins item #689679, was opened at 2003-02-19 16:48
Message generated for change (Comment added) made by koiler
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=541465&aid=689679&group_id=29880

Category: Application monitor
Group: None
Status: Closed
Resolution: None
Priority: 5
Submitted By: John Koyle (koiler)
Assigned to: Stanley Hopcroft (stanleyhopcroft)
Summary: New plugin: check_oracle_tbs

Initial Comment:
This is a simple plugin to connect to an oracle
database and check for tablespaces that are nearly full.

----------------------------------------------------------------------

>Comment By: John Koyle (koiler)
Date: 2005-02-04 14:14

Message:
Logged In: YES 
user_id=420165

Right now it doesn't do anything special to handle timeouts.
 If a connection to the database cannot be made, a TCP
timeout will eventually occur, and the DBI Connect won't
return a valid DB handle.  If this happens, the program
currently exits with an UNKNOWN status.  Apply this small
patch and it will print an error to STDOUT before exiting.

Several solutions to the timeout issue exist, but would only
complicate the plugin.  Dealing with a timeout issue would
make more sense in the check_oracle plugin which checks for
general availability rather than here. 

Thanks again.

--- check_oracle_tbs.orig       2005-02-04
14:04:19.000000000 -0700
+++ check_oracle_tbs    2005-02-04 14:04:54.000000000 -0700
@@ -193,7 +193,7 @@
    $dbh = DBI->connect("$orasid", "$orauser", "$orapwd",
"Oracle");

    if (!$dbh) {
-      if ($opt_debug) { print "ERROR: Could not connect to
Oracle!\n\n"; }
+      print "ERROR: Could not connect to Oracle!\n\n";
       CleanupAndExit($ERRORS{'UNKNOWN'});
    }
    if ($opt_debug) { print "Connected to Oracle SID
$orasid\n\n"; }


----------------------------------------------------------------------

Comment By: Stanley Hopcroft (stanleyhopcroft)
Date: 2005-02-03 17:29

Message:
Logged In: YES 
user_id=395628

New version (1.2) should be in CVS.

(PS I am not familiar with DBI. How does your program handle
timeouts ? )

Thank you for the plugin.

----------------------------------------------------------------------

Comment By: John Koyle (koiler)
Date: 2005-02-03 13:59

Message:
Logged In: YES 
user_id=420165

Hi Stanley,

This is an updated version of this plugin that I am
currently using.  It works much better and actully functions
as described in my comment from 11/8/04.  If you could get
this in /contrib instead of the current one I would
appreciate it.

Thanks!
John

----------------------------------------------------------------------

Comment By: Stanley Hopcroft (stanleyhopcroft)
Date: 2005-01-26 21:15

Message:
Logged In: YES 
user_id=395628

Thank you very much for the plugin.

Sorry so much time has passed before any acknowledgement of it.

Your plugin should be in the /contrib dir of the CVS in the
next 1-2 hours.

----------------------------------------------------------------------

Comment By: John Koyle (koiler)
Date: 2004-11-08 09:04

Message:
Logged In: YES 
user_id=420165

Here's a new version of this script that has a query that
works better.  If you have tablespaces with autoextending
data files the previous version may claim that you are
running out of space when datafiles still may autoextend.

This version calculates the total amount of space based on
how large the tablespace will become once all the datafiles
are extended to their max.

----------------------------------------------------------------------

Comment By: gitesh (giteshtrivedi)
Date: 2004-11-08 01:47

Message:
Logged In: YES 
user_id=1140346

Dear friend,

It is not working.When I was executed the said patch that 
time I got error that bad interprited.

Please clearify it.

----------------------------------------------------------------------

Comment By: John Marquart (vaix)
Date: 2003-02-20 11:15

Message:
Logged In: YES 
user_id=102671

John - I will check out your code - am quite excited about 
how you implemented it.

Just a FYI - the latest CVS version of the check_oracle plugin 
(1.4) contains code to both check tablespace utilization as 
well as cache hit percentages (library and data buffers).

-vaix

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=541465&aid=689679&group_id=29880