To install a working Perl environment to manage remote Oracle databases, you need to install the Oracle Instant Client
To install the Oracle Instant Client version 126.96.36.199 64 bits, download the rpm files as shown below :
root@localhost:~# rpm -i oracle-instantclient11.2-basic-188.8.131.52.0-1.x86_64.rpm
root@localhost:~#rpm -i oracle-instantclient11.2-odbc-184.108.40.206.0-1.x86_64.rpm
root@localhost:~#rpm -i oracle-instantclient11.2-sqlplus-220.127.116.11.0-1.x86_64.rpm
root@localhost:~#rpm -i oracle-instantclient11.2-devel-18.104.22.168.0-1.x86_64.rpm
The installation works fine.
To install DBD::Oracle perl module, use CPAN if it is not available from RHEL yum repositories.
cpan> install DBD::Oracle
This command will install the module and the missing dependencies. if the development files of the Oracle Instant Client are not installed (oracle-instantclient11.2-devel-22.214.171.124.0-1.x86_64.rpm not installed), you will have the following error during DBD::Oracle perl compilation :
Unable to locate an oracle.mk or other suitable *.mk
file in your Oracle installation. (I looked in
/usr/lib/oracle/11.2/client64/rdbms/demo/demo_xe.mk /usr/lib/oracle/11.2/client64/rdbms/lib/oracle.mk /usr/lib/oracle/11.2/client64/rdbms/demo/oracle.mk /usr/lib/oracle/11.2/client64/rdbms/demo/demo_rdbms.mk /usr/lib/oracle/11.2/client64/rdbms/demo/demo_rdbms64.mk /usr/lib/oracle/11.2/client64/rdbms/lib/ins_rdbms.mk /usr/share/oracle/11.2/client64/demo.mk under /usr/lib/oracle/11.2/client64)
The oracle.mk (or demo_rdbms.mk) file is part of the Oracle
RDBMS product. You need to build DBD::Oracle on a
system which has one of these Oracle components installed.
(Other *.mk files such as the env_*.mk files will not work.)
Alternatively you can use Oracle Instant Client.
In the unlikely event that a suitable *.mk file is installed
somewhere non-standard you can specify where it is using the -m option:
perl Makefile.PL -m /path/to/your.mk
See the appropriate README file for your OS for more information and some alternatives.
at Makefile.PL line 1187.