Hi Everybody,
Usually, I am able to figure out or find answers to DBD::Oracle installation
problems, but not this time… I am trying to get the module installed on Windows
Server 2008 R2 Enterprise (64-bit) running Strawberry Perl, as follows:
Summary of my perl5 (revision 5 version 12 subversion 1) configuration:
Platform:
osname=MSWin32, osvers=6.1, archname=MSWin32-x64-multi-thread
uname='Win32 strawberryperl 5.12.1.0 #1 Thu Jul 29 19:04:04 2010 x64'
config_args='undef'
hint=recommended, useposix=true, d_sigaction=undef
useithreads=define, usemultiplicity=define
useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=undef, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags =' -s -O2 -DWIN32 -DHAVE_DES_FCRYPT -DWIN64
-DCONSERVATIVE -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-fno-strict-aliasing -mms-bitfields -DPERL_MSVCRT_READFIX',
optimize='-s -O2',
cppflags='-DWIN32'
ccversion='', gccversion='4.4.3', gccosandvers=''
intsize=4, longsize=4, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='long long',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='g++', ldflags ='-s -L"C:\strawberry\perl\lib\CORE"
-L"C:\strawberry\c\lib"'
libpth=C:\strawberry\c\lib C:\strawberry\c\x86_64-w64-mingw32\lib
libs=-lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32
-ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr
-lwinmm -lversion -lodbc32 -lodbccp32 -lcomctl32
perllibs=-lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32
-ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr
-lwinmm -lversion -lodbc32 -lodbccp32 -lcomctl32
libc=, so=dll, useshrplib=true, libperl=libperl512.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
cccdlflags=' ', lddlflags='-mdll -s -L"C:\strawberry\perl\lib\CORE"
-L"C:\strawberry\c\lib"'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
PERL_IMPLICIT_CONTEXT PERL_IMPLICIT_SYS
PERL_MALLOC_WRAP PL_OP_SLAB_ALLOC USE_64_BIT_INT
USE_ITHREADS USE_LARGE_FILES USE_PERLIO USE_PERL_ATOF
USE_SITECUSTOMIZE
Built under MSWin32
Compiled at Jul 29 2010 19:18:08
%ENV:
PERL5LIB="c:\temp\splitStar-bin"
@INC:
c:\temp\splitStar-bin
c:/strawberry/perl/site/lib
c:/strawberry/perl/vendor/lib
c:/strawberry/perl/lib
.
-----------------
>perl Makefile.PL
-----------------
Using DBI 1.615 (for perl 5.012001 on MSWin32-x64-multi-thread) installed in
c:/strawberry/perl/vendor/lib/auto/DBI/
Configuring DBD::Oracle for perl 5.012001 on MSWin32 (MSWin32-x64-multi-thread)
Remember to actually *READ* the README file! Especially if you have any
problems.
Installing on a MSWin32, Ver#6.1
Using Oracle in E:/app/Dna_Admin/product/11.2.0/client_1/instantclient_11_2
DEFINE _SQLPLUS_RELEASE = "1102000100" (CHAR)
Oracle version 11.2.0.1 (11.2)
Using OCI directory 'sdk'
client_version=11.2
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\"
-DORA_OCI_102 -DORA_OCI_112
Checking for functioning wait.ph
System: perl5.012001 Win32 strawberryperl 5.12.1.0 #1 Thu Jul 29 19:04:04 2010
x64
Compiler: gcc -s -O2 -s -O2 -DWIN32 -DHAVE_DES_FCRYPT -DWIN64 -DCONSERVATIVE
-DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CON
TEXT -DPERL_IMPLICIT_SYS -fno-strict-aliasing -mms-bitfields
-DPERL_MSVCRT_READFIX
Linker: not found
Sysliblist:
Checking if your kit is complete...
Looks good
LD_RUN_PATH=E:/app/Dna_Admin/product/11.2.0/client_1/instantclient_11_2/lib:E:/app/Dna_Admin/product/11.2.0/client_1/ins
tantclient_11_2/rdbms/lib
Using DBD::Oracle 1.26.
Using DBD::Oracle 1.26.
Using DBI 1.615 (for perl 5.012001 on MSWin32-x64-multi-thread) installed in
c:/strawberry/perl/vendor/lib/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
----------------------------------------------------
‘make’ fails due to a bunch of undefined references:
----------------------------------------------------
Oracle.o:Oracle.c:(.text+0x34a2): undefined reference to `OCIPing'
dbdimp.o:dbdimp.c:(.text+0xb29d): undefined reference to `OCISessionRelease'
dbdimp.o:dbdimp.c:(.text+0xb6ea): undefined reference to `OCISessionPoolDestroy'
dbdimp.o:dbdimp.c:(.text+0xe15a): undefined reference to `OCISessionPoolCreate'
dbdimp.o:dbdimp.c:(.text+0xebf8): undefined reference to `OCISessionGet'
dbdimp.o:dbdimp.c:(.text+0xedd2): undefined reference to `OCISessionPoolDestroy'
collect2: ld returned 1 exit status
dmake: Error code 129, while making 'blib\arch\auto\DBD\Oracle\Oracle.dll'
----------------------------
>perl Makefile.PL -s OCIPing
----------------------------
Using DBI 1.615 (for perl 5.012001 on MSWin32-x64-multi-thread) installed in
c:/strawberry/perl/vendor/lib/auto/DBI/
Installing on a MSWin32, Ver#6.1
Using Oracle in E:/app/Dna_Admin/product/11.2.0/client_1/instantclient_11_2
DEFINE _SQLPLUS_RELEASE = "1102000100" (CHAR)
Oracle version 11.2.0.1 (11.2)
Searching for symbol 'OCIPing' in
E:/app/Dna_Admin/product/11.2.0/client_1/instantclient_11_2 ...
The system cannot find the path specified.
Search done.
(Please only include the 'interesting' parts when mailing.)
I wonder where these missing pieces are supposed to be, or what may be wrong
with my environment setup?
Thank you in advance,
Alexander Saip
