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,

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 --username

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-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 | connection_time=0.0934;1;

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 /usr/li

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 so

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 --usernam

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 : > Well, thats the hard part for me, installing those ORA fil

Re: [Nagios-users] Plugin check_oracle_health

2012-10-02 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 wa

Re: [Nagios-users] Plugin check_oracle_health

2012-10-02 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 www

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.

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 -