DBD::Oracle 1.19 with Oracle instantclient 10.2.0.3

Hello,

I wanted to contribute my experience with the compilation of DBD::Oracle 1.19 with the Oracle InstantClient 10.2.0.3 on Debian Etch.

I mainly followed the guide on http://jeanchristophe.duber.free.fr/dbd_oracle_instantclient _linux/
That documentation is based on an older Oracle InstantClient v10.1.0.3, so I had to make some modifications...

I will quickly point out my steps:

- Download DBD::Oracle (http://search.cpan.org/CPAN/authors/id/P/PY/PYTHIAN/DBD-Ora cle-1.19.tar.gz)
- Download Oracle InstantClient 10.2.0.3 (http://www.oracle.com/technology/software/tech/oci/instantc lient/htdocs/linuxsoft.html)
- instantclient-basic-linux32-10.2.0.3-20061115.zip
- instantclient-sdk-linux32-10.2.0.3-20061115.zip
- Extract all these archives to a meaningful directory ($DIR)
- Make necessary symbolic links
- cd $DIR/instantclient_10_2
- ln -s libclntsh.so.10.2 libclntsh.so
- ln -s libocci.so.10.2 libocci.so
- Get the adapted Makefile-instantclient.PL from http://jeanchristophe.duber.free.fr/dbd_oracle_instantclient _linux/Makefile-instantclient.PL
Save it to $DIR/DBD-Oracle-1.19/ and make it executable
- Get the following script (http://jeanchristophe.duber.free.fr/dbd_oracle_instantclien t_linux/oracle-instantclient-config) and place it somewhere in
your PATH + make it executable
- Edit the following in the above script (read between the lines):
prefix=$DIR/instantclient_10_2
version=10.2.0.3

incdirs="-I${exec_prefix}/sdk/include"
libdirs="-L${exec_prefix}"

- Go to $DIR/DBD-Oracle-1.19
- perl Makefile-instantclient.PL
- make
- (optionally change DESTDIR in Makefile)
- make install

Hope this is helpfull!!

I've also forwarded this message to the author of the above mentioned URL.

Regards,

Philip Brusten



Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm