Page 1 of 3

ORACLE - (Return code of 127 is out of bounds - plugin may b

Posted: Wed Jan 20, 2016 8:30 am
by dlukinski
(Return code of 127 is out of bounds - plugin may be missing)
- error appears against all service checks after creating them with ORACLE DB Server and Tablespace monitoring WIzard

How to proceed further (which plugin to check for?)

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Wed Jan 20, 2016 10:55 am
by hsmith
Have you followed the instructions at the beginning of the wizard? They tell you how to install the plugin.

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Wed Jan 20, 2016 1:51 pm
by dlukinski
hsmith wrote:Have you followed the instructions at the beginning of the wizard? They tell you how to install the plugin.
Thank you. Installed plugin

Getting these errors (all checks against the server)
CRITICAL - cannot connect to myserver.com:1532/KCTCQA. install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/nagios/libexec /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /

Perl Module fix did not help

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Wed Jan 20, 2016 5:01 pm
by rkennedy

Code: Select all

ORACLE_HOME=/usr/lib/oracle/12.1/client64
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
(this is here for reference)

Can you navigate to Configure -> Core Config Manager -> select 'Commands' -> search for 'Oracle' and click Search.

Take a screen shot showing the command name and command lines for us to review and attach it for us to review.

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Wed Jan 20, 2016 5:06 pm
by dlukinski
rkennedy wrote:

Code: Select all

ORACLE_HOME=/usr/lib/oracle/12.1/client64
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
(this is here for reference)

Can you navigate to Configure -> Core Config Manager -> select 'Commands' -> search for 'Oracle' and click Search.

Take a screen shot showing the command name and command lines for us to review and attach it for us to review.
Here you go

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Wed Jan 20, 2016 5:17 pm
by rkennedy
Thanks for that, just wanted to make sure we were addressing the right issue. Can you manually install DBD-Oracle? Use these instructions -

Code: Select all

wget http://search.cpan.org/CPAN/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz
tar -xzf DBD-Oracle-1.74.tar.gz
cd DBD-Oracle-1.74
./Makefile.PL
make && make test
make install

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Fri Jan 22, 2016 3:23 pm
by dlukinski
rkennedy wrote:Thanks for that, just wanted to make sure we were addressing the right issue. Can you manually install DBD-Oracle? Use these instructions -

Code: Select all

wget http://search.cpan.org/CPAN/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz
tar -xzf DBD-Oracle-1.74.tar.gz
cd DBD-Oracle-1.74
./Makefile.PL
make && make test
make install
./Makefile.PL did not work:
./Makefile.PL line 5: use: command not found
./Makefile.PL line 7: use: command not found
./Makefile.PL line 8: use: command not found
./Makefile.PL line 10: syntax error near unexpected token '('
./Makefile.PL line 10: 'use ExtUtils::MakeMaker 5.16, qw(&WriteMakefile $Verbose);'


(this is a stock XI x64 VM appliance)

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Mon Jan 25, 2016 11:28 am
by rkennedy
Can you attempt to run perl ./Makefile.PL instead and post the result?

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Mon Jan 25, 2016 2:52 pm
by dlukinski
rkennedy wrote:Can you attempt to run perl ./Makefile.PL instead and post the result?
Unable to locate an oracle.mk or other suitable *.mk file in your Oracle installation.

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Posted: Mon Jan 25, 2016 3:49 pm
by tgriep
There are issues with the Oracle 12.1 client that are causing the issue. The newer client doesn't have some of the required modules needed.
Remove the 12.1 Oracle Client and use the Oracle Client 11.2. That should fix the issue you are having.