[Nagiosplug-devel] [PATCH/PULL] New plugin: check_dbi

[Sebastian Harl]

Hi hassan,

On Mon, Jun 11, 2012 at 01:27:17PM +0500, hassan nashrah wrote:
> I have a test case, that you may like to test. as well as if your plugin could do this it wud be grt. i have been looking  for a while to do the following:
> 
> My Oracle DB server details
> 
> operating System: Solaris
> 
> database: oracle
> IP: 192.168.1.2 (not real ip)
> 
> My Nagios Server details
> OS : Ubuntu
> i have configured nagios 3.x
> 
> i connect to my db server from my nagios  as follow:
> 
>  ssh -Y root at 192.168.1.2
> Password: xxxxxxxxx
> [root at vboxdb /]# su - oracle
> 
> Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
> [oracle at vboxdb ~]$ sqlplus / as sysdba
> 
> SQL*Plus: Release 11.2.0.1.0 Production on Wed May 30 04:53:48 2012
> 
> Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Well, this is not how check_dbi would connect to an Oracle database.
Rather, you will need an 'oracle' driver for libdbi. According to the
website somebody is working on such a thing but it seems to be
incomplete and I don't know anything about the current status or whether
it's usable at all, I'm afraid.

> what i want to do i will list below ;
> 
> SQL> select current_utilization, max_utilization, limit_value from v$resource_limit where resource_name =’sessions’;
> 
> CURRENT_UTILIZATION   MAX_UTILIZATION     LIMIT_VALUE
> 
> ——————- —————          ————————-                     ————— 
> 
> 386                 404                                                1528
> 
> if the current utilization reaches 1500 alert critical, 1450 warning state.
> else normal.
> 
> can you tell me how i can use your plugin to do this. 

This is exactly what check_dbi is meant for. Please note though, that
you can (currently) only check a single value only. The plugin uses the
first (CURRENT_UTILIZATION) and simply ignores all other values.

> by the way i've tried to compile your plugin. but i am getting errors
> saying common.h not found.

Could you please provide more information about that error, like the
full compiler output? common.h is shipped with nagios-plugins, so I
suppose there is some other error.

HTH,
Sebastian

-- 
Sebastian Harl
Consultant, Trainer

teamix GmbH
Südwestpark 35
90449 Nürnberg

fon:   +49 911 30999-0
fax:   +49 911 30999-99
mail:  sh at teamix.de
web:   http://www.teamix.de

Amtsgericht Nürnberg, HRB 18320
Geschäftsführer: Oliver Kügow, Richard Müller

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: Digital signature
URL: <http://nagios-plugins.org/archive/devel/attachments/20120705/27bf4b6d/attachment.sig>