Page 1 of 2
Oracle Plugin Assistance
Posted: Tue Oct 19, 2021 10:13 am
by 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.
Re: Oracle Plugin Assistance
Posted: Wed Oct 20, 2021 9:16 am
by 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?
Re: Oracle Plugin Assistance
Posted: Wed Oct 20, 2021 1:14 pm
by 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)
ssax wrote: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?
Re: Oracle Plugin Assistance
Posted: Wed Oct 20, 2021 5:55 pm
by 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
Re: Oracle Plugin Assistance
Posted: Thu Oct 21, 2021 11:33 am
by EchoUser
ssax wrote:/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.
Re: Oracle Plugin Assistance
Posted: Fri Oct 22, 2021 9:51 am
by ssax
I'm able to replicate it with that instant-client version, I will post an update shortly once I investigate further.
Re: Oracle Plugin Assistance
Posted: Mon Oct 25, 2021 10:16 am
by EchoUser
ssax wrote:I'm able to replicate it with that instant-client version, I will post an update shortly once I investigate further.
Thank you.
Re: Oracle Plugin Assistance
Posted: Mon Oct 25, 2021 6:02 pm
by 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
Re: Oracle Plugin Assistance
Posted: Tue Oct 26, 2021 8:03 am
by EchoUser
The new script now installs without failure.
Thank you.
Re: Oracle Plugin Assistance
Posted: Tue Oct 26, 2021 4:30 pm
by ssax
Glad to help! Let us know when we're okay to mark this as resolved and lock it up.
Thank you!