Install Dbd Oracle Strawberry Perl
[PPM Index] DBD-Oracle - Oracle database driver for the DBI module.
Having issues with Perl 5.20.2 and Oracle::DBD, getting following error when trying to connect to Ora 12C DB, run out of ideas on how to identify what is wrong here. Installdriver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: loadfile:%1 is not a valid Win32 application at C:/Perl/lib/DynaLoader.pm line 194. At (eval 72) line 3. Compilation failed in require at (eval 72) line 3 My environment is as follows. Perl -v - This is perl 5, version 20, subversion 2 (v5.20.2) built for MSWin32-x86-multi-thread-64int. OS is Win 2008 R2 SP1.
Ora client is 12.1.0 (64 bit) Windows Environmental variables ORACLEHOME=C: Oracle12c product 12.1.0 client1 Path=C: Oracle12c product 12.1.0 client1 bin;C: Perl site bin;C: Perl bin;C: Windows system32;C: Windows;C: Windows System32 Wbem;C: Windows System32 WindowsPo werShell v1.0;c: dmake;D: NTRESKIT TNSADMIN=C: Oracle12c product 12.1.0 client1 bin. Figured it out.issue was not a files permission issue, the clue was in the '.not a valid Win32 application' verbiage. I removed the Oracle 12c 64-bit client and then installed the Oracle 12c 32-bit client, you can also install the 11g driver (apparently an Oracle client supports one version back and one version forward). I required the full 12c Ora client installer as I need access to the database tools like sqlloader, note that there is a bug in the 12c Oracle 32-bit installer, had to modify the install/oraparam.ini and replace MSVCREDISTLOC=vcredistx64.exe with MSVCREDISTLOC=vcredistx86.exe, took me a while to find the installer, link here, 32-bit driver at bottom of url) Also, very important to also add an ORACLEHOME Win env path, I also added the Oracle client to the Path and ensured that it was before the Perl entries in my Windows Path.
Message ID: DBD::Oracle install process on Windows XP with Strawberry perl Mike Case I started with 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 instantclient112 3) In the end I set all the following environment variables in DOS.
Install Dbd::oracle Perl Module
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 ORACLEHOME myself. PATH=C: Oracle instantclient112;%PATH% PATH=%PATH%;C: Perl strawberry perl bin;C: Perl strawberry c bin set ORACLEHOME=C: Oracle instantclient112 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. And needed to use a proxy in cpan. This is cool, it asks for the username and pass- word just fine: o conf httpproxy 7) set download url. Somehow I unset this:) and could not find the original default so I set it to: o conf urllist 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 ORACLEUSERID=my/whatever@ipaddr:port but I still had errors which bothers me in principle.
Perl Dbi Oracle
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. My experience installing DBD Oracle for strawberry on win32 by Michael Case.
by mec.