Thank you Peter. I also worked until 00:30 AM this early morning after reading all the materials from CPAN. They gave me the clues to find out what to fix the problem. It was one of our ORACLE_HOME env. variables pointing to the wrong place which caused query or db connect failed all the times. Without changing the previous installation, all db connection & testing are working fine now! Life is easy now! By the way, I did the same rebuild on another machine successfully a few weeks ago, and have followed all the procedures to rebuild this one. Although the threading is not a problem anymore, I will definitely take time to do more research to see whether the configuration needs to be adjusted and keep you posted in the next few weeks. I'd really appreciate your hint and caring to support me no matter when and where I or we are looking for help. It is so cool to be part of this community! George SBC
-----Original Message----- From: Peter J. Holzer [mailto:[EMAIL PROTECTED] Sent: Saturday, November 06, 2004 11:17 PM To: [EMAIL PROTECTED] Subject: Re: Urgent Help of HP/DBI/DBD/Oracle 9.2 On 2004-11-06 18:18:07 -0800, HSIA, GEORGE (SBCSI) wrote: > Urgent request or help from our dbi-user community: > > I have tried 7 different ways to reinstall DBI-1.43 and DBD-1.15 for > Perl 5.6.1 on the HPUX 11, Oracle 9.2.0, Apache Server, since 7 AM this > morning. They all failed with two types of DBI or DBD errors. There is a readme somewhere which explains how to build perl on HP-UX so that DBD::Oracle works. Have you followed this procedure? If you didn't build perl yourself, start by building a new version of perl, because then perl is probably not built the right way. > (Type II) > After running a Perl script to test the Database connection, I received: > > 11/06/04 18:32:49 Start Test_Perl.pl > install_driver(Oracle) failed: Can't load > '/Our_path/apache/perl/lib/site_perl/5.6.1/PA-RISC2.0-thread-multi/auto/ > DBD/ > Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at > /Our_path/apache/perl/lib/5.6.1/PA-RISC2.0-thre > ad-multi/DynaLoader.pm line 206. That sounds familiar. > *** You are using a perl configured with threading enabled. ^^^^^^^^^^^^^^^^^ I think this is the problem. IIRC, DBD::Oracle on HP-UX 11 doesn't work with threading enabled, but needs a perl linked with -lpthread. Here is a perl -V output of a perl 5.6.1 which works with Oracle 8.1.7: Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=hpux, osvers=11.00, archname=PA-RISC2.0 uname='hp-ux titan b.11.00 u 9000899 unknown ' config_args='' hint=previous, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='cc', ccflags ='-D_HPUX_SOURCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae', optimize='-O', cppflags='-D_HPUX_SOURCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae' ccversion='A.11.01.21505.GP', 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, usemymalloc=n, prototype=define Linker and Libraries: ld='ld', ldflags =' -Wl,+vnocompatwarnings' libpth=/lib /usr/lib /usr/ccs/lib libs=-lnsl -lnm -lndbm -lmalloc -ldld -lm -lndir -lcrypt -lsec -lcl -lpthread perllibs=-lnsl -lnm -lmalloc -ldld -lm -lndir -lcrypt -lsec -lcl -lpthread libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a 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: USE_LARGE_FILES Built under hpux Compiled at Aug 22 2001 08:10:04 @INC: /usr/local/lib/perl5/5.6.1/PA-RISC2.0 /usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/PA-RISC2.0 /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl . hp -- _ | Peter J. Holzer | If the code is old but the problem is new |_|_) | Sysadmin WSR / LUGA | then the code probably isn't the problem. | | | [EMAIL PROTECTED] | __/ | http://www.hjp.at/ | -- Tim Bunce on dbi-users, 2004-11-05
