Perl DBD::Oracle Module installation -


Can someone guide me how to install Perl DBD :: Oracle module?

Here's what I have done:

  • Platform: RHEL 5.8 64bit
  • Install Perl DBI Package
  • Install Oracle Instant Client for Linux 64 bit (for immediate customer base + SDK + sqlplus component
  • set right $ ORACLE_HOME and $ LD_LIBRARY_PATH
  • Then when I do perl Makefile.pl , it fails with the following error:

      I is having trouble finding your Oracle version number It is ... trying hard: I could not determine the Oracle client version so I will be the default only in version 8.0.0.0. Some features of DBD :: Oracle can not work. Oracle version based logic in the Mac file. You can use the "Perl Makefeil.PL-V XYZ" to specify your customer version. Oracle version 8.0.0.0 (8.0) DBD :: Oracle no. Loan supports Oracle client versions prior to 9.0. Try 1.28 for version 9 and 1.18 for 8! Makefili.PL on Line 271  
  • Instant Client Version: 11.1.0

  • DBD:: Oracle version is 1.44

    If you have successfully installed the Oracle instant client, can you tell me what am I missing?

    Is it possible to install DBD :: Oracle without using Oracle Immediate Client?

      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  < / Pre>   

    I am using the 64 bit Linux box, so select your RPM file name accordingly.

    • Set the following variable:

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

      Mac OS users will be required:

        DYLD_LIBRARY_PATH = / usr / lib / oracle / 11.2 / client64 /  <   
    • Li>

      Unblock the module and run the following commands in the following sequences:

        install to create perl Makefile.PL   < / Li>  

      !!!

      The issues I encountered were due to the wrong LD_LIBRARY_PATH . I had set it to /usr/lib/oracle/11.2/client64 , while the correct value is /usr/lib/oracle/11.2/client64/lib .

      Of course, this was a great lesson for a newbie like me

Comments