Install Oracle Client & Plugin - Offline

[pavankumar]

Hi Team,

We are trying to configure & install Oracle Client & Plugins. Our Linux systems are not connected to internet and need to do an offline installation.
RHEL 7 x86_64 is the one we are looking at.

Please let us know all the dependencies and procedure to install it offline.

Thanks.

[cdienger]

I haven't been able to fully test this yet, but it appears to download and install everything:

1. Download:

https://labs.consol.de/assets/downloads ... 2.2.tar.gz

https://cpan.metacpan.org/authors/id/T/ ... 643.tar.gz
http://search.cpan.org/CPAN/authors/id/ ... .74.tar.gz

yum reinstall --downloadonly --downloaddir=. glibc-static
yum reinstall --downloadonly --downloaddir=. glibc-utils
yum reinstall --downloadonly --downloaddir=. perl-YAML
yum reinstall --downloadonly --downloaddir=. gd
yum reinstall --downloadonly --downloaddir=. libXpm

The attached oracleinstall.sh

Copy them to the /tmp directory of the XI server

2. Run the install:

Code: Select all

cd /tmp
chmod 755 oracleinstall.sh
./oracleinstall.sh

[pavankumar]

Thanks for the reply.

I am getting the below error.

CRITICAL - cannot connect to <hostname>:1521/nagios. 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 /usr/sha

I have tried DBD:Oracle following below instructions but of no use.
tar zxvf DBD-Oracle-1.74.tar.gz
cd DBD-Oracle-1.74
perl Makefile.PL -l
make && make test
make install
----------------------------------------------------------------
I would prefer to set up a call to resolve this.
Thanks

[cdienger]

Sounds good. Our contact information can be found at www.nagios.com/contact. Please have your customer ID or the last 6 characters of your XI license available when you call so we can confirm phone support.

[tgriep]

Have the customer download the following files and put then in a folder on the XI server.

Code: Select all

check_oracle_health-3.1.2.2.tar.gz
DBD-Oracle-1.74.tar.gz
DBI-1.642.tar.gz
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

The Oracle Instant Client can be downloaded from Oracle, the other files from the following URL's.

https://labs.consol.de/assets/downloads ... 2.2.tar.gz
http://search.cpan.org/CPAN/authors/id/ ... .74.tar.gz
https://www.cpan.org/modules/by-module/ ... 642.tar.gz

Put the modified script in the same folder and run it.
./oracleinstall.sh

[pavankumar]

I have installed those and there were no errors.

when i try to configure a monitor i am getting the same error again. I have tested the connection using SQL Developer to ensure that connection params are valid.

[nagios@****.vmpc1.cloud.****.com ~]$ . /usr/local/nagiosxi/etc/configwizards/oracle/oracle && /usr/local/nagios/libexec/check_oracle_health --connect '<hostname>:53625/nagios.****db' --username 'system' --password '****' --mode sql --name="select count(*) from ALL_TABLES" --warning 50 --critical 200
CRITICAL - cannot connect to <hostname>:53625/nagios.****. 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 /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 13) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Pg, Proxy, SQLite, Sponge, mysql.
at /usr/local/nagios/libexec/check_oracle_health line 6151.

Thanks

[tgriep]

Take a look in this file on the Nagios server.

Code: Select all

/usr/local/nagiosxi/etc/configwizards/oracle/oracle

It is used to setup the environment variables that the plugin uses.
It is setup to use version 11.2 of the Oracle Instant Client.
If you installed a different version, you will need to update the paths in that file and then test the command again.

[pavankumar]

I have modified those already and the related command in core config manager.

[admin@****10018 ~]$ more /usr/local/nagiosxi/etc/configwizards/oracle/oracle
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64
export ORACLE_HOME=/usr/lib/oracle/12.1/client64/lib
[admin@sbl70010018 ~]$

Thanks

[tgriep]

In the folder you downloaded the files and ran the script.
Go to this sub folder called

Code: Select all

DBD-Oracle-1.74

Run the following to install the DBD Oracle Perl module.

Code: Select all

export ORACLE_HOME="/usr/lib/oracle/12.1/client64/lib"
export LD_LIBRARY_PATH="$ORACLE_HOME/lib"
perl Makefile.PL -l 
make && make test 
make install

Test the check_oracle_health plugin again.
If it cannot find the DBD/oracle.pm module, show the full output for when it was reinstalled so we can check it for errors.