how to install perl for oracle

http://stackoverflow.com/questions/11407513/perl-dbdoracle-module-installation

Ok, so i got it working as below. putting the details steps for someone to refer (or may myself in future if i forget)

• Install Perl DBI module ($ yum install perl-DBI)
• Manually install below 3 rpms for oracle instant client (fromhttp://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html)

  oracle-instantclient11.2-basic-11.2.0.3.0-1
  oracle-instantclient11.2-devel-11.2.0.3.0-1
  oracle-instantclient11.2-sqlplus-11.2.0.3.0-1

I am using 64 bit linux box, so select your RPM filename accordingly.

• set below variables:

  LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
  ORACLE_HOME=/usr/lib/oracle/11.2/client64

  MacOS users will need:

  DYLD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/

  Also add ORACLE_HOME to your PATH variable.
• download DBD::Oracle from CPAN
• untar the module and run below commands in given sequence:

  perl Makefile.PL
  make
  make install

DONE !!!

Issues I had faced were due to the wrong LD_LIBRARY_PATH. I had set it to /usr/lib/oracle/11.2/client64 whereas the correct value is /usr/lib/oracle/11.2/client64/lib.