Where does one obtain DBD::Oracle RPMs for RHEL

[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*

[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

[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.

[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...

[lmiltchev]

You can also try installing DBD::Oracle via cpan:

Code: Select all

cpan -i DBD::Oracle

[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.

[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

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.

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.

[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

[mvndnburg]

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).

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

[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.