You will have to point the compile job to point to the 32bit client. Can we the output of the perl Makefile.PL and make runs?
On Fri, Jun 4, 2010 at 2:17 AM, Yeow Yiew Choong-PBKN64 <pbk...@motorola.com > wrote: > Hi John, > > I use both 32bit & 64bit instant client of Oracle, still failed at make > test. > Thanks. > > regards, > YC > > ________________________________ > > From: John Scoles [mailto:byter...@hotmail.com] > Sent: Thursday, June 03, 2010 7:12 PM > To: Yeow Yiew Choong-PBKN64; dbi-users@perl.org > Subject: RE: Make Test Failed For DBD-Oracle 1.24 > > > If that is the case then use the 32bit instant client, (you can get that > for free from Oracle) > and compile against that. > > > > ________________________________ > > Subject: RE: Make Test Failed For DBD-Oracle 1.24 > Date: Thu, 3 Jun 2010 17:42:16 +0800 > From: pbk...@motorola.com > To: byter...@hotmail.com; dbi-users@perl.org > > > Hi John, > > I read in the link, but I do not have Gnu ld 64bit as mentioned in the > document. > I cannot do the same for my issue. > However, I found another link > http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=10 > 95121 which mentioned that most likely cause by mixing 32bit perl using > /usr/lib/dld.sl trying to access/load 64bit Oracle. > My perl version is listed below: > > # perl -V > Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration: > Platform: > osname=hpux, osvers=11.00, archname=PA-RISC1.1-thread-multi > > Can someone tell me what should I do. > Do I need to upgrade my perl to 64bit version? > How? > > Thanks. > > regards, > YC > > ________________________________ > > From: John Scoles [mailto:byter...@hotmail.com] > Sent: Wednesday, June 02, 2010 8:41 PM > To: Yeow Yiew Choong-PBKN64; dbi-users@perl.org > Subject: RE: Make Test Failed For DBD-Oracle 1.24 > > > Never ran into that myself but this link looks like the same error > > http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=10944 > 7626+1272030523151+28353475&threadId=1078200<http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=10944%0A7626+1272030523151+28353475&threadId=1078200> > > cheers > John > > > ________________________________ > > Subject: Make Test Failed For DBD-Oracle 1.24 > Date: Tue, 1 Jun 2010 19:04:44 +0800 > From: pbk...@motorola.com > To: dbi-users@perl.org > > > Hi, > > I have problem when I run "make test" for DBD::Oracle 1.24 module. > My Oracle database is on remote server. > Oracle database version is 10g, and my Oracle client is version 10.2 > (64bit) on HP-UX 11.11(PA-RISC) 64bit OS. > I can run splplus to connect to remote database. > My perl is version 5.8.3. > My DBI version is 1.611. > "perl Makefile.PL -l" and "make" command completed without error. > However, "make test" failed. > > Please refer the below output and maketest.log in attachment. > > # perl Makefile.PL -l > Using DBI 1.611 (for perl 5.008003 on PA-RISC1.1-thread-multi) installed > in /opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI/ > > Configuring DBD::Oracle for perl 5.008003 on hpux > (PA-RISC1.1-thread-multi) > > Remember to actually *READ* the README file! Especially if you have any > problems. > > Installing on a hpux, Ver#11.00 > Using Oracle in /opt/oracle/product/10.2.0/client_1 > DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR) > Oracle version 10.2.0.1 (10.2) > Found direct-link candidates: libclntsh.sl > Oracle sysliblist: -lrt -lpthread -l:libnss_dns.1 -lnsl > Found header files in /opt/oracle/product/10.2.0/client_1/rdbms/public. > Your LD_LIBRARY_PATH env var is set to > '/opt/oracle/product/10.2.0/client_1/lib' > WARNING: Your LD_LIBRARY_PATH env var doesn't include > '/opt/oracle/product/10.2.0/client_1/lib32' but probably needs to. > WARNING: If you have trouble, see README.hpux.txt... > you may have to build your own perl, or go hunting for libraries > > Checking for functioning wait.ph > > > System: perl5.008003 hp-ux bertha b.11.00 u 9000800 136901587 > unlimited-user license > Compiler: cc -fast +Onolimit +Opromote_indirect_calls +DAportable > +DS2.0 -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE > -Wl,+vnocompatwarnings -DNO_HASH_SEED -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64 > Linker: /usr/bin/ld > Sysliblist: -lrt -lpthread -l:libnss_dns.1 -lnsl > Linking with -lclntsh. > > Checking if your kit is complete... > Looks good > Note (probably harmless): No library found for -l:libnss_dns.1 > LD_RUN_PATH=/opt/oracle/product/10.2.0/client_1/lib32 > Using DBD::Oracle 1.24. > Using DBD::Oracle 1.24. > Using DBI 1.611 (for perl 5.008003 on PA-RISC1.1-thread-multi) installed > in /opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/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?) > > > Refer my perl version: > > # perl -V > Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration: > Platform: > osname=hpux, osvers=11.00, archname=PA-RISC1.1-thread-multi > uname='hp-ux bertha b.11.00 u 9000800 136901587 unlimited-user > license ' > config_args='-ders -Dcc=cc -Accflags=-DNO_HASH_SEED -Dusethreads > -Duseithreads -Ud_sigsetjmp -Uinstallusrbinperl -Ulocincpth= > -Uloclibpth= -Dd_attribut=undef -Dd_u32align=define > -Darchname=PA-RISC1.1 -Doptimize=-fast +Onolimit > +Opromote_indirect_calls +DAportable +DS2.0 -Duselargefiles > -Dinc_version_list=5.8.2/$archname 5.8.2 5.8.1/$archname 5.8.1 > 5.8.0/$archname 5.8.0 -Duseshrplib -Dprefix=/opt/perl > -Dcf_by=ActiveState -dcf_email=supp...@activestate.com' > <mailto:-dcf_email=supp...@activestate.com'> > 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=undef use64bitall=undef uselongdouble=undef > usemymalloc=n, bincompat5005=undef > Compiler: > cc='cc', ccflags =' -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae > -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64 ', > optimize='-fast +Onolimit +Opromote_indirect_calls +DAportable > +DS2.0', > cppflags='-Aa -D__STDC_EXT__ -D_HPUX_SOURCE > -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE > -Wl,+vnocompatwarnings -DNO_HASH_SEED' > ccversion='B.11.11.10', gccversion='', gccosandvers='' > intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 > ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', > lseeksize=8 > alignbytes=8, prototype=define > Linker and Libraries: > ld='/usr/bin/ld', ldflags ='' > libpth=/lib /usr/lib /usr/ccs/lib /usr/local/lib > libs=-lcres -lnsl -lnm -lndbm -lmalloc -ldld -lm -lcrypt -lsec > -lpthread -lc > perllibs=-lcres -lnsl -lnm -lmalloc -ldld -lm -lcrypt -lsec > -lpthread -lc > libc=/lib/libc.sl, so=sl, useshrplib=true, libperl=libperl.sl > gnulibc_version='' > Dynamic Linking: > dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E > -Wl,-B,deferred ' > cccdlflags='+Z', lddlflags='-b +vnocompatwarnings' > > > Characteristics of this binary (from libperl): > Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES > PERL_IMPLICIT_CONTEXT > Locally applied patches: > ActivePerl Build 809 > 22218 Remove the caveat about detached threads crashing on > Windows > 22201 Avoid threads+win32 crash by freeing Perl interpreter > slightly later > 22169 Display 'out of memeory' errors using low-level I/O > 22159 Upgrade to Time::Hires 1.55 > 22120 Make 'Configure -Dcf_by=...' work > 22051 Upgrade to Time::HiRes 1.54 > 21540 Fix backward-compatibility issues in if.pm > Built under hpux > Compiled at May 17 2005 18:12:56 > @INC: > /opt/perl/lib/5.8.3/PA-RISC1.1-thread-multi > /opt/perl/lib/5.8.3 > /opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi > /opt/perl/lib/site_perl/5.8.3 > /opt/perl/lib/site_perl > . > > > > Please help. > Thanks. > > YC. > > ________________________________ > > Win a $10,000 shopping spree from Hotmail! Enter now Enter now > <http://go.microsoft.com/?linkid=9729706> > > ________________________________ > > Your Photo on Bing.ca: You Could WIN on Canada Day! Submit a Photo Now! > <http://go.microsoft.com/?linkid=9734380> > -- Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. Hear Sheeri speak or email eve...@pythian.com to meet with Pythian.
