install perl DBD::Oracle
From the many tales of woe on the web about installing perl DBD::Oracle, from “invalid lvalue in assignment” to mysterious make errors, and the pages of intricate instructions doubtfully translated from the French, I assumed that it was a long and difficult process and it was natural that I was having problems installing on 64-bit CentOS. WRONG! It can actually be easy for lazy and dumb people like me.
First, just use yum and hand-compiling. Don’t add CPAN to the mix.
- Add the rpmforge repo and the EPEL repo (see links for instructions) so that you can install perl-DBD and perl-DBI via yum.
- Install perl-DBD and perl-DBI via yum.
- Download and install the OCI client “basic” and “sdk/devel” packages from Oracle. Note that you might need an older version if you’re connecting to an older version of Oracle. Note also that Oracle makes you log in to download this. Note also that you need both the SDK and the Basic package. I recommend getting the rpms – install with a simple rpm -Uvh .
- Oracle puts the libraries in a wacky place, e.g. /usr/lib/oracle/11.2/client64/lib if you’re using the 64-bit version of 11.2. Therefore, create a new file, e.g. oci.conf, in /etc/ld.so.conf.d/, with the library location in it, and then run (as root) ldconfig -v to add it. Read more …