RE: Make Test Failed For DBD-Oracle 1.24

[email protected] ("Yeow Yiew Choong-PBKN64")
Newsgroups perl.dbi.users
Message-ID <[email protected]> 
Hi John,
 
I use both 32bit & 64bit instant client of Oracle, still failed at make
test.
Thanks.
 
regards,
YC

________________________________

From: John Scoles [mailto:[email protected]] 
Sent: Thursday, June 03, 2010 7:12 PM
To: Yeow Yiew Choong-PBKN64; [email protected]
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: [email protected]
To: [email protected]; [email protected]


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:[email protected]] 
Sent: Wednesday, June 02, 2010 8:41 PM
To: Yeow Yiew Choong-PBKN64; [email protected]
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
 
cheers
John
 

________________________________

Subject: Make Test Failed For DBD-Oracle 1.24
Date: Tue, 1 Jun 2010 19:04:44 +0800
From: [email protected]
To: [email protected]


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 [email protected]'
<mailto:[email protected]'> 
    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>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.