Page 1 of 2
Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Tue Nov 01, 2016 9:15 am
by mvndnburg
Nagios XI 5.2.9 installed on RHEL 6.8.
I want to monitor Oracle databases using one of the check_oracle plugins, so I need DBI (no problem) and DBD::Oracle.
Unfortunately, DBD::Oracle is not available in any RedHat repositories it seems, nor have I been able to find it in any other legit repository.
Compilation from CPAN source is the last option (and it works, I did it in the proof of concept phase) but that is a nuisance because it is difficult to fit that into our monthly patch cycle.
How did others solve this issue?
*Edit: Nagios version incorrect*
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Tue Nov 01, 2016 12:08 pm
by gormank
Did you try yum list perl-dbd-oracle, or yum list | grep dbd?
I think perl modules are in the format shown or lower case, separated w/ a dash. Try yum list | grep ^perl for examples. It looks like a lor of modules come from epel and repoforge.
Code: Select all
perl-Sys-Syslog.x86_64 0.27-1.el6.rf rpmforge
perl-Sys-Virt.x86_64 0.10.2-6.el6 rhel-6-server-rpms
perl-Sysadm-Install.noarch 0.36-1.el6 epel
perl-SyslogScan.noarch 0.32-1.2.el6.rf rpmforge
perl-SystemC-Vregs.noarch 1.463-2.el6 epel
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Tue Nov 01, 2016 1:03 pm
by dwhitfield
Admittedly I'm using CentOS 7.0.1406, but
Code: Select all
[root@localhost ~]# yum list | grep dbd
libdbi-dbd-mysql.x86_64 0.8.3-16.el7 base
libdbi-dbd-pgsql.x86_64 0.8.3-16.el7 base
libdbi-dbd-sqlite.x86_64 0.8.3-16.el7 base
I poked around online for that module, but I came up with the same thing you did.
What is it that you want to monitor that you can't with XI's built in Oracle support? Maybe we can help you find another way.
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Tue Nov 01, 2016 1:19 pm
by gormank
I tried a yum list | grep -I dbd and now see some w/ perl-DBI in the name, but not oracle.
It looks like you first want to install DBI: yum install perl-dbi
The package is a tar file so it wants to be compiled. DBDs are usually modules that use a binary, hence compiling is needed.
http://search.cpan.org/~pythian/DBD-Ora ... /Oracle.pm
I did see some reference to an rpm, but didn't chase it down. The OP may want to ask the internet, or see if support answers...
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Tue Nov 01, 2016 2:52 pm
by lmiltchev
You can also try installing DBD::Oracle via cpan:
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Tue Nov 01, 2016 7:08 pm
by umunix
Yeah. That module has to be built against the Oracle client libraries. Went through the same exercise myself. I just used cpan, after installing the Oracle client. You can use the instantclient, available as a package from Oracle. Or you can download the full thing.
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Wed Nov 02, 2016 2:51 am
by mvndnburg
Thanks all, for the replies and suggestions.
Regarding the DBD modules that are available on our system (which has the standard RHEL repos configured as well as some optional ones): there's no Oracle there:
Code: Select all
[root@host ~]# yum list | grep dbd
libdbi-dbd-mysql.x86_64 0.8.3-5.1.el6 rhel6-x86_64
libdbi-dbd-pgsql.x86_64 0.8.3-5.1.el6 rhel6-x86_64
libdbi-dbd-sqlite.x86_64 0.8.3-5.1.el6 rhel6-x86_64-optional
dwhitfield wrote:What is it that you want to monitor that you can't with XI's built in Oracle support? Maybe we can help you find another way.
I was under the impression that DBD::Oracle is a requirement to be able to connect to Oracle itself (i.e., as a service) and monitor things like table space usage, fragmentation, etc. In fact,
Installing-Oracle-Plugins-in-Nagios-XI.pdf also shows that DBD is a requirement for check_xi_oraclequery / check_xi_oracleserverspace / check_xi_oracletablespace.
lmiltchev wrote:You can also try installing DBD::Oracle via cpan
I'm aware of that method, but CPAN is not currently whitelisted in our environment. That is, it's not accessible from within the datacenter.
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Wed Nov 02, 2016 10:23 am
by avandemore
If it's not in the base repositories then you'll either have to compile or find a repository that meets your requirements.
I know our Oracle documentation works as I tested it for some updates a few days ago. It also clearly states we are not authorized to redistribute Oracle software and offers our customers an Oracle licensing safe method. This includes a scripted compilation of the CPAN module.
How to Install & Configure the Oracle Client & Plugins
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Thu Nov 03, 2016 2:03 am
by mvndnburg
avandemore wrote:If it's not in the base repositories then you'll either have to compile or find a repository that meets your requirements.
At least DBD::Oracle doesn't change often... (latest update in 2014).
avandemore wrote:I know our Oracle documentation works as I tested it for some updates a few days ago. It also clearly states we are not authorized to redistribute Oracle software and offers our customers an Oracle licensing safe method. This includes a scripted compilation of the CPAN module.
How to Install & Configure the Oracle Client & Plugins
Interesting... DBD::Oracle is NOT Oracle software. The copyright is not held by Oracle, and the software is distributed under the GPL. From the LICENSE file:
This software is copyright (c) 1994 by Tim Bunce.
This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.
Looks like someone got themselves handcuffed by Oracle
Re: Where does one obtain DBD::Oracle RPMs for RHEL
Posted: Thu Nov 03, 2016 9:29 am
by avandemore
Interesting... DBD::Oracle is NOT Oracle software. The copyright is not held by Oracle, and the software is distributed under the GPL. From the LICENSE file:
It's build and runtime requirements require Oracle software.