Trouble installing DBD-Oracle-1.23 on Cygwin

[david.karr]

I'm on Cygwin 1.5.25, Perl 5.10, and I'm trying to install DBI-1.608
and DBD-Oracle-1.23. The DBI installation went ok, but I'm having
trouble with the DBD portion. I don't have Oracle installed locally
(I mostly only use SQuirreL for connecting to my database). I tried
following the instructions in the DBI and DBD READMEs.

I installed the instantclient basic, sdk, and even sqlplus in c:/
oracle/instantclient_11_2 (the DBD README refers to "11_1", but I
would assume nothing is checking for that name).

The DBD README doesn't mention setting ORACLE_HOME, but it appears I
have to set it to the "instantclient" directory.

I set my ORACLE_DSN and ORACLE_USERID to refer to the database my
first script will be connecting to.

Supposedly it helps if I specify the client API version on the "perl"
command line, but I'm not certain exactly what that number would be.
I tried using both "perl Makefile.PL -V 10.2.0.4" (database version)
and "perl Makefile.PL -V 11.1.0.7" (driver version), but my results
are the same.

The "perl" and "make" lines appeared to complete without serious
complaint, but when I ran "make test", I got the following:

-----------------------
/usr/bin/perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01base..................# Test loading DBI, DBD::Oracle and version
t/01base..................1/6
# Failed test 'install_driver'
# at t/01base.t line 22.
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load '/c/frameworks/DBD-
Oracle-1.23/blib/arch/auto/DBD/Oracle/Oracle.dll' for module
DBD::Oracle: No such file or directory at /usr/lib/perl5/5.10/i686-
cygwin/DynaLoader.pm line 201.
at (eval 6) line 3
Compilation failed in require at (eval 6) line 3.

 

[Heinrich Mislik]

Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load '/c/frameworks/DBD-
Oracle-1.23/blib/arch/auto/DBD/Oracle/Oracle.dll' for module
DBD::Oracle: No such file or directory at /usr/lib/perl5/5.10/i686-
cygwin/DynaLoader.pm line 201.
at (eval 6) line 3
Compilation failed in require at (eval 6) line 3.

Try ldd on this file to see, wether all DLLs could be found. You may
need to add the directory of the Oracle-Client (that's where oci.dll
resides) to the PATH variable. Here is what I get:

ldd blib/arch/auto/DBD/Oracle/Oracle.dll
ntdll.dll => /cygdrive/c/Windows/SysWOW64/ntdll.dll (0x77710000)
kernel32.dll => /cygdrive/c/Windows/syswow64/kernel32.dll (0x76c40000)
KERNELBASE.dll => /cygdrive/c/Windows/syswow64/KERNELBASE.dll (0x76ad0000)
cygwin1.dll => /usr/bin/cygwin1.dll (0x61000000)
ADVAPI32.DLL => /cygdrive/c/Windows/syswow64/ADVAPI32.DLL (0x76fd0000)
msvcrt.dll => /cygdrive/c/Windows/syswow64/msvcrt.dll (0x75720000)
sechost.dll => /cygdrive/c/Windows/SysWOW64/sechost.dll (0x75590000)
RPCRT4.dll => /cygdrive/c/Windows/syswow64/RPCRT4.dll (0x75b00000)
SspiCli.dll => /cygdrive/c/Windows/syswow64/SspiCli.dll (0x75280000)
CRYPTBASE.dll => /cygdrive/c/Windows/syswow64/CRYPTBASE.dll (0x75270000)
cyggcc_s-1.dll => /usr/bin/cyggcc_s-1.dll (0x67f00000)
cygssp-0.dll => /usr/bin/cygssp-0.dll (0x67280000)
OCI.dll => /usr/local/oracle/OCI.dll (0x10000000)
MSVCR71.dll => /cygdrive/c/Windows/system32/MSVCR71.dll (0x7c340000)
PSAPI.DLL => /cygdrive/c/Windows/syswow64/PSAPI.DLL (0x76c30000)
cygperl5_10.dll => /usr/bin/cygperl5_10.dll (0x71520000)
cygcrypt-0.dll => /usr/bin/cygcrypt-0.dll (0x30000)

Cheers

Heinrich

 

[david.karr]

Try ldd on this file to see, wether all DLLs could be found. You may
need to add the directory of the Oracle-Client (that's where oci.dll
resides) to the PATH variable. Here is what I get:

Putting the directory with oci.dll on the PATH is what did it.
Thanks. I should have thought of that.