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"" <aaron_saarela@xxxxxxxxxxxx> wrote in message
news:60328AC568AE14478B6A4D38E3C30C5705A65A12@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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/SUNWspro/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/SUNWspro/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:/usr/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@xxxxxxxx)]
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-multi-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@xxxxxxxxxxxx


.

Relevant Pages

  • DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
    ... I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core ... Configuring DBD::Oracle for perl 5.008008 on solaris ... Oracle version 10.2.0.1 ... Failed 13/14 tests, 7.14% okay ...
    (perl.dbi.users)
  • RE: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
    ... I was able to successfully compile and link ... Seems Solaris has been a problem for a while. ... Configuring DBD::Oracle for perl 5.008008 on solaris ... Failed 13/14 tests, 7.14% okay ...
    (perl.dbi.users)
  • install_driver(Oracle) failed: wrong ELF class: DynaLoader.pm
    ... i wrote a skript which works fine for several Oracle Versions on several platforms ... if i run that script ineractively on solaris 10 it also works fine. ... $ perl -V ...
    (perl.dbi.users)
  • Re: problems with Oracle DBD
    ... I administrate a Solaris 8 box which is used for a large Oracle database. ... There are some perl scripts that the main users of the database use, ... Googling for "solaris wrong elfclass ELFCLASS64" may give you some more pointers. ...
    (comp.lang.perl.misc)
  • Processor Faulted ERROR.....
    ... I have v490 i installed the Solaris 10, ... okay, but when i installed the oracle 10g today on ... Mail has the best spam protection around ...
    (SunManagers)