Re: centos perl-DBD:Oracle

Hi Pam,

Pam Wampler wrote:
> What are the steps to install perl-DBD:Oracle on a centos 5 server?
> 
> I have the following oracle rpm's installed
> rpm -qa | grep oracle
> oracle-instantclient11.2-odbc-11.2.0.1.0-1
> oracle-instantclient-sqlplus-10.2.0.3-1
> oracle-instantclient-basic-10.2.0.3-1
> oracle-instantclient11.2-basic-11.2.0.1.0-1
> oracle-instantclient11.2-devel-11.2.0.1.0-1
> oracle-instantclient-devel-10.2.0.3-1
> oracle-instantclient-jdbc-10.2.0.3-1
>  when I try to install the following, I get
> rpm -i  perl-DBD-Oracle-1.19-1.el5.i386.rpm
> warning: perl-DBD-Oracle-1.19-1.el5.i386.rpm: Header V3 DSA signature:
> NOKEY, key ID e42d547b
> 
> error: Failed dependencies:
> 
>         libclntsh.so.10.1 is needed by perl-DBD-Oracle-1.19-1.el5.i386
> 
>         libnnz10.so is needed by perl-DBD-Oracle-1.19-1.el5.i386
> 
>         libocci.so.10.1 is needed by perl-DBD-Oracle-1.19-1.el5.i386
> 
> 
>         libociei.so is needed by perl-DBD-Oracle-1.19-1.el5.i386
> 
>         libocijdbc10.so is needed by perl-DBD-Oracle-1.19-1.el5.i386

I had similar problems on RHEL5 just recently. This is one of the few 
packages on RHEL5 where I'd recommend installing DBD::Oracle from CPAN 
rather than installing it as an .rpm

I wouldn't bother with oracle-instantclient11.2* unless you have to. I 
had no end of trouble with it, lots of wierd problems with 
disconnections (ORA-12540) and failing to connect to a know good 
listener (ORA-12541), with no joy debugging it at all.

Also after you've installed your oracle packages, you need to make sure
that your $ORACLE_HOME is pointing to the right place.

I didn't use $LD_LIBRARY_PATH, instead I added an entry in;
  /etc/ld.so.conf.d/oracle.conf
with all the paths to the libraries, eg:
# cat oracle.conf
/usr/lib/oracle/10.2.0.4/client/lib

then run;
  ldconfig -v | less
to confirm.

Then used cpan to download and unpack the module, cd'd in 
$HOME/.cpan/build/DBD-Oracle* and ran;
# make
# make install

Perhaps not very redhatty, but worked fine.

regards,

Kim