LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-29-2009, 07:04 AM   #1
micho1978
LQ Newbie
 
Registered: Jul 2009
Posts: 2

Rep: Reputation: 0
Unhappy Config issue check_oracle_health with nagios


Hello,
I have a problem to integrate plugin check_oracle_health into nagios for monitoring oracle db (tablespace, ...). (Nagios 3, Ubuntu 9)
I have tested the plugin with the command line and it works correctly:

# ./check_oracle_health --connect=ablorcl2 --user=system --password=xxxxxx --mode=tablespace-usage

WARNING - tbs ABILLITY_TABLES usage is 90.71%, tbs USERS usage is 2.58%, tbs UNDOTBS2 usage is 3.24%, tbs UNDOTBS1 usage is 0.50%, tbs TEMP usage is 3.34%, tbs SYSTEM usage is 4.03%, tbs SYSAUX usage is 3.19%, tbs STATSPACK usage is 0.45%, tbs PM_TMPIDX_001 usage is 82.80%, tbs PM_TMPDAT_001 ...

but when I integrate it into the config files to nagios I see on the web interface of nagios:

Oracle Tablespace UNKNOWN 07-28-2009 22:08:48 0d 4h 1m 26s 3/3 Copyright (c) 2008 Gerhard Lausser

Here is my config for commands, service and host:

define command {
command_name check_oracle_tbspace_abl02
command_line $USER1$/check_oracle_health --connect=$_HOSTORACLE_SID$ --username=$ARG1$ --password=$ARG2$ --mode=$ARG3$ --warning=$ARG4$ --critical=$ARG5$
}

define service{
use generic-service ; Name of service template to use
host_name abldb02
service_description Oracle Tablespace
check_command check_oracle_tbspace_abl02!ablorcl2!system!xxxxxx!tablespace-free!80!90
}

define host{
use linux-server ; Inherit default values from a template
host_name abldb02 ; The name we're giving to this host
alias abldb02 Oracle ; A longer name associated with the host
address 192.142.40.3 ; IP address of the host
}


Frankly I tried many things but I saw nothing at all!
May be an error in my config file!
If someone has an idea or fact has already worked with nagios plugin check_oracle_health that I would be grateful to show me the way!
Thank you!
Excuse me for my english !
 
Old 07-30-2009, 12:52 AM   #2
kirukan
Senior Member
 
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,278

Rep: Reputation: 148Reputation: 148
Quote:
command_line $USER1$/check_oracle_health --connect=$_HOSTORACLE_SID$ --username=$ARG1$ --password=$ARG2$ --mode=$ARG3$ --warning=$ARG4$ --critical=$ARG5$
just remove the "=" sign, keep a space and try it
Quote:
command_line $USER1$/check_oracle_health -c $HOSTORACLE_SID$ -u $ARG1$ -p $ARG2$ -m $ARG3$ -w $ARG4$ -c $ARG5$

Last edited by kirukan; 07-30-2009 at 12:54 AM.
 
Old 07-30-2009, 12:59 AM   #3
EricTRA
LQ Guru
 
Registered: May 2009
Location: Gibraltar, Gibraltar
Distribution: Fedora 20 with Awesome WM
Posts: 6,805
Blog Entries: 1

Rep: Reputation: 1296Reputation: 1296Reputation: 1296Reputation: 1296Reputation: 1296Reputation: 1296Reputation: 1296Reputation: 1296Reputation: 1296
Hi,

Checked the command line I'm using and this works for me on Nagios 3/Debian Lenny against Oracle 10g
Code:
$USER1$/check_oracle_health --connect SERVER --user username --password password --mode tablespace-usage
Kind regards,

Eric
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Nagios config ? MikeFoo1 Linux - Networking 15 01-18-2013 07:26 AM
configuring nagios config files Mangenius Linux - Software 2 01-04-2007 11:47 AM
Converting Netsaint config to Nagios! dunkyb Linux - Software 2 07-20-2006 09:31 AM
Problems with nagios config ignus Linux - Software 4 07-26-2005 09:17 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:32 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration