DBD::Oracle on OS X Success!

[Tom Mornini]

Thanks to Andy Lester <[EMAIL PROTECTED]> and Steve Sapovits <[EMAIL PROTECTED]>, I've figured out a way to get DBD::Oracle to compile and pass all tests on OS X 10.2.2 Jaguar against Oracle 9iR2 DP.

It's quite ugly. I'm working on a simpler procedure and I'll share it if it pans out.

Here's the procedure that I know works. Pick and choose the pieces that work for you.

Also, please note that this solution has not been heavily tested in any sort of real world situation. In particular, it's *very* possible that this procedure could render other code from being able to link properly against the Oracle client libraries.

0) Proceed fully warned and at your own risk!

1) Install Oracle exactly per Oracle documentation. If you change install locations, then you'll need to modify paths accordingly.

2) As oracle user download these support files and fix namespace collisions in Oracle's dynamic libraries.

cd
curl -O 'http://www.mornini.com/dbd-oracle-osx/oracle-support.tar.gz'
tar xfz oracle-support.tar.gz

** Please note, the following script contains pathnames that may need editing!

./remove_symbols_oracle

3) As admin user download and install Perl 5.8.0

cd
curl -O 'ftp://ftp.cpan.org/pub/CPAN/src/perl-5.8.0.tar.gz'
tar xfz perl-5.8.0.tar.gz
cd perl-5.8.0
./Configure -des
make
make test
sudo make install

4) As admin user download and install DBI

cd
curl -O 'http://www.cpan.org/modules/by-module/DBI/DBI-1.30.tar.gz'
tar xfz DBI-1.30.tar.gz
cd DBI-1.30
perl Makefile.PL
make
make test
sudo make install

5) As admin user download DBD::Oracle.

cd
curl -O 'http://www.cpan.org/modules/by-module/DBD/DBD-Oracle-1.12.tar.gz'
tar xfz DBD-Oracle-1.12.tar.gz

6) As admin user, patch DBD::Oracle's Makefile.PL.

cd ~/DBD-Oracle-1.12
curl -O 'http://www.mornini.com/dbd-oracle-osx/Makefile.PL.patch'
patch -p0 < Makefile.PL.patch

7) As admin user, make DBD::Oracle.

cd ~/DBD-Oracle-1.12
perl Makefile.PL
make

8) As admin user download these support files and fix namespace collisions in DBD::Oracle's dynamic libraries.

cd
curl -O 'http://www.mornini.com/dbd-oracle-osx/dbd-support.tar.gz'
tar xfz dbd-support.tar.gz

** Please note, the following script contains pathnames that may need editing!

./remove_symbols_dbi

9) As admin user, test and install DBD::Oracle

cd ~/DBD-Oracle-1.12
make test

10) As admin user, install DBD::Oracle

cd ~/DBD-Oracle-1.12
sudo make install

--
-- Tom Mornini
-- InfoMania Printing & Prepress
--
-- ICQ: 113526784, AOL, Yahoo, MSN and Jabber: tmornini