Re: [Nagios-users] Plugin check_oracle_health

2012-11-09 Thread Claudio Kuenzler
BUT - a huge discovery when composing this mail. The only service definition that worked from Nagios was the one which has the undocumented argument --method sqlplus. I think i saw on some forums the use of that paramether in the beginning, and it remained in the definition. Anyway, after

Re: [Nagios-users] Plugin check_oracle_health

2012-11-08 Thread Cosmin Neagu
Hi, Below is the service definition for all 4 cases: define service { use generic-service host_name DBIGASDS service_description Reachability via tnsping 1 check_command check_oracle_health! --connect IGAS

Re: [Nagios-users] Plugin check_oracle_health

2012-11-07 Thread Cosmin Neagu
I think i installed DBD::Oracle successfully, otherwise, i do not think i could have check this: nagios@monitor:/usr/local/nagios/libexec$ ./check_oracle_health --connect IGAS --username ABC --password ABC --mode=connection-time OK - 0.09 seconds to connect as ABC |

Re: [Nagios-users] Plugin check_oracle_health

2012-11-07 Thread Claudio Kuenzler
So my question for someone who has made check_oracle_healt work is: How come all 4 invocation from CLI as nagios user work, but when Nagios runs them, only 2 of them work. I know that the error message tells me that there is some env variable path problem, but why are the first 2 calls of

Re: [Nagios-users] Plugin check_oracle_health

2012-10-29 Thread Cosmin Neagu
Hi Nagios Users, Can someone help me or give a hint on why check_oracle_health does not work (as describe below) ? On 10/23/2012 04:59 PM, Cosmin Neagu wrote: Hi all, I manage to install the oracle client on nagios machine after all (google is the best) and making all the necesary setting

Re: [Nagios-users] Plugin check_oracle_health

2012-10-29 Thread Claudio Kuenzler
You didn't correctly install the DBD::Oracle or your env variables are not correct, as your error message shows it: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/nagios/libexec /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5

Re: [Nagios-users] Plugin check_oracle_health

2012-10-23 Thread Cosmin Neagu
Hi all, I manage to install the oracle client on nagios machine after all (google is the best) and making all the necesary setting so that check_oracle_health is working from command line as nagios user: nagios@monitor:/usr/local/nagios/libexec$ ./check_oracle_health --connect IGAS

Re: [Nagios-users] Plugin check_oracle_health

2012-10-03 Thread Cosmin Neagu
Well, thats the hard part for me, installing those ORA files - didnt find yet how to do that. I think installing the plugin on DBServer and using NRPE is easier. Cosmin Neagu NOC Team Leader Str. I. G. Duca nr. 36 Otopeni, Judetul Ilfov, 075100 Romania Tel: 021 303 3159 / 0732 669 193

Re: [Nagios-users] Plugin check_oracle_health

2012-10-03 Thread Claudio Kuenzler
It's not that hard and a lot of things are written in the documentation of check_oracle_health. I even wrote an article about this in September 2011 explaining the steps: http://www.claudiokuenzler.com/blog/192/install-perl-dbd-oracle-DBD::Oracle-on-SuSE-SLES10-without-cpan You should do it the

Re: [Nagios-users] Plugin check_oracle_health

2012-10-03 Thread Joerg Linge
you just need a working sqlplus installation http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html use check_oracle_health --method=sqlplus ... and you are on your way Joerg Am 03.10.2012 um 08:14 schrieb Cosmin Neagu cosmin.ne...@omnilogic.ro: Well, thats the hard part for me,

[Nagios-users] Plugin check_oracle_health

2012-10-02 Thread Cosmin Neagu
Hi nagios users, I need to monitor an oracle database server, an found this plugin, check_oracle_health. The problem is that i'm not a DB Admin, and it seems that something else need to be configured along with this client like system variables (ORACLE_HOME and LD_LIBRARY_PATH) Since on the

Re: [Nagios-users] Plugin check_oracle_health

2012-10-02 Thread Ismael Puerto
Hi Cosmin The plugin needs to be installed on the Oracle Database server. I show you an example of my nrpe.cfg: command[check_oracle_seg-top10-buffer-busy-waits]=/usr/local/nagios/libexec/check_oracle_health --username nagios --password password --mode seg-top10-buffer-busy-waits --connect SID

Re: [Nagios-users] Plugin check_oracle_health

2012-10-02 Thread Claudio Kuenzler
The plugin needs to be installed on the Oracle Database server. That's not entirely correct. It can also run on a standalone Nagios server. But you need to install the ora files to be able to launch the plugin against an Oracle DB server. I did that successfully on Nagios 3.3.1 against ORA11.