RE: Make Test Failed For DBD-Oracle 1.24
Hi John, Any help? I want to try installing another perl version and setup the DBI, DBD. Currently, I have my perl 5.8.3 and I have many perl modules already installed and being used, please refer the list below: Installed modules are: ActivePerl::DocTools ActiveState::RelocateTree Archive::Tar Archive::Zip CGI::Session Compress::Zlib Convert::ASN1 Crypt::SSLeay Cwd DBI Data::Dump Digest::HMAC Digest::MD2 Digest::MD4 Digest::SHA1 ExtUtils::MakeMaker File::CounterFile File::Path Font::AFM HTML-Tree HTML::Parser HTML::Tagset IO::Zlib List::Util MD5 Net Net::Daemon Net::SSLeay PDF::API2 PPM3 Perl RPC::PlServer SOAP::Lite Storable Term::ReadKey Term::ReadLine Test::Harness Test::Simple Text::Autoformat Text::Reform Tk Tk::StyledButton URI Unicode::String XML-DOM XML::Parser XML::RegExp XML::Simple XML::XPath XML::XSLT libwww-perl libxml-perl perl-ldap How can I transfer/move those installed modules to new perl version? Do I need to install again all those modules? Do you have any guide on this? Thanks. regards, Yeow From: Yeow Yiew Choong-PBKN64 Sent: Saturday, June 05, 2010 6:00 PM To: 'John Scoles' Cc: John Scoles; dbi-users@perl.org Subject: RE: Make Test Failed For DBD-Oracle 1.24 Hi John, Please refer the output error below: # perl Makefile.PL -lcl 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/ Unknown option: lcl Invalid arguments at Makefile.PL line 101. Thanks. regards, YC From: John Scoles [mailto:sco...@pythian.com] Sent: Friday, June 04, 2010 8:05 PM To: Yeow Yiew Choong-PBKN64 Cc: John Scoles; dbi-users@perl.org Subject: Re: Make Test Failed For DBD-Oracle 1.24 give perl Makefile.PL -lcl a try and make again
RE: Make Test Failed For DBD-Oracle 1.24
Hi John, Please refer the output error below: # perl Makefile.PL -lcl 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/ Unknown option: lcl Invalid arguments at Makefile.PL line 101. Thanks. regards, YC From: John Scoles [mailto:sco...@pythian.com] Sent: Friday, June 04, 2010 8:05 PM To: Yeow Yiew Choong-PBKN64 Cc: John Scoles; dbi-users@perl.org Subject: Re: Make Test Failed For DBD-Oracle 1.24 give perl Makefile.PL -lcl a try and make again
RE: Make Test Failed For DBD-Oracle 1.24
Hi John, I have set the ORACLE_HOME LD_LIBRARY_PATH to point to the directory of 32bit Oracle client. Is that what you mean? However, still failed at make test. The output of perl Makefile.PL, make and make test listed below: # perl Makefile.PL 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/instantclient_10_2 DEFINE _SQLPLUS_RELEASE = 1002000400 (CHAR) Oracle version 10.2.0.4 (10.2) Looks like an Instant Client installation, okay Your LD_LIBRARY_PATH/SHLIB_PATH env var is set to '/opt/instantclient_10_2:/opt/instantclient_10_2' Oracle sysliblist: Found header files in /opt/instantclient_10_2/sdk/include. WARNING: If you have trouble, see README.hpux.txt... you may have to build your own perl, or go hunting for libraries WARNING: If you have trouble, try perl Makefile.PL -l 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: Linking with -lclntsh. Checking if your kit is complete... Looks good LD_RUN_PATH=/opt/instantclient_10_2 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?) # make cp Oracle.pm blib/lib/DBD/Oracle.pm cp oraperl.ph blib/lib/oraperl.ph cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h cp Oraperl.pm blib/lib/Oraperl.pm cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm /usr/bin/perl -p -e s/~DRIVER~/Oracle/g /opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI/Driver.xs t Oracle.xsi /usr/bin/perl /opt/perl/lib/5.8.3/ExtUtils/xsubpp -typemap /opt/perl/lib/5.8.3/ExtUtils/typemap -typemap typemap Oracle.xs Oracle.xsc mv Oracle.xsc Oracle.c cc -c -I/opt/instantclient_10_2/sdk/include -I/opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0-DVERSION=\1.24\ -DXS_VERSION=\1.24\ +Z -I/opt/perl/lib/5.8.3/PA-RISC1.1-thread-multi/CORE -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\10.2.0.4\ Oracle.c field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0 cc -c -I/opt/instantclient_10_2/sdk/include -I/opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0-DVERSION=\1.24\ -DXS_VERSION=\1.24\ +Z -I/opt/perl/lib/5.8.3/PA-RISC1.1-thread-multi/CORE -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\10.2.0.4\ dbdimp.c field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0 cc -c -I/opt/instantclient_10_2/sdk/include -I/opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0-DVERSION=\1.24\ -DXS_VERSION=\1.24\ +Z -I/opt/perl/lib/5.8.3/PA-RISC1.1-thread-multi/CORE -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\10.2.0.4\ oci8.c field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0field found :0x0 Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs rm -f blib/arch/auto/DBD/Oracle/Oracle.sl LD_RUN_PATH=/opt/instantclient_10_2 /usr/bin/ld -b
RE: Make Test Failed For DBD-Oracle 1.24
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+28353475threadId=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
RE: Make Test Failed For DBD-Oracle 1.24
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+28353475threadId=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
Re: Make Test Failed For DBD-Oracle 1.24
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+28353475threadId=1078200http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=10944%0A7626+1272030523151+28353475threadId=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
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=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+28353475threadId=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
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+28353475threadId=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,