Perl DBD::Oracle Module installation

by
  • Install if missing ExtUtils-MakeMaker module (sudo yum install perl-ExtUtils-MakeMaker)
  • Install Perl DBI module ($ yum install perl-DBI)

  • Manually install below three RPMs for Oracle instant client (from Instant Client Downloads for Linux x86-64. The example is for v11.2.0.3.0-1: adapt the commands below to the actual version.)

    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 filenames accordingly. Something like sudo yum -y install oracle-instantclient*rpm should do)

  • set below variables:

    export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
export 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
sudo make install

In case you get complaints about missing gcc you can (temporarily) install it and then remove it.

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.

Certainly, this was a great learning for a newbie like me.

More Related Contents:

  1. How can I convert my shell script to Perl? [closed]
  2. search using perl one liner within a file [closed]
  3. How to re-direct the contents to a file instead of printing it to terminal
  4. Doesn’t Perl include current directory in @INC by default?
  5. How do I remove duplicate items from an array in Perl?
  6. What is the difference between library files and modules?
  7. How do I read in the contents of a directory in Perl?
  8. How can I pass command-line arguments to a Perl program?
  9. How do I efficiently parse a CSV file in Perl?
  10. How can I fire and forget a process in Perl?
  11. How can I generate all permutations of an array in Perl?
  12. How can I install CPAN modules locally without root access (DynaLoader.pm line 229 error)?
  13. OpenSSL DH Key Too Small Error
  14. Manual installation of a Perl Module
  15. @ARGV is empty using ActivePerl in Windows 7
  16. ImageMagick Command-Line Option Order (and Categories of Command-Line Parameters)
  17. Perl Dereferencing Syntax
  18. How to extrace pg_backend_pid from postgresql in shell script and pass it to another process?
  19. What exactly does Perl’s “bless” do?
  20. Which cpan installer is the right one? (CPAN.pm/CPANPLUS/cpanminus)
  21. What is the difference between `$this`, `@that`, and `%those` in Perl?
  22. Why are use warnings; use strict; not default in Perl?
  23. What is the difference between `read` and `sysread`?
  24. How to use shell variables in perl command call in a bash shell script?
  25. In Perl, what is the difference between accessing an array element using @a[$i] as opposed to using $a[$i]?
  26. How do I use symbolic references in Perl?
  27. What is the meaning of @_ in Perl?
  28. How do I list available methods on a given object or package in Perl?
  29. Explain the deviousness of the Perl “preamble”
  30. Why doesn’t Perl’s each() iterate through the entire hash the second time?

Leave a Comment