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"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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@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-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: [EMAIL PROTECTED]
