DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
am 10.04.2007 21:44:19 von aaron_saarela
Hi dbi-users,
I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core
files during the test phase. I've tried all the hints suggested in both
the README and README.help.txt files with the same result. Any
suggestions?
Info below:
=20
# uname -a
SunOS carnivore 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-V240
=20
# perl Makefile.PL -v
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
_perl/5.8.8/sun4-solaris-thread-multi-64int/auto/DBI/
=20
Configuring DBD::Oracle for perl 5.008008 on solaris
(sun4-solaris-thread-multi-64int)
=20
Remember to actually *READ* the README file! Especially if you have any
problems.
=20
Using Oracle in /opt/oracle
PATH=3D/opt/oracle/bin:/opt/oracle:/opt/VRTSperl/bin:.:opt/S UNWspro/bin:/=
o
pt/WS50/bin:/usr/openwin/bin:/sbi
n:/bin:/usr/sbin:/usr/dt/bin:/usr/local/bin:/usr/local/sbin: /usr/ucb:/us
r/ccs/bin:/etc:/opt/VRTSspcs/sal:
/opt/VRTSspcs/vxas/bin::/usr/local/bin:/opt/ansic/bin:/bin:/ sbin:/usr/bi
n:/usr/sbin:/usr/dt/bin:/usr/ccs/
bin:/etc:/usr/local/bin:/usr/contrib/bin/X11:/opt/langtools/ bin:/usr/ucb
:/usr/openwin/bin:/etc/opt/licens
es:.:/opt/proctool/bin:/usr/sbin:/opt/VRTSvmsa/bin:/opt/SUNW spro/bin:/us
r/local/samba/bin:/opt/oracle/bin
:/opt/oracle/bin
DEFINE _SQLPLUS_RELEASE =3D "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /opt/oracle/rdbms/demo/demo_rdbms.mk
Using /opt/oracle/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/lib:/usr/lib:/usr/openwin/lib:/usr/lib:/usr/dt/lib:/us r/open
win/lib:.:/opt/proctool/lib:/usr/local/samba/lib:/opt/oracle /lib32:/usr/
local/lib:/compaq/wbem/lib:/opt/o
racle/lib32'
Reading /opt/oracle/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/rdbms/lib/env_rdbms.mk
Read a total of 2895 lines from /opt/oracle/rdbms/lib/env_rdbms.mk
(including inclusions)
Read a total of 3196 lines from /opt/oracle/rdbms/demo/demo_rdbms.mk
(including inclusions)
Deleted SHELL definition: SHELL=3D/bin/sh
Deleted LIB_EXT definition: LIB_EXT=3Da
Deleted OBJ_EXT definition: OBJ_EXT=3Do
Deleted AR definition: AR=3Dar
Deleted AS definition: AS=3Das
Deleted CC definition: CC=3Dcc
Deleted CHMOD definition: CHMOD=3Dchmod
Deleted CPP definition: CPP=3Dcpp
Deleted ECHO definition: ECHO=3Decho
Deleted LD definition: LD=3Dld
Deleted PERL definition: PERL=3Dperl
Deleted CFLAGS definition: CFLAGS=3D$(GFLAG) $(OPTIMIZE) $(CDEBUG)
$(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=3D-o $@ $(LDPATHFLAG)$(PRODLIBHOME)
$(LDPATHFLAG)$(LIBHOME)
Deleted OPTIMIZE definition: OPTIMIZE=3D$(OPTIMIZE3)
Deleted AR definition: AR=3D/usr/ccs/bin/ar
Deleted AS definition: AS=3D/usr/ccs/bin/as
Deleted LD definition: LD=3D/usr/ccs/bin/ld
Deleted CPP definition: CPP=3D$(CC) -E $(ANSI)
Deleted CHMOD definition: CHMOD=3D/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=3D$(NOKPIC_ASFLAGS) $(KPIC_OPTION)
Deleted CCFLAGS definition: CCFLAGS=3D$(NOKPIC_CCFLAGS) $(KPIC_OPTION)
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /opt/oracle/lib/sysliblist`
returned '-lkstat -lnsl -lsocket -lgen -ldl -lsched '
=20
Attempting to discover Oracle OCI build rules
gcc -c DBD_ORA_OBJ.c
by executing: [make -f /opt/oracle/rdbms/demo/demo_rdbms.mk build
ECHODO=3Decho ECHO=3Decho GENCLNTSH=3D'echo g
enclntsh' CC=3Dtrue OPTIMIZE=3D CCFLAGS=3D EXE=3DDBD_ORA_EXE =
OBJS=3DDBD_ORA_OBJ.o]
returned:
[true -xarch=3Dv9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread]
reduced to:
[true -xarch=3Dv9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread]
Oracle oci build command:
[true -xarch=3Dv9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ =
-o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclnts
h `cat /opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4
-lkstat -lm -lthread -lpthread]
=20
Found header files in /opt/oracle/rdbms/public.
=20
Checking for functioning wait.ph
=20
System: perl5.008008 sunos thor1 5.8 generic_117350-26 sun4u sparc
sunw,sun-fire-v210
Compiler: gcc -O -D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/inc
lude -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64
Linker: /usr/ucb/ld
Sysliblist: -lkstat -lnsl -lsocket -lgen -ldl -lsched
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign
-xF $(XS) $(MR) -xildoff -errtags=3Dy
es -v -xarch=3Dv9 -xchip=3Dultra3 -W2,-AKNR_S -Wd,-xsafe=3Dunboundsym
-Wc,-Qiselect-funcalign=3D32 -xcode=3Dabs44 -
Wc,-Qgsched-trace_late=3D1 -Wc,-Qgsched-T5 -xalias_level=3Dweak =
-D_REENTRANT
-DSS_64BIT_SERVER -DBIT64 -DMACH
INE64 -K PIC -I/opt/oracle/rdbms/demo -I/opt/oracle/rdbms/public
-I/opt/oracle/plsql/public -I/opt/oracle
/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD
-D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/opt/oracle/rdbms/lib/ -L$(LIBHOME)]
Linking with OTHERLDFLAGS =3D -xarch=3Dv9 -L/opt/oracle/lib/
-L/opt/oracle/rdbms/lib/ -lclntsh `cat /opt/
oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat -lm
-lthread -lpthread [from 'build' ru
le]
=20
MakeMaker (v6.30)
Checking if your kit is complete...
Looks good
ABSTRACT_FROM =3D> q[Oracle.pm]
AUTHOR =3D> q[Tim Bunce (dbi-users@perl.org)]
DEFINE =3D> q[ -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=3D\"10.2.0.1\"]
DIR =3D> []
EXE_FILES =3D> [q[ora_explain]]
INC =3D> q[-I/opt/oracle/rdbms/public -I/opt/oracle/rdbms/demo
-I/opt/oracle/rdbms/public -I/opt/oracle/p
lsql/public -I/opt/oracle/network/public
-I/opt/VRTSperl/lib/site_perl/5.8.8/sun4-solaris-thread-mult i-64
int/auto/DBI]
NAME =3D> q[DBD::Oracle]
OBJECT =3D> q[$(O_FILES)]
PREREQ_PM =3D> { DBI=3D>q[0] }
VERSION_FROM =3D> q[Oracle.pm]
clean =3D> { FILES=3D>q[xstmp.c Oracle.xsi dll.base dll.exp sqlnet.log
libOracle.def ora_explain mk.pm DBD_
ORA_OBJ.*] }
dist =3D> { DIST_DEFAULT=3D>q[clean distcheck disttest tardist],
COMPRESS=3D>q[gzip -v9], PREOP=3D>q[$(MAKE) -f
Makefile.old distdir], SUFFIX=3D>q[gz] }
dynamic_lib =3D> { OTHERLDFLAGS=3D>q[ -xarch=3Dv9 -L/opt/oracle/lib/
-L/opt/oracle/rdbms/lib/ -lclntsh `c
at /opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread] }
Using PERL=3D/opt/VRTSperl/bin/perl
LD_RUN_PATH=3D/opt/oracle/lib32:/opt/oracle/rdbms/lib32
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
_perl/5.8.8/sun4-solaris-thread-multi-64int/auto/DBI/
Writing Makefile for DBD::Oracle
=20
*** 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?)
# perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=3Dsolaris, osvers=3D2.8, =
archname=3Dsun4-solaris-thread-multi-64int
uname=3D'sunos thor1 5.8 generic_117350-26 sun4u sparc
sunw,sun-fire-v210 '
config_args=3D'-de -Dcc=3Dgcc -Dmake=3Dmake -D =
prefix=3D/opt/VRTSperl -D
usethreads -D useithreads -D useperlio -D use64bitint'
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Ddefine use5005threads=3Dundef useithreads=3Ddefine
usemultiplicity=3Ddefine
useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
use64bitint=3Ddefine use64bitall=3Dundef uselongdouble=3Dundef
usemymalloc=3Dn, bincompat5005=3Dundef
Compiler:
cc=3D'gcc', ccflags =3D'-D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64',
optimize=3D'-O',
cppflags=3D'-D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include'
ccversion=3D'', gccversion=3D'3.4.2', gccosandvers=3D'solaris2.8'
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D87654321
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D16
ivtype=3D'long long', ivsize=3D8, nvtype=3D'double', nvsize=3D8,
Off_t=3D'off_t', lseeksize=3D8
alignbytes=3D8, prototype=3Ddefine
Linker and Libraries:
ld=3D'gcc', ldflags =3D' -L/usr/local/lib '
libpth=3D/usr/local/lib /usr/lib /usr/ccs/lib
libs=3D-lsocket -lnsl -ldl -lm -lpthread -lc
perllibs=3D-lsocket -lnsl -ldl -lm -lpthread -lc
libc=3D/lib/libc.so, so=3Dso, useshrplib=3Dfalse, =
libperl=3Dlibperl.a
gnulibc_version=3D''
Dynamic Linking:
dlsrc=3Ddl_dlopen.xs, dlext=3Dso, d_dlsymun=3Dundef, ccdlflags=3D' '
cccdlflags=3D'-fPIC', lddlflags=3D'-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP USE_64_BIT_INT USE_ITHREADS
USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API
Built under solaris
Compiled at Mar 8 2006 13:15:30
%ENV:
PERL_DL_DEBUG=3D""
@INC:
/opt/VRTSperl/lib/5.8.8/sun4-solaris-thread-multi-64int
/opt/VRTSperl/lib/5.8.8
/opt/VRTSperl/lib/site_perl/5.8.8/sun4-solaris-thread-multi- 64int
/opt/VRTSperl/lib/site_perl/5.8.8
/opt/VRTSperl/lib/site_perl
.
# make test
make test
PERL_DL_NONLAZY=3D1 /opt/VRTSperl/bin/perl "-MExtUtils::Command::MM" =
"-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................dubious
Test returned status 0 (wstat 139, 0x8b)
t/10general.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/15nls.................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20select..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/21nchar...............dubious
Test returned status 0 (wstat 139, 0x8b)
t/22nchar_al32utf8......dubious
Test returned status 0 (wstat 139, 0x8b)
t/22nchar_utf8..........dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db_8bit........dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db_al32utf8....dubious
Test returned status 0 (wstat 139, 0x8b)
t/24implicit_utf8.......dubious
Test returned status 0 (wstat 139, 0x8b)
t/25plsql...............dubious
Test returned status 0 (wstat 139, 0x8b)
t/26exe_array...........dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 2-14
Failed 13/14 tests, 7.14% okay
t/30long................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-470
Failed 470/470 tests, 0.00% okay
t/31lob.................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/50cursor..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/55nested..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................dubious
Test returned status 0 (wstat 139, 0x8b)
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ ------------
-------
t/01base.t 0 139 ?? ?? % ??
t/10general.t 0 139 ?? ?? % ??
t/15nls.t 0 139 9 18 200.00% 1-9
t/20select.t 0 139 ?? ?? % ??
t/21nchar.t 0 139 ?? ?? % ??
t/22nchar_al32utf8.t 0 139 ?? ?? % ??
t/22nchar_utf8.t 0 139 ?? ?? % ??
t/23wide_db.t 0 139 ?? ?? % ??
t/23wide_db_8bit.t 0 139 ?? ?? % ??
t/23wide_db_al32utf8.t 0 139 ?? ?? % ??
t/24implicit_utf8.t 0 139 ?? ?? % ??
t/25plsql.t 0 139 ?? ?? % ??
t/26exe_array.t 0 139 14 26 185.71% 2-14
t/30long.t 0 139 470 940 200.00% 1-470
t/31lob.t 0 139 9 18 200.00% 1-9
t/40ph_type.t 0 139 ?? ?? % ??
t/50cursor.t 0 139 ?? ?? % ??
t/55nested.t 0 139 ?? ?? % ??
t/70meta.t 0 139 ?? ?? % ??
1 test skipped.
Failed 19/20 test scripts, 5.00% okay. 501/502 subtests failed, 0.20%
okay.
*** Error code 255
make: Fatal error: Command failed for target `test_dynamic'
=20
# pstack core
fefe5bb0 XS_DBD__Oracle__dr_init_oci (137188, 302ef4, 1ca928, 2,
140dc4, 322ac8) + 1cc
00092d80 Perl_pp_entersub (137188, 1ca92c, 80, 0, 1ca924, 0) + 5c0
0008a4dc Perl_runops_standard (137188, 800000, 0, 0, 12c, 14cd50) + 2c
0002a458 S_run_body (137188, 1, 137188, 0, 137188, 137cfc) + 13c
0002a0a0 perl_run (137188, 1, 3, ffbff8dc, 134c00, 2) + 8c
0002698c main (3, ffbff8dc, ffbff8ec, 137170, 0, 0) + b8
0002676c _start (0, 0, 0, 0, 0, 0) + 5c
=20
Regards,=20
Aaron Saarela=20
Principle Software Engineer
Symantec Corporation
Email: aaron_saarela@symantec.com
Re: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
am 11.04.2007 14:04:01 von scoles
Well no exact answer but I might be able to point you in the right
direction. Seems Solaris has been a problem for a while.
Have a look at these links
http://www.zorranlabs.com/articles/step-by-step-installation -dbd-oracle-1.16-on-solaris-9-and-oracle-9-client.htm
http://research.imb.uq.edu.au/~l.rathbone/solaris/perl.shtml
and a few things here
http://cpanratings.perl.org/dist/DBD-Oracle
one of the longer term goals it to get it to compile out of the box with
more than just Lunix/Win. So if you get it to work please pass your notes
along.
""Aaron Saarela"" wrote in message
news:60328AC568AE14478B6A4D38E3C30C5705A65A12@rosxchcln6.ent erprise.veritas.com...
Hi dbi-users,
I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core
files during the test phase. I've tried all the hints suggested in both
the README and README.help.txt files with the same result. Any
suggestions?
Info below:
# uname -a
SunOS carnivore 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-V240
# perl Makefile.PL -v
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
_perl/5.8.8/sun4-solaris-thread-multi-64int/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on solaris
(sun4-solaris-thread-multi-64int)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /opt/oracle
PATH=/opt/oracle/bin:/opt/oracle:/opt/VRTSperl/bin:.:opt/SUN Wspro/bin:/o
pt/WS50/bin:/usr/openwin/bin:/sbi
n:/bin:/usr/sbin:/usr/dt/bin:/usr/local/bin:/usr/local/sbin: /usr/ucb:/us
r/ccs/bin:/etc:/opt/VRTSspcs/sal:
/opt/VRTSspcs/vxas/bin::/usr/local/bin:/opt/ansic/bin:/bin:/ sbin:/usr/bi
n:/usr/sbin:/usr/dt/bin:/usr/ccs/
bin:/etc:/usr/local/bin:/usr/contrib/bin/X11:/opt/langtools/ bin:/usr/ucb
:/usr/openwin/bin:/etc/opt/licens
es:.:/opt/proctool/bin:/usr/sbin:/opt/VRTSvmsa/bin:/opt/SUNW spro/bin:/us
r/local/samba/bin:/opt/oracle/bin
:/opt/oracle/bin
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /opt/oracle/rdbms/demo/demo_rdbms.mk
Using /opt/oracle/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/lib:/usr/lib:/usr/openwin/lib:/usr/lib:/usr/dt/lib:/us r/open
win/lib:.:/opt/proctool/lib:/usr/local/samba/lib:/opt/oracle /lib32:/usr/
local/lib:/compaq/wbem/lib:/opt/o
racle/lib32'
Reading /opt/oracle/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/rdbms/lib/env_rdbms.mk
Read a total of 2895 lines from /opt/oracle/rdbms/lib/env_rdbms.mk
(including inclusions)
Read a total of 3196 lines from /opt/oracle/rdbms/demo/demo_rdbms.mk
(including inclusions)
Deleted SHELL definition: SHELL=/bin/sh
Deleted LIB_EXT definition: LIB_EXT=a
Deleted OBJ_EXT definition: OBJ_EXT=o
Deleted AR definition: AR=ar
Deleted AS definition: AS=as
Deleted CC definition: CC=cc
Deleted CHMOD definition: CHMOD=chmod
Deleted CPP definition: CPP=cpp
Deleted ECHO definition: ECHO=echo
Deleted LD definition: LD=ld
Deleted PERL definition: PERL=perl
Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG)
$(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME)
$(LDPATHFLAG)$(LIBHOME)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE3)
Deleted AR definition: AR=/usr/ccs/bin/ar
Deleted AS definition: AS=/usr/ccs/bin/as
Deleted LD definition: LD=/usr/ccs/bin/ld
Deleted CPP definition: CPP=$(CC) -E $(ANSI)
Deleted CHMOD definition: CHMOD=/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=$(NOKPIC_ASFLAGS) $(KPIC_OPTION)
Deleted CCFLAGS definition: CCFLAGS=$(NOKPIC_CCFLAGS) $(KPIC_OPTION)
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /opt/oracle/lib/sysliblist`
returned '-lkstat -lnsl -lsocket -lgen -ldl -lsched '
Attempting to discover Oracle OCI build rules
gcc -c DBD_ORA_OBJ.c
by executing: [make -f /opt/oracle/rdbms/demo/demo_rdbms.mk build
ECHODO=echo ECHO=echo GENCLNTSH='echo g
enclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
returned:
[true -xarch=v9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread]
reduced to:
[true -xarch=v9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread]
Oracle oci build command:
[true -xarch=v9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclnts
h `cat /opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4
-lkstat -lm -lthread -lpthread]
Found header files in /opt/oracle/rdbms/public.
Checking for functioning wait.ph
System: perl5.008008 sunos thor1 5.8 generic_117350-26 sun4u sparc
sunw,sun-fire-v210
Compiler: gcc -O -D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/inc
lude -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/ucb/ld
Sysliblist: -lkstat -lnsl -lsocket -lgen -ldl -lsched
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign
-xF $(XS) $(MR) -xildoff -errtags=y
es -v -xarch=v9 -xchip=ultra3 -W2,-AKNR_S -Wd,-xsafe=unboundsym
-Wc,-Qiselect-funcalign=32 -xcode=abs44 -
Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak -D_REENTRANT
-DSS_64BIT_SERVER -DBIT64 -DMACH
INE64 -K PIC -I/opt/oracle/rdbms/demo -I/opt/oracle/rdbms/public
-I/opt/oracle/plsql/public -I/opt/oracle
/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD
-D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/opt/oracle/rdbms/lib/ -L$(LIBHOME)]
Linking with OTHERLDFLAGS = -xarch=v9 -L/opt/oracle/lib/
-L/opt/oracle/rdbms/lib/ -lclntsh `cat /opt/
oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat -lm
-lthread -lpthread [from 'build' ru
le]
MakeMaker (v6.30)
Checking if your kit is complete...
Looks good
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce (dbi-users@perl.org)]
DEFINE => q[ -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"10.2.0.1\"]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-I/opt/oracle/rdbms/public -I/opt/oracle/rdbms/demo
-I/opt/oracle/rdbms/public -I/opt/oracle/p
lsql/public -I/opt/oracle/network/public
-I/opt/VRTSperl/lib/site_perl/5.8.8/sun4-solaris-thread-mult i-64
int/auto/DBI]
NAME => q[DBD::Oracle]
OBJECT => q[$(O_FILES)]
PREREQ_PM => { DBI=>q[0] }
VERSION_FROM => q[Oracle.pm]
clean => { FILES=>q[xstmp.c Oracle.xsi dll.base dll.exp sqlnet.log
libOracle.def ora_explain mk.pm DBD_
ORA_OBJ.*] }
dist => { DIST_DEFAULT=>q[clean distcheck disttest tardist],
COMPRESS=>q[gzip -v9], PREOP=>q[$(MAKE) -f
Makefile.old distdir], SUFFIX=>q[gz] }
dynamic_lib => { OTHERLDFLAGS=>q[ -xarch=v9 -L/opt/oracle/lib/
-L/opt/oracle/rdbms/lib/ -lclntsh `c
at /opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread] }
Using PERL=/opt/VRTSperl/bin/perl
LD_RUN_PATH=/opt/oracle/lib32:/opt/oracle/rdbms/lib32
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
_perl/5.8.8/sun4-solaris-thread-multi-64int/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?)
# perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=solaris, osvers=2.8, archname=sun4-solaris-thread-multi-64int
uname='sunos thor1 5.8 generic_117350-26 sun4u sparc
sunw,sun-fire-v210 '
config_args='-de -Dcc=gcc -Dmake=make -D prefix=/opt/VRTSperl -D
usethreads -D useithreads -D useperlio -D use64bitint'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=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 ='-D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include'
ccversion='', gccversion='3.4.2', gccosandvers='solaris2.8'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t', lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib '
libpth=/usr/local/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lpthread -lc
perllibs=-lsocket -lnsl -ldl -lm -lpthread -lc
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP USE_64_BIT_INT USE_ITHREADS
USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API
Built under solaris
Compiled at Mar 8 2006 13:15:30
%ENV:
PERL_DL_DEBUG=""
@INC:
/opt/VRTSperl/lib/5.8.8/sun4-solaris-thread-multi-64int
/opt/VRTSperl/lib/5.8.8
/opt/VRTSperl/lib/site_perl/5.8.8/sun4-solaris-thread-multi- 64int
/opt/VRTSperl/lib/site_perl/5.8.8
/opt/VRTSperl/lib/site_perl
.
# make test
make test
PERL_DL_NONLAZY=1 /opt/VRTSperl/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................dubious
Test returned status 0 (wstat 139, 0x8b)
t/10general.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/15nls.................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20select..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/21nchar...............dubious
Test returned status 0 (wstat 139, 0x8b)
t/22nchar_al32utf8......dubious
Test returned status 0 (wstat 139, 0x8b)
t/22nchar_utf8..........dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db_8bit........dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db_al32utf8....dubious
Test returned status 0 (wstat 139, 0x8b)
t/24implicit_utf8.......dubious
Test returned status 0 (wstat 139, 0x8b)
t/25plsql...............dubious
Test returned status 0 (wstat 139, 0x8b)
t/26exe_array...........dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 2-14
Failed 13/14 tests, 7.14% okay
t/30long................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-470
Failed 470/470 tests, 0.00% okay
t/31lob.................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/50cursor..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/55nested..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................dubious
Test returned status 0 (wstat 139, 0x8b)
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ ------------
-------
t/01base.t 0 139 ?? ?? % ??
t/10general.t 0 139 ?? ?? % ??
t/15nls.t 0 139 9 18 200.00% 1-9
t/20select.t 0 139 ?? ?? % ??
t/21nchar.t 0 139 ?? ?? % ??
t/22nchar_al32utf8.t 0 139 ?? ?? % ??
t/22nchar_utf8.t 0 139 ?? ?? % ??
t/23wide_db.t 0 139 ?? ?? % ??
t/23wide_db_8bit.t 0 139 ?? ?? % ??
t/23wide_db_al32utf8.t 0 139 ?? ?? % ??
t/24implicit_utf8.t 0 139 ?? ?? % ??
t/25plsql.t 0 139 ?? ?? % ??
t/26exe_array.t 0 139 14 26 185.71% 2-14
t/30long.t 0 139 470 940 200.00% 1-470
t/31lob.t 0 139 9 18 200.00% 1-9
t/40ph_type.t 0 139 ?? ?? % ??
t/50cursor.t 0 139 ?? ?? % ??
t/55nested.t 0 139 ?? ?? % ??
t/70meta.t 0 139 ?? ?? % ??
1 test skipped.
Failed 19/20 test scripts, 5.00% okay. 501/502 subtests failed, 0.20%
okay.
*** Error code 255
make: Fatal error: Command failed for target `test_dynamic'
# pstack core
fefe5bb0 XS_DBD__Oracle__dr_init_oci (137188, 302ef4, 1ca928, 2,
140dc4, 322ac8) + 1cc
00092d80 Perl_pp_entersub (137188, 1ca92c, 80, 0, 1ca924, 0) + 5c0
0008a4dc Perl_runops_standard (137188, 800000, 0, 0, 12c, 14cd50) + 2c
0002a458 S_run_body (137188, 1, 137188, 0, 137188, 137cfc) + 13c
0002a0a0 perl_run (137188, 1, 3, ffbff8dc, 134c00, 2) + 8c
0002698c main (3, ffbff8dc, ffbff8ec, 137170, 0, 0) + b8
0002676c _start (0, 0, 0, 0, 0, 0) + 5c
Regards,
Aaron Saarela
Principle Software Engineer
Symantec Corporation
Email: aaron_saarela@symantec.com
RE: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
am 11.04.2007 14:53:23 von aaron_saarela
Thanks for the pointers. I was able to successfully compile and link
DBD::Oracle but the tests are failing. If I try to use the module, it
dumps core during connect. =20
=20
-----Original Message-----
From: John Scoles [mailto:scoles@pythian.com]=20
Sent: Wednesday, April 11, 2007 8:04 AM
To: dbi-users@perl.org
Subject: Re: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 -
Solaris build
Well no exact answer but I might be able to point you in the right
direction. Seems Solaris has been a problem for a while.
Have a look at these links
http://www.zorranlabs.com/articles/step-by-step-installation -dbd-oracle-
1.16-on-solaris-9-and-oracle-9-client.htm
http://research.imb.uq.edu.au/~l.rathbone/solaris/perl.shtml
and a few things here
http://cpanratings.perl.org/dist/DBD-Oracle
one of the longer term goals it to get it to compile out of the box with
more than just Lunix/Win. So if you get it to work please pass your
notes along.
""Aaron Saarela"" wrote in message
news:60328AC568AE14478B6A4D38E3C30C5705A65A12@rosxchcln6.ent erprise.veri
tas.com...
Hi dbi-users,
I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core
files during the test phase. I've tried all the hints suggested in both
the README and README.help.txt files with the same result. Any
suggestions?
Info below:
# uname -a
SunOS carnivore 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-V240
# perl Makefile.PL -v
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
_perl/5.8.8/sun4-solaris-thread-multi-64int/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on solaris
(sun4-solaris-thread-multi-64int)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /opt/oracle
PATH=3D/opt/oracle/bin:/opt/oracle:/opt/VRTSperl/bin:.:opt/S UNWspro/bin:/=
o
pt/WS50/bin:/usr/openwin/bin:/sbi
n:/bin:/usr/sbin:/usr/dt/bin:/usr/local/bin:/usr/local/sbin: /usr/ucb:/us
r/ccs/bin:/etc:/opt/VRTSspcs/sal:
/opt/VRTSspcs/vxas/bin::/usr/local/bin:/opt/ansic/bin:/bin:/ sbin:/usr/bi
n:/usr/sbin:/usr/dt/bin:/usr/ccs/
bin:/etc:/usr/local/bin:/usr/contrib/bin/X11:/opt/langtools/ bin:/usr/ucb
:/usr/openwin/bin:/etc/opt/licens
es:.:/opt/proctool/bin:/usr/sbin:/opt/VRTSvmsa/bin:/opt/SUNW spro/bin:/us
r/local/samba/bin:/opt/oracle/bin
:/opt/oracle/bin
DEFINE _SQLPLUS_RELEASE =3D "1002000100" (CHAR) Oracle version 10.2.0.1
(10.2) Found /opt/oracle/rdbms/demo/demo_rdbms.mk
Using /opt/oracle/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/lib:/usr/lib:/usr/openwin/lib:/usr/lib:/usr/dt/lib:/us r/open
win/lib:.:/opt/proctool/lib:/usr/local/samba/lib:/opt/oracle /lib32:/usr/
local/lib:/compaq/wbem/lib:/opt/o
racle/lib32'
Reading /opt/oracle/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/rdbms/lib/env_rdbms.mk
Read a total of 2895 lines from /opt/oracle/rdbms/lib/env_rdbms.mk
(including inclusions)
Read a total of 3196 lines from /opt/oracle/rdbms/demo/demo_rdbms.mk
(including inclusions)
Deleted SHELL definition: SHELL=3D/bin/sh
Deleted LIB_EXT definition: LIB_EXT=3Da
Deleted OBJ_EXT definition: OBJ_EXT=3Do
Deleted AR definition: AR=3Dar
Deleted AS definition: AS=3Das
Deleted CC definition: CC=3Dcc
Deleted CHMOD definition: CHMOD=3Dchmod
Deleted CPP definition: CPP=3Dcpp
Deleted ECHO definition: ECHO=3Decho
Deleted LD definition: LD=3Dld
Deleted PERL definition: PERL=3Dperl
Deleted CFLAGS definition: CFLAGS=3D$(GFLAG) $(OPTIMIZE) $(CDEBUG)
$(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=3D-o $@ $(LDPATHFLAG)$(PRODLIBHOME)
$(LDPATHFLAG)$(LIBHOME)
Deleted OPTIMIZE definition: OPTIMIZE=3D$(OPTIMIZE3) Deleted AR
definition: AR=3D/usr/ccs/bin/ar Deleted AS definition: =
AS=3D/usr/ccs/bin/as
Deleted LD definition: LD=3D/usr/ccs/bin/ld Deleted CPP definition:
CPP=3D$(CC) -E $(ANSI) Deleted CHMOD definition: CHMOD=3D/bin/chmod =
Deleted
ASFLAGS definition: ASFLAGS=3D$(NOKPIC_ASFLAGS) $(KPIC_OPTION) Deleted
CCFLAGS definition: CCFLAGS=3D$(NOKPIC_CCFLAGS) $(KPIC_OPTION) =
Evaluating
`cat $(LIBHOME)sysliblist`
expanded `cat /opt/oracle/lib/sysliblist`
returned '-lkstat -lnsl -lsocket -lgen -ldl -lsched '
Attempting to discover Oracle OCI build rules
gcc -c DBD_ORA_OBJ.c
by executing: [make -f /opt/oracle/rdbms/demo/demo_rdbms.mk build
ECHODO=3Decho ECHO=3Decho GENCLNTSH=3D'echo g enclntsh' CC=3Dtrue =
OPTIMIZE=3D
CCFLAGS=3D EXE=3DDBD_ORA_EXE OBJS=3DDBD_ORA_OBJ.o]
returned:
[true -xarch=3Dv9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread] reduced to:
[true -xarch=3Dv9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread] Oracle oci build command:
[true -xarch=3Dv9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ =
-o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclnts
h `cat /opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4
-lkstat -lm -lthread -lpthread]
Found header files in /opt/oracle/rdbms/public.
Checking for functioning wait.ph
System: perl5.008008 sunos thor1 5.8 generic_117350-26 sun4u sparc
sunw,sun-fire-v210
Compiler: gcc -O -D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/inc lude -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64
Linker: /usr/ucb/ld
Sysliblist: -lkstat -lnsl -lsocket -lgen -ldl -lsched Oracle makefiles
would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign
-xF $(XS) $(MR) -xildoff -errtags=3Dy es -v -xarch=3Dv9 -xchip=3Dultra3
-W2,-AKNR_S -Wd,-xsafe=3Dunboundsym
-Wc,-Qiselect-funcalign=3D32 -xcode=3Dabs44 -
Wc,-Qgsched-trace_late=3D1 -Wc,-Qgsched-T5 -xalias_level=3Dweak =
-D_REENTRANT
-DSS_64BIT_SERVER -DBIT64 -DMACH
INE64 -K PIC -I/opt/oracle/rdbms/demo -I/opt/oracle/rdbms/public
-I/opt/oracle/plsql/public -I/opt/oracle /network/public -DSLMXMX_ENABLE
-DSLTS_ENABLE -D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/opt/oracle/rdbms/lib/ -L$(LIBHOME)] Linking with
OTHERLDFLAGS =3D -xarch=3Dv9 -L/opt/oracle/lib/
-L/opt/oracle/rdbms/lib/ -lclntsh `cat /opt/
oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat -lm
-lthread -lpthread [from 'build' ru le]
MakeMaker (v6.30)
Checking if your kit is complete...
Looks good
ABSTRACT_FROM =3D> q[Oracle.pm]
AUTHOR =3D> q[Tim Bunce (dbi-users@perl.org)]
DEFINE =3D> q[ -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=3D\"10.2.0.1\"]
DIR =3D> []
EXE_FILES =3D> [q[ora_explain]]
INC =3D> q[-I/opt/oracle/rdbms/public -I/opt/oracle/rdbms/demo
-I/opt/oracle/rdbms/public -I/opt/oracle/p lsql/public
-I/opt/oracle/network/public
-I/opt/VRTSperl/lib/site_perl/5.8.8/sun4-solaris-thread-mult i-64
int/auto/DBI]
NAME =3D> q[DBD::Oracle]
OBJECT =3D> q[$(O_FILES)]
PREREQ_PM =3D> { DBI=3D>q[0] }
VERSION_FROM =3D> q[Oracle.pm]
clean =3D> { FILES=3D>q[xstmp.c Oracle.xsi dll.base dll.exp sqlnet.log
libOracle.def ora_explain mk.pm DBD_ ORA_OBJ.*] }
dist =3D> { DIST_DEFAULT=3D>q[clean distcheck disttest tardist],
COMPRESS=3D>q[gzip -v9], PREOP=3D>q[$(MAKE) -f Makefile.old distdir],
SUFFIX=3D>q[gz] }
dynamic_lib =3D> { OTHERLDFLAGS=3D>q[ -xarch=3Dv9 -L/opt/oracle/lib/
-L/opt/oracle/rdbms/lib/ -lclntsh `c
at /opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread] } Using PERL=3D/opt/VRTSperl/bin/perl
LD_RUN_PATH=3D/opt/oracle/lib32:/opt/oracle/rdbms/lib32
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
_perl/5.8.8/sun4-solaris-thread-multi-64int/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?)
# perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=3Dsolaris, osvers=3D2.8, =
archname=3Dsun4-solaris-thread-multi-64int
uname=3D'sunos thor1 5.8 generic_117350-26 sun4u sparc
sunw,sun-fire-v210 '
config_args=3D'-de -Dcc=3Dgcc -Dmake=3Dmake -D =
prefix=3D/opt/VRTSperl -D
usethreads -D useithreads -D useperlio -D use64bitint'
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Ddefine use5005threads=3Dundef useithreads=3Ddefine
usemultiplicity=3Ddefine
useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
use64bitint=3Ddefine use64bitall=3Dundef uselongdouble=3Dundef
usemymalloc=3Dn, bincompat5005=3Dundef
Compiler:
cc=3D'gcc', ccflags =3D'-D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64',
optimize=3D'-O',
cppflags=3D'-D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include'
ccversion=3D'', gccversion=3D'3.4.2', gccosandvers=3D'solaris2.8'
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D87654321
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D16
ivtype=3D'long long', ivsize=3D8, nvtype=3D'double', nvsize=3D8,
Off_t=3D'off_t', lseeksize=3D8
alignbytes=3D8, prototype=3Ddefine
Linker and Libraries:
ld=3D'gcc', ldflags =3D' -L/usr/local/lib '
libpth=3D/usr/local/lib /usr/lib /usr/ccs/lib
libs=3D-lsocket -lnsl -ldl -lm -lpthread -lc
perllibs=3D-lsocket -lnsl -ldl -lm -lpthread -lc
libc=3D/lib/libc.so, so=3Dso, useshrplib=3Dfalse, =
libperl=3Dlibperl.a
gnulibc_version=3D''
Dynamic Linking:
dlsrc=3Ddl_dlopen.xs, dlext=3Dso, d_dlsymun=3Dundef, ccdlflags=3D' '
cccdlflags=3D'-fPIC', lddlflags=3D'-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP USE_64_BIT_INT USE_ITHREADS
USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API
Built under solaris
Compiled at Mar 8 2006 13:15:30
%ENV:
PERL_DL_DEBUG=3D""
@INC:
/opt/VRTSperl/lib/5.8.8/sun4-solaris-thread-multi-64int
/opt/VRTSperl/lib/5.8.8
/opt/VRTSperl/lib/site_perl/5.8.8/sun4-solaris-thread-multi- 64int
/opt/VRTSperl/lib/site_perl/5.8.8
/opt/VRTSperl/lib/site_perl
.
# make test
make test
PERL_DL_NONLAZY=3D1 /opt/VRTSperl/bin/perl "-MExtUtils::Command::MM" =
"-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................dubious
Test returned status 0 (wstat 139, 0x8b)
t/10general.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/15nls.................dubious
Test returned status 0 (wstat 139, 0x8b) DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20select..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/21nchar...............dubious
Test returned status 0 (wstat 139, 0x8b)
t/22nchar_al32utf8......dubious
Test returned status 0 (wstat 139, 0x8b)
t/22nchar_utf8..........dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db_8bit........dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db_al32utf8....dubious
Test returned status 0 (wstat 139, 0x8b)
t/24implicit_utf8.......dubious
Test returned status 0 (wstat 139, 0x8b)
t/25plsql...............dubious
Test returned status 0 (wstat 139, 0x8b)
t/26exe_array...........dubious
Test returned status 0 (wstat 139, 0x8b) DIED. FAILED tests 2-14
Failed 13/14 tests, 7.14% okay
t/30long................dubious
Test returned status 0 (wstat 139, 0x8b) DIED. FAILED tests
1-470
Failed 470/470 tests, 0.00% okay t/31lob.................dubious
Test returned status 0 (wstat 139, 0x8b) DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/50cursor..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/55nested..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................dubious
Test returned status 0 (wstat 139, 0x8b)
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ ------------
-------
t/01base.t 0 139 ?? ?? % ??
t/10general.t 0 139 ?? ?? % ??
t/15nls.t 0 139 9 18 200.00% 1-9
t/20select.t 0 139 ?? ?? % ??
t/21nchar.t 0 139 ?? ?? % ??
t/22nchar_al32utf8.t 0 139 ?? ?? % ??
t/22nchar_utf8.t 0 139 ?? ?? % ??
t/23wide_db.t 0 139 ?? ?? % ??
t/23wide_db_8bit.t 0 139 ?? ?? % ??
t/23wide_db_al32utf8.t 0 139 ?? ?? % ??
t/24implicit_utf8.t 0 139 ?? ?? % ??
t/25plsql.t 0 139 ?? ?? % ??
t/26exe_array.t 0 139 14 26 185.71% 2-14
t/30long.t 0 139 470 940 200.00% 1-470
t/31lob.t 0 139 9 18 200.00% 1-9
t/40ph_type.t 0 139 ?? ?? % ??
t/50cursor.t 0 139 ?? ?? % ??
t/55nested.t 0 139 ?? ?? % ??
t/70meta.t 0 139 ?? ?? % ??
1 test skipped.
Failed 19/20 test scripts, 5.00% okay. 501/502 subtests failed, 0.20%
okay.
*** Error code 255
make: Fatal error: Command failed for target `test_dynamic'
# pstack core
fefe5bb0 XS_DBD__Oracle__dr_init_oci (137188, 302ef4, 1ca928, 2,
140dc4, 322ac8) + 1cc 00092d80 Perl_pp_entersub (137188, 1ca92c, 80, 0,
1ca924, 0) + 5c0 0008a4dc Perl_runops_standard (137188, 800000, 0, 0,
12c, 14cd50) + 2c
0002a458 S_run_body (137188, 1, 137188, 0, 137188, 137cfc) + 13c
0002a0a0 perl_run (137188, 1, 3, ffbff8dc, 134c00, 2) + 8c
0002698c main (3, ffbff8dc, ffbff8ec, 137170, 0, 0) + b8
0002676c _start (0, 0, 0, 0, 0, 0) + 5c
Regards,
Aaron Saarela
Principle Software Engineer
Symantec Corporation
Email: aaron_saarela@symantec.com
RE: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
am 12.04.2007 16:37:11 von aaron_saarela
=20
As a follow up, I rebuilt Perl using the Sun CC compiler and without the
"-D use64bitint" option. I rebuilt DBI and DBD::Oracle. All tests passed
and my connect no longer cores. I'm not sure how or if the 'use64bitint'
option was related to my previous problem but DBD is working now.