My experience installing DBD Oracle for strawberry on win32
[email protected] (Michael Case)
| Newsgroups | perl.win32.vanilla |
|---|---|
| Message-ID | <[email protected]> |
> > > > 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 > 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. > 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) perl Makefile.PL ran fine (finally!) > 9) dmake went fine with some unused variables errors that I ignored. > 10) dmake test said "passed" even when it did not run a lot of tests > because there was no local database on my box. > 11) 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. > 12) dmake install went fine > > So for, so good. I can connect to the db and run perl against oracle. > happy camper.