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 18.104.22.168 64 bits, download the rpm files as shown below :
root@localhost:~# rpm -i oracle-instantclient11.2-basic-22.214.171.124.0-1.x86_64.rpm root@localhost:~#rpm -i oracle-instantclient11.2-odbc-126.96.36.199.0-1.x86_64.rpm root@localhost:~#rpm -i oracle-instantclient11.2-sqlplus-188.8.131.52.0-1.x86_64.rpm root@localhost:~#rpm -i oracle-instantclient11.2-devel-184.108.40.206.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.
root@localhost:~#cpan 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-220.127.116.11.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.