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

[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?)

[hsmith]

Have you followed the instructions at the beginning of the wizard? They tell you how to install the plugin.

[dlukinski]

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

[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.

[dlukinski]

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

[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

[dlukinski]

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)

[rkennedy]

Can you attempt to run perl ./Makefile.PL instead and post the result?

[dlukinski]

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.

[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.