Perl ABC

  1. Perl
    2. ›
  2. database
    3. ›
  3. here

Install DBD::Oracle

(Confirmed with CentOS5.5, CentOS5.7)

Note that I installed the Perl module DBD::Oracle.

The following libraries were required to install DBD::Oracle. 

oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm
oracle-instantclient11.2-devel-11.2.0.2.0.i386.rpm
oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm

You can download it from the Oracle site, but user registration is required. ..

Then install these rpm packages. 

rpm -hiv oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm
rpm -hiv oracle-instantclient11.2-devel-11.2.0.2.0.i386.rpm
rpm -hiv oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm

Next, set the required environment variable. 

vi /etc/profile.d/oracle.sh

Add the following settings to the above empty file. 

export ORACLE_HOME = '/usr/lib/oracle/11.2/client'
export C_INCLUDE_PATH = '/usr/include/oracle/11.2/client'
export LD_LIBRARY_PATH = '/usr/lib/oracle/11.2/client/lib'

Next, set the library. 

vi /etc/ld.so.conf.d/oracle.conf

Add the following items to the above empty file. 

/usr/lib/oracle/112/client/lib

In this state, restart the terminal to reflect the environment variable.

All you have to do now is install it with the cpan command. 

cpan DBD::oracle

Related Informatrion

Perl Club