Are you aware of an existing DBA opening or consulting requirement in your organization? Enter your email for a chance to win one year's access to Safari Books.
DBD::Oracle and Instant Client 11.1.0.6.0
I have just managed to get DBD::Oracle to successfully compile, install, and test with the 11.1.0.6.0 Instant Client (IC) on a Linux (32bit) OS. It seems Oracle, in its wisdom, has changed the folder structure yet again, so to get it to compile, try this.
The table structure of the IC out of the RPMs is:
/usr/lib/oracle/11.1.0.1/client/ (Instant Client Package Basic)
/usr/share/oracle/11.1.0.1/client/ (SQL*Plus)
/usr/include/oracle/11.1.0.1/client/ (Instant Client - SDK)
So, doing the following . . .
export ORACLE_HOME=/usr/lib/oracle/11.1.0.1/client export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$PATH perl Makefile.PL -m /usr/share/oracle/11.1.0.1/client/demo.mk -h /usr/include/oracle/11.1.0.1/client/
. . . will work.
I have also updated the Makefile.PL, which can be found here: http://svn.perl.org/modules/dbd-oracle/trunk/Makefile.PL.
Cheers, John Scoles.
Apr 22, 2008
Category: DBD::Oracle, Oracle
Tags: 11.1.0.6.0, DBD::Oracle, DBI, Installing, Instant Client, Oracle
This a great program.