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
pgplPxhq8PsnK.pgp
Description: PGP signature
