check_oracle --tablespace test-problem

Bjørn Hole bjorn.hole at nhst.no
Wed Mar 21 11:00:05 CET 2007


Hello.

 

I have problem with the check_oracle plugin <tablespaces>

Version : check_oracle : 1.14 (nagios-plugins 1.4.5), We are running Oracle version 8

Nagios 2.5

 

Problem: The output/test in Nagios is not complited/100% OK, but when I run the script from the user root or nagios, it's OK. See below:

 

./check_oracle --tablespace sxdb.nhst.no <user><password> PIC 90 80

 

sxdb.nhst.no : PIC WARNING  - 89.30% used [ 1404 / 13060 MB available ]|PIC=89.30%;80;90;0;100

 

Nagios output:

Current Status:OK    

Status Information: sxdb.nhst.no : DATA OK - % used [ / MB available ]

Performance Data: DATA=%;85;90;0;100

 

 

env:

SHELL=/bin/bash

TERM=xterm

USER=nagios

MAIL=/var/mail/nagios

PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/home/oracle

PWD=/usr/lib/nagios/plugins

LANG=en_US

SHLVL=1

HOME=/var/log/nagios

LANGUAGE=en_NO:en_US:en_GB:en

LOGNAME=nagios

ORACLE_HOME=/home/oracle

_=/usr/bin/env

OLDPWD=/var/log/nagios

 

 

 

The config files //checkcommands and services: 

 

# 'check_oracle' command definition

 

define command{

        command_name    check_oracle

        command_line    $USER1$/check_oracle --tablespace $ARG1$ $ARG2$ $ARG3$ $ARG4$ $ARG5$ $ARG6$

        }

 

define service{

        use                             generic-service

        host_name                       nhst-red-02

        contact_groups                  solaris-admins

        service_description             dn-pic

        check_command                 check_oracle!sxdb.nhst.no!user!passwd!PIC!90!85

 

The output from Nagios:

 

Current Status:OK    

Status Information: sxdb.nhst.no : DATA OK - % used [ / MB available ]

Performance Data: DATA=%;85;90;0;100

Current Attempt:1/3

State Type:HARD

Last Check Type:ACTIVE

Last Check Time: 2007-03-20 11:59:25

Status Data Age: 0d 0h 1m 33s

Next Scheduled Active Check:  2007-03-20 12:01:25

Latency:0.340 seconds

Check Duration:0.416 seconds

Last State Change:2006-08-17 11:26:23

Current State Duration:215d 1h 34m 35s

Last Service Notification:N/A

Current Notification Number:0

Is This Service Flapping?N/A

Percent State Change:N/A

In Scheduled Downtime?  NO  

Last Update:2007-03-20 12:00:45

 

 

Regards Bjørn

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20070321/d538d871/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null


More information about the Users mailing list