I am having difficulties testing DBD. I've searched the web and the various
DBI/DBD lists, but can't find a solution.
First, the environment:
OS: Compaq Tru64 5.1
Oracle: 8.1.6 (Enterprise Server)
Perl: 5.6.0
DBI: 1.15
DBD: 1.06
All appears to work fine until I run the tests. Is there a simple fix for
this?
I tried:
perl Makefile.PL -b
perl Makefile.PL -c
perl Makefile.PL -l
perl Makefile.PL -n LIBCLNTSH
perl Makefile.PL -p
Any help would be appreciated!
Joe.
======================================
The specific error is listed below:
--------------------------------------
pm02rg:/var/kits/perl-dbd/DBD-Oracle-1.06 # make test
PERL_DL_NONLAZY=1
/usr/local/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.0/alph
a-dec_osf -I/usr/local/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base..............ok
t/general...........ok
t/long..............ok
t/plsql.............dubious
Test returned status 0 (wstat 139, 0x8b)
test program seems to have generated a core
DIED. FAILED tests 55-63
Failed 9/63 tests, 85.71% okay
t/reauth............skipped test on this platform
Failed Test Status Wstat Total Fail Failed List of failed
----------------------------------------------------------------------------
---
t/plsql.t 0 139 63 9 14.29% 55-63
1 test skipped.
Failed 1/5 test scripts, 80.00% okay. 9/224 subtests failed, 95.98% okay.
make: *** [test_dynamic] Error 2
Other info that may be of use:
======================================
Environment
--------------------------------------
DISPLAY=pm02rg.xxxxxx.cw.net:10.0
HOME=/
LD_LIBRARY_PATH=/ora01/app/oracle/product/8.1.6/lib
LOGNAME=root
MAIL=/var/spool/mail/root
ORACLE_BASE=/ora01/app/oracle/
ORACLE_HOME=/ora01/app/oracle/product/8.1.6
ORACLE_SID=smart
PATH=/sbin:/usr/sbin:/usr/ccs/bin:/usr/bin:/usr/bin/X11:/usr/local:/ora01/ap
p/oracle/product/8.1.6/bin:/ora01/app/oracle/webdb/bin:/usr/bin:/etc:/usr/cc
s/bin:/usr/bin/X11:/usr/local/bin://bin:.
SHELL=/bin/sh
TERM=vt100
TNS_ADMIN=/ora01/app/oracle/product/8.1.6/network/admin
USER=root
WEBDB_HOME=/ora01/app/oracle/webdb
======================================
perl -V output
--------------------------------------
pm02rg:/var/kits/perl-dbd/DBD-Oracle-1.06 # perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:
Platform:
osname=dec_osf, osvers=5.1, archname=alpha-dec_osf
uname='osf1 pm02rg.xxxxxx.cw.net v5.1 732 alpha '
config_args='-de'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define
use64bitint=define use64bitall=define uselongdouble=undef usesocks=undef
Compiler:
cc='cc', optimize='-O4', gccversion=
cppflags='-std -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C'
ccflags ='-std -fprm
d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C'
stdchar='unsigned char', d_stdstdio=define, usevfork=false
intsize=4, longsize=8, ptrsize=8, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, 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 /usr/shlib /usr/ccs/lib /usr/lib/cmplrs/cc
/usr/lib /var/shlib
libs=-ldbm -ldb -lm -liconv
libc=/usr/shlib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef,
cdlflags=' -Wl,-rpath,/usr/local/lib/perl5/5.6.0/alpha-dec_osf/CORE'
cccdlflags=' ', lddlflags='-shared -expect_unresolved
"*" -O4 -msym -std -s -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES
Built under dec_osf
Compiled at Mar 18 2001 02:02:27
@INC:
/usr/local/lib/perl5/5.6.0/alpha-dec_osf
/usr/local/lib/perl5/5.6.0
/usr/local/lib/perl5/site_perl/5.6.0/alpha-dec_osf
/usr/local/lib/perl5/site_perl/5.6.0
/usr/local/lib/perl5/site_perl
.
======================================
perl Makefile.PL output
--------------------------------------
pm02rg:/var/kits/perl-dbd/DBD-Oracle-1.06 # perl Makefile.PL
Using DBI 1.15 installed in
/usr/local/lib/perl5/site_perl/5.6.0/alpha-dec_osf/auto/DBI
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /ora01/app/oracle/product/8.1.6
Found /ora01/app/oracle/product/8.1.6/rdbms/demo/demo_rdbms.mk
Found /ora01/app/oracle/product/8.1.6/otrace/demo/atmoci.mk
Using /ora01/app/oracle/product/8.1.6/rdbms/demo/demo_rdbms.mk
Reading /ora01/app/oracle/product/8.1.6/rdbms/demo/demo_rdbms.mk.
Reading /ora01/app/oracle/product/8.1.6/rdbms/lib/env_rdbms.mk.
Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/
because it is not already set in the environment
and it can cause ORA-01019 errors.
Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/
because it is not already set in the environment
and it can cause ORA-01019 errors.
Discovering Oracle OCI build rules...
Oracle oci build command:
true
cc -L/ora01/app/oracle/product/8.1.6/lib/ -L/ora01/app/oracle/product/8.1.6/
rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh
Found header files in rdbms/demo.
System: perl5.006 osf1 pm02rg.xxxxxx.cw.net v5.1 732 alpha
Compiler: cc -O4 -std -fprm
d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C
Linker: /usr/bin/ld
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS)
$(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -O4 -fast -fp_reorder -U_FASTMATH -O4 -fast -fp_reorder -U_FASTMAT
H
$(GEMC_FLAGS) -std1 -DOSF1 -DA_OSF -Wf,-readonly_strings -ieee -noansi_alias
-D_INTRINSICS
$(QACCFLAGS) -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/ora01/app/oracl
e/product/8.1.6/rdbms/public -I/ora01/app/oracle/product/8.1.6/plsql/public
-I/ora01/app/oracle/product/8.1.6/network/public $(LPFLAGS) $(SHARED_CFLAG)
$(USRFLAGS)]
LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
[-L$(LIBHOME) -L/ora01/app/oracle/product/8.1.6/rdbms/lib]
Linking with OTHERLDFLAGS
= -L/ora01/app/oracle/product/8.1.6/lib/ -L/ora01/app/oracle/product/8.1.6/r
dbms/lib -lclntsh [from 'build' rule]
Warning: By default new modules are installed into your 'site_lib'
directories. Since site_lib directories come after the normal library
directories you must delete any old DBD::Oracle files and directories from
your 'privlib' and 'archlib' directories and their auto subdirectories.
Using DBD::Oracle 1.06.
Using DBI 1.15 installed in
/usr/local/lib/perl5/site_perl/5.6.0/alpha-dec_osf/auto/DBI
Writing Makefile for DBD::Oracle
*** If you have problems, read the README and README.help files ***
(Of course, you have read README by now anyway, haven't you?)
======================================
make output
--------------------------------------
pm02rg:/var/kits/perl-dbd/DBD-Oracle-1.06 # make
cc -c -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/ora01/app/oracle/produ
ct/8.1.6/rdbms/public -I/ora01/app/oracle/product/8.1.6/plsql/public -I/ora0
1/app/oracle/product/8.1.6/network/public -I/ora01/app/oracle/product/8.1.6/
rdbms/demo -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/usr/local/lib/per
l5/site_perl/5.6.0/alpha-dec_osf/auto/DBI -std -fprm
d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C -O4 -DVERSION=\"
1.06\" -DXS_VERSION=\"1.06\" -I/usr/local/lib/perl5/5.6.0/alpha-dec_osf/COR
E Oracle.c
cc -c -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/ora01/app/oracle/produ
ct/8.1.6/rdbms/public -I/ora01/app/oracle/product/8.1.6/plsql/public -I/ora0
1/app/oracle/product/8.1.6/network/public -I/ora01/app/oracle/product/8.1.6/
rdbms/demo -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/usr/local/lib/per
l5/site_perl/5.6.0/alpha-dec_osf/auto/DBI -std -fprm
d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C -O4 -DVERSION=\"
1.06\" -DXS_VERSION=\"1.06\" -I/usr/local/lib/perl5/5.6.0/alpha-dec_osf/COR
E dbdimp.c
cc -c -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/ora01/app/oracle/produ
ct/8.1.6/rdbms/public -I/ora01/app/oracle/product/8.1.6/plsql/public -I/ora0
1/app/oracle/product/8.1.6/network/public -I/ora01/app/oracle/product/8.1.6/
rdbms/demo -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/usr/local/lib/per
l5/site_perl/5.6.0/alpha-dec_osf/auto/DBI -std -fprm
d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C -O4 -DVERSION=\"
1.06\" -DXS_VERSION=\"1.06\" -I/usr/local/lib/perl5/5.6.0/alpha-dec_osf/COR
E oci7.c
cc -c -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/ora01/app/oracle/produ
ct/8.1.6/rdbms/public -I/ora01/app/oracle/product/8.1.6/plsql/public -I/ora0
1/app/oracle/product/8.1.6/network/public -I/ora01/app/oracle/product/8.1.6/
rdbms/demo -I/ora01/app/oracle/product/8.1.6/rdbms/demo -I/usr/local/lib/per
l5/site_perl/5.6.0/alpha-dec_osf/auto/DBI -std -fprm
d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C -O4 -DVERSION=\"
1.06\" -DXS_VERSION=\"1.06\" -I/usr/local/lib/perl5/5.6.0/alpha-dec_osf/COR
E oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
ar cr tmp.a Oracle.o dbdimp.o oci7.o oci8.o
: tmp.a
LD_RUN_PATH="" ld -o
blib/arch/auto/DBD/Oracle/Oracle.so -shared -expect_unresolved
"*" -O4 -msym -std -s -L/usr/local/lib -all
tmp.a -none -L/ora01/app/oracle/product/8.1.6/lib/ -L/ora01/app/oracle/produ
ct/8.1.6/rdbms/lib -lclntsh
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
cp ora_explain blib/script/ora_explain
/usr/local/bin/perl -I/usr/local/lib/perl5/5.6.0/alpha-dec_osf -I/usr/local/
lib/perl5/5.6.0 -MExtUtils::MakeMaker -e "MY->fixin(shift)"
blib/script/ora_explain
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3
======================================
