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=1095121 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=109447626+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' 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 _________________________________________________________________ Turn down-time into play-time with Messenger games http://go.microsoft.com/?linkid=9734385