Page 1 of 1
Configuring Nagios for monitoring Oracle database
Posted: Mon May 18, 2020 4:47 pm
by ets_user
Hi,
We want to monitor our oracle db through Nagios XI 5.5.6 and without internet connectivity.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
Following this guide, we are struck at installing cpan from mirror sites and oracle check health tarballs since we dont have internet connectivity.
Also let us know if anythings need to be configured in the server where Oracle is installed.
Thanks.
Re: Configuring Nagios for monitoring Oracle database
Posted: Mon May 18, 2020 5:01 pm
by jbrunkow
Is the server with the Oracle database running Red Hat or CentOS? If so, I believe you can use the following commands to install
cpan.
Download the packages on an internet connected system using the
downloadonly plugin or
yumdownloader on a system that already has the packages installed.
Code: Select all
yum install yum-plugin-downloadonly
yum install --downloadonly --downloaddir=<directory> <package>
Then you can move it to the offline system, and then run the following set of commands.
Code: Select all
yum install --downloadonly --installroot=<directory> --releasever=<version> --downloaddir=<directory> <package>
Re: Configuring Nagios for monitoring Oracle database
Posted: Tue May 19, 2020 2:42 am
by ets_user
Below are the logs while trying to run ./oracleinstall.sh.
Which URL we should provide.
Also can you please explain which cpan package we need to download.
Code: Select all
Nothing to do
Loaded plugins: langpacks, ulninfo
Examining oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64.rpm: oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64
oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64.rpm: does not update installed package.
Examining oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64.rpm: oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64
oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64.rpm: does not update installed package.
Examining oracle-instantclient19.6-devel-19.6.0.0.0-1.x86_64.rpm: oracle-instantclient19.6-devel-19.6.0.0.0-1.x86_64
oracle-instantclient19.6-devel-19.6.0.0.0-1.x86_64.rpm: does not update installed package.
Nothing to do
CPAN may ask you questions. Choose 'No' if it asks if you want to
do a manual install, unless you have special internet settings.
Sorry, we have to rerun the configuration dialog for CPAN.pm due to
some missing parameters. Configuration will be written to
<</root/.cpan/CPAN/MyConfig.pm>>
CPAN.pm requires configuration, but most of it can be done automatically.
If you answer 'no' below, you will enter an interactive dialog for each
configuration option instead.
Would you like to configure as much as possible automatically? [yes] yes
<install_help>
Warning: You do not have write permission for Perl library directories.
To install modules, you need to configure a local Perl library directory or
escalate your privileges. CPAN can help you by bootstrapping the local::lib
module or by configuring itself to use 'sudo' (if available). You may also
resolve this problem manually if you need to customize your setup.
What approach do you want? (Choose 'local::lib', 'sudo' or 'manual')
[local::lib]
Autoconfigured everything but 'urllist'.
Now you need to choose your CPAN mirror sites. You can let me
pick mirrors for you, you can select them from a list or you
can enter them by hand.
Would you like me to automatically choose some CPAN mirror
sites for you? (This means connecting to the Internet) [yes] no
Would you like to pick from the CPAN mirror list? [yes] no
Now you can enter your own CPAN URLs by hand. A local CPAN mirror can be
listed using a 'file:' URL like 'file:///path/to/cpan/'
CPAN.pm needs at least one URL where it can fetch CPAN files from.
Please enter your CPAN site: []
Thanks.
Re: Configuring Nagios for monitoring Oracle database
Posted: Tue May 19, 2020 11:15 am
by jbrunkow
That probably means that you are encountering a problem with installing the DBI Perl module.
You will need to download the following packages on an internet connected system.
Code: Select all
wget https://labs.consol.de/assets/downloads/nagios/check_oracle_health-3.1.2.2.tar.gz
wget http://search.cpan.org/CPAN/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz
wget https://www.cpan.org/modules/by-module/DBI/DBI-1.642.tar.gz
Extract the tarballs and then move the files to a folder on the offline system, including the files that the document specified to download from oracle.com.
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
Then download the modified oracle install script attached to this forum and run it on the system in question.
I believe the following commands are what needs to happen on the
XI server.
Code: Select all
cd /tmp
wget http://www.cpan.org/modules/by-module/DBD/DBD-Oracle-1.74.tar.gz
tar zxvf DBD-Oracle-1.74.tar.gz
cd DBD-Oracle-1.74
perl Makefile.PL -l
make && make test
make install
Re: Configuring Nagios for monitoring Oracle database
Posted: Tue May 19, 2020 3:22 pm
by ets_user
Thanks for the help.
We were able to install and it gave us the Oracle_Home and LD_library_path, so we think the installation is successful.
And then we modified the path in all 3 commands provided.
So next step is to add the oracle servers using the wizard right?
Before that do we need to install any agent similar to NRPE on linux servers on the server running oracle?
Thanks.
Re: Configuring Nagios for monitoring Oracle database
Posted: Tue May 19, 2020 4:17 pm
by jbrunkow
I believe that the plugin interacts directly with the Oracle client on the other server. So, as long as you have followed
the document (and used the script modified for offline installs), it should work.