steps_to_install_dbd-oracle-1.14.txt

Installing Oracle 8.1.7 client libs to then build DBD::Oracle 1.14

A final, successful result flowed from the following environment:

Debian 3.0 (Woody) installed into a VM from isos.
VM environment provides ne2k-pci network card.


STEPS FROM THE HOST

0)  Acquire the Oracle817.tar.gz

1)  Untar the Oracle817.tar.gz file.

    $ tar zxfv Oracle817.tar.gz
    # should create ./mnt directory with installer contents

2)  Use dos2unix to convert the line endings in text files in the
    result of the untar.

    $ find ./mnt/ -exec dos2unix {} +
    # lots of output about converting files and skipping binary files

3) Make an .iso of the resulting directory

    $ genisoimage -o oracle817.iso -R -J ./mnt/


STEPS FROM THE GUEST

4) Load the iso into the VM and mount it

    # qemu/kvm uses the 'change' command within the vm console
    # use whatever environment to get the CD into the virtual drive
    $ su -c 'mkdir /mnt/cdrom; mount /dev/cdrom /mnt/cdrom'

5) run the installer

    $ cd /mnt/cdrom; ./runInstaller
    # Follow the on screen instructions and install the client (developer)

6) Download and install a more recent Perl than what is provided by the OS.

    $ tar zxfv perl-5.8.8.tar.gz
    $ cd perl-5.8.8; ./Configure -de -Dprefix=/foo/ # where ever you have perms
    $ make && make test && make install
    $ PATH=/foo/bin:$PATH

7) Using the newer perl as a bootstrap, install perlbrew, then new perl.

    $ su -c 'apt-get install curl-ssl'
    $ curl -LO http://xrl.us/perlbrew
    $ chmod +x perlbrew
    $ export PERLBREW_ROOT=/opt/perlbrew # or where ever you have perms
    $ ./perlbrew install
    # Follow the instructions after it installs

8) Install and switch to a newer perl, install cpanm

    $ perlbrew install perl-5.12.3
    $ perlbrew switch perl-5.12.3
    $ perlbrew install-cpanm
    $ cpanm App::cpanminus

9) Install DBI and DBD::Oracle-1.14

    $ cpanm DBI
    $ ORACLE_HOME=/where/ever/you/set cpanm --notest \
        http://backpan.perl.org/authors/id/T/TI/TIMB/DBD-Oracle-1.14.tar.gz