Problem with DBD::Oracle on HP-UX: bus error

[Markus Trenkle]

Hi,

I try to compile DBD::Oracle on HP-UX 11.00. I think I resolved the library issues sucessfully, the packeges compile without errors. However, in the last step, 'make test' on DBD::Oracle fails and if I try to connect to the DB, I get a 'bus error' and a core dump. I hope someone can give me some help. This is quite annoying I got this to run in Solaris in half an hour.

Details:
A180c
HP-UX 11.00, latest Quality Pack
HP ansic compiler
Oracle 8.0.4

I tried recent versions as well as the ones used in the example in README.hpux:

perl-5.6.1, DBI-1.14, DBD-Oracle-1.07
perl-5.8.0, DBI-1.30, DBD-Oracle-1.12

Of course I am able to connect to the DB with sqlplus.

Thank you very much,

Markus




Output of perl -V:

Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=hpux, osvers=11.00, archname=PA-RISC1.1
uname='hp-ux sorry-hp b.11.00 a 9000800 2002266160 two-user license '
config_args='-Ubincompat5005'
hint=recommended, 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 =' +z -D_HPUX_SOURCE -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae',
optimize='-O',
cppflags='+z -D_HPUX_SOURCE -Aa -I/usr/local/include'
ccversion='B.11.11.02', 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=y, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lcl -lpthread -lnsl -lnm -lndbm -ldld -lm -lc -lndir -lcrypt -lsec
perllibs=-lcl -lpthread -lnsl -lnm -ldld -lm -lc -lndir -lcrypt -lsec
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 -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under hpux
Compiled at Oct 29 2002 19:08:49
@INC:
/usr/local/perl5/lib/5.6.1/PA-RISC1.1
/usr/local/perl5/lib/5.6.1
/usr/local/perl5/lib/site_perl/5.6.1/PA-RISC1.1
/usr/local/perl5/lib/site_perl/5.6.1
/usr/local/perl5/lib/site_perl
.


Output from DBD-Oracle-1.07/make test:

PERL_DL_NONLAZY=1 /usr/local/perl5/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/perl5/lib/5.6.1/PA-RISC1.1 -I/usr/local/perl5/lib/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base..............ok
t/general...........DBI->connect() failed: (UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS settings etc. at t/general.t line 20
Unable to connect to Oracle ((UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS settings etc.)
Tests skiped.
skipped test on this platform
t/long..............Unable to connect to Oracle ((UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS settings etc.)
Tests skiped.
skipped test on this platform
t/plsql.............Unable to connect to Oracle ((UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS settings etc.)
Tests skiped.
skipped test on this platform
t/reauth............skipped test on this platform
All tests successful, 4 tests skipped.
Files=5, Tests=5, 3 wallclock secs ( 2.59 cusr + 0.30 csys = 2.89 CPU)
PERL_DL_NONLAZY=1 /usr/local/perl5/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/perl5/lib/5.6.1/PA-RISC1.1 -I/usr/local/perl5/lib/5.6.1 test.pl
Oraperl test application $Revision: 1.2 $

Oraperl emulation interface version 1.40
DBD::Oracle 1.07 using OCI8 by Tim Bunce
DBI 1.14 by Tim Bunce

Data sources:
dbi:Oracle:dev
dbi:Oracle:extproc_connection_data
dbi:Oracle:henkt.sorry.de
dbi:Oracle:mt.intern


Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as '[EMAIL PROTECTED]' (via ORACLE_USERID env var or default - recommend name/passwd@dbname)
(ORACLE_SID='', TWO_TASK='')
ora_login: 24322: (UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS settings etc.

Generally set TWO_TASK or ORACLE_SID but not both at the same time.
Try to connect to the database using an oracle tool like sqlplus
only if that works should you suspect problems with DBD::Oracle.
Try leaving dbname value empty and set dbuser to name/passwd@dbname.

Test aborted.
*** Error exit code 255

Stop.