Oracle Plugin Assistance

[EchoUser]

Hello Support,

We are trying to follow the guide posted here: https://assets.nagios.com/downloads/nag ... ios-XI.pdf
But when we run the oracleinstall.sh it throws an error during the CPAN file install:

Code: Select all

Using DBI 1.627 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/vendor_perl/auto/DBI/

Configuring DBD::Oracle for perl 5.016003 on linux (x86_64-linux-thread-multi)

Remember to actually *READ* the README file! Especially if you have any problems.

  The ORACLE_HOME environment variable value (/usr/lib/oracle//client64) is not valid.
  It must be set to hold the path to an Oracle installation directory
  on this machine (or a machine with a compatible architecture).
  For an Instant Client install, the directory should include an sdk subdirectory.
  See the appropriate README file for your OS for more information.
  ABORTED!

We are attempting to install on a CentOS7 server. Based on the document, the Oracle Home location should be provided by the script later, once the RPMs are installed?

Also, on a minimal CentOS7 server install CPAN is also not included, and should be added to the dependencies installed at the start.

[ssax]

Please send us the full output from the oracleinstall.sh script so we can see everything it's showing.

What versions of the oracle client did you download?

Did you have these three RPM files in the same directory as the oracleinstall.sh?

Code: Select all

oracle-instantclientXX.X-basic-XXXXXXXXX.x86_64.rpm
oracle-instantclientXX.X-devel-XXXXXXXXX.x86_64.rpm
oracle-instantclientXX.X-sqlplus-XXXXXXXXX.x86_64.rpm

What is the output of these commands?

Code: Select all

uname -a
cat /etc/*release

[EchoUser]

Hello, Yes, all files are present:

Code: Select all

-rw-rw-r--  1 root   root     669192 Oct 19 10:55 oracle-instantclient-devel-21.3.0.0.0-1.x86_64.rpm
-rw-rw-r--  1 root   root     721792 Oct 19 10:54 oracle-instantclient-sqlplus-21.3.0.0.0-1.x86_64.rpm
-rw-rw-r--  1 root   root   56417260 Oct 19 10:54 oracle-instantclient-basic-21.3.0.0.0-1.x86_64.rpm
-rwxr-xr-x  1 root   root       4007 Apr 30 12:19 oracleinstall.sh
-rw-r--r--  1 root   root     448855 Apr 24  2014 DBD-Oracle-1.74.tar.gz
-rw-r--r--  1 root   root     448855 Apr 24  2014 DBD-Oracle-1.74.tar.gz.1
drwxrwxr-x  6 root   root       4096 Apr 24  2014 DBD-Oracle-1.74

OS Version:

Code: Select all

# uname -a
Linux devqa-nagios 3.10.0-1160.42.2.el7.x86_64 #1 SMP Tue Sep 7 14:49:57 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/redhat-release 
CentOS Linux release 7.9.2009 (Core)

Please send us the full output from the oracleinstall.sh script so we can see everything it's showing.

What versions of the oracle client did you download?

Did you have these three RPM files in the same directory as the oracleinstall.sh?

Code: Select all

oracle-instantclientXX.X-basic-XXXXXXXXX.x86_64.rpm
oracle-instantclientXX.X-devel-XXXXXXXXX.x86_64.rpm
oracle-instantclientXX.X-sqlplus-XXXXXXXXX.x86_64.rpm

What is the output of these commands?

Code: Select all

uname -a
cat /etc/*release

[ssax]

/bin/sh: gcc: command not found

You're missing gcc, please run this as root or sudo and then run oracleinstall.sh again:

Code: Select all

yum install -y gcc glibc glibc-common openssl openssl-devel

[EchoUser]

/bin/sh: gcc: command not found

You're missing gcc, please run this as root or sudo and then run oracleinstall.sh again:

Code: Select all

yum install -y gcc glibc glibc-common openssl openssl-devel

Installed those and it ran longer but still ended with the same error.

[ssax]

I'm able to replicate it with that instant-client version, I will post an update shortly once I investigate further.

[EchoUser]

I'm able to replicate it with that instant-client version, I will post an update shortly once I investigate further.

Thank you.

[ssax]

Please replace your oracleinstall.sh with the one I've attached (unzip it first, make sure it's in the same directory as your instantclient files), re-run it, and let us know the results.

EDIT: I have submitted the bug report to development:

Code: Select all

NEW TASK ID 15667 created - Nagios XI Bug Report: XI - oracleinstall.sh doesn't work with the latest instantclient packages

[EchoUser]

The new script now installs without failure.

Thank you.

[ssax]

Glad to help! Let us know when we're okay to mark this as resolved and lock it up.

Thank you!