Re: My experience installing DBD Oracle for strawberry on win32

 Sorry for the repost.  I wanted to add some steps and explanations.


 DBD::Oracle install process on Windows XP with Strawberry perl
 Mike Case

 I started with
 http://win32.perl.org/wiki/index.php?title=Install_DBD::Oracle_on_Strawberry_Perl

 I could not find a 1.29 where I looked (see url below) so went with 
 1.28.

 I had installed perl at C:\Perl\strawberry

 1)  Installed the Oracle instant client by merging all three mentioned
     in that document into one folder structure.
 2)  I had to move my oracle instantclient to 
 C:\Oracle\instantclient_11_2
     (because the first place I put it, Program Files, had a space in 
 the
     name and this seemed to cause a problem.)
 3)  In the end I set all the following environment variables in DOS.
     I put the Oracle client up front of the path because at some point
     in the process cpan was "finding" a wrong one.  In the end I also
     decided to set the ORACLE_HOME myself.
     PATH=C:\Oracle\instantclient_11_2;%PATH%
     PATH=%PATH%;C:\Perl\strawberry\perl\bin;C:\Perl\strawberry\c\bin
     set ORACLE_HOME=C:\Oracle\instantclient_11_2
 4)  I always set this too, but I do not think it is needed for the
     actual install; just for when I'm running my own perl.
     SET PATHEXT=.pl;%PATHEXT%
 5)  I ran cpan which loaded an interactive session for me. I ran it
     from a DOS window to set the above stuff BEFORE going in to cpan.
 6)  cpan, set up proxy.  I was in a corp. env. and needed to use a
     proxy in cpan.  This is cool, it asks for the username and pass-
     word just fine:
     o conf  http_proxy http://blah.bla.bl:1234
 7)  set download url. Somehow I unset this :) and could not find the
     original default so I set it to:
     o conf urllist http://cpan.strawberryperl.com/
 8)  get DBD::Oracle
 9)  look DBD::Oracle
 10) edit oci.def as indicated on the web-page, added "OCIServerRelease"
     to the end of the file.
 11) perl Makefile.PL ran fine (finally!)
 12) dmake went fine with some unused variables errors that I ignored.
 13) dmake test said "passed" even when it did not run a lot of tests
     because there was no local database on my box.
 14) dmake test worked when I set ORACLE_USERID=my/whatever@ipaddr:port
     but I still had errors which bothers me in principle. However, it
     worked enough to go forward.
 15) dmake install went fine
 16) exit (back in cpan)
 17) q to get out of cpan.