test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2

From: Dan Straw (dans_at_sportingbet.com)
Date: 03/17/04

Next message: Kenneth ***: "RE: DBIx::Chart and Zero values"

Previous message: Tim Bunce: "Re: ANNOUNCE: DBI 1.42"
Next in thread: Andy Hassall: "RE: test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2"
Reply: Andy Hassall: "RE: test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Tue, 16 Mar 2004 23:07:25 -0500
To: dbi-users@perl.org

Hi,

I'm having some trouble installing DBD-Oracle. I get the following error when running make test:

[snip]
# failed test 31 at line 95. Strings differ at position 1 (\277 vs \23072), Len 5
FAILED tests 9-11, 20, 31
Failed 5/35 tests, 85.71% okay
Failed 2/9 test scripts, 77.78% okay. 20/545 subtests failed, 96.33% okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/long.t 372 15 4.03% 103 110 116 125 146-153 196 203 209
t/select.t 35 5 14.29% 9-11 20 31
1 test skipped.
make: *** [test_dynamic] Error 29

Here's my sys info:

Red hat 9
kernel version: 2.4.20-6smp
DBI version: 1.42
DBD version 1.15
Oracle version 9.2.

1. here's a log of the build:

Using DBI 1.42 (for perl 5.008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI

Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!
Especially if you have any problems.

Using Oracle in /dbmnt/u01/app/oracle/product/9.2.0.1.0
Oracle version 9.2.0.0.0 (9.200)

Found /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo/demo_rdbms.mk
Found /dbmnt/u01/app/oracle/product/9.2.0.1.0/otrace/demo/atmoci.mk
Found /dbmnt/u01/app/oracle/product/9.2.0.1.0/precomp/demo/proc/demo_proc.mk
Using /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo/demo_rdbms.mk
Reading /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo/demo_rdbms.mk
Reading /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/env_rdbms.mk
Read a total of 2202 lines from /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/env_rdbms.mk (including inclusions)
Read a total of 2493 lines from /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo/demo_rdbms.mk (including inclusions)
Deleted SHELL definition: SHELL=/bin/sh
Deleted LIB_EXT definition: LIB_EXT=a
Deleted OBJ_EXT definition: OBJ_EXT=o
Deleted AR definition: AR=ar
Deleted AS definition: AS=as
Deleted CC definition: CC=cc
Deleted CHMOD definition: CHMOD=chmod
Deleted CPP definition: CPP=cpp
Deleted ECHO definition: ECHO=echo
Deleted LD definition: LD=ld
Deleted PERL definition: PERL=perl
Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
        $(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) $(LDPATHFLAG)$(LIBHOME)stubs/
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE3)
Deleted AR definition: AR=/usr/bin/ar
Deleted AS definition: AS=/usr/bin/as
Deleted LD definition: LD=/usr/bin/ld
Deleted CPP definition: CPP=/lib/cpp
Deleted CHMOD definition: CHMOD=/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=
Appending '/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/libskgxpd.a /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/libskgxpu.a /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/libskgxpt.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxp9.so' to SHLIBS
Appending '/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/libskgxp9.a' to LIBS
Appending '/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/libskgxns.a /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/libskgxnd.a /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/libskgxnr.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxn9.so' to SHLIBS
Appending '/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/libskgxn9.a' to LIBS
Evaluating `cat $(LIBHOME)sysliblist`
  expanded `cat /dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/sysliblist`
  returned '-ldl -lm -lpthread -lnsl '

Attempting to discover Oracle OCI build rules
gcc -c -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/plsql/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/network/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -g -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DUTF8_SUPPORT DBD_ORA_OBJ.c
by executing: [make -f /dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
returned:
[echo -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/sysliblist` -ldl -lm ]
[-L/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -ldl -lm -lpthread -lnsl -ldl -lm]
reduced to:
[-L/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -ldl -lm -lpthread -lnsl -ldl -lm]
Oracle oci build command:
[-L/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -ldl -lm -lpthread -lnsl -ldl -lm]

Found header files in rdbms/public rdbms/demo.

Checking for functioning wait.ph

System: perl5.008 linux stripples.devel.redhat.com 2.4.20-2.48smp #1 smp thu feb 13 11:44:55 est 2003 i686 i686 i386 gnulinux
Compiler: gcc -O2 -march=i386 -mcpu=i686 -g -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
Linker: /usr/bin/ld
Sysliblist: -ldl -lm -lpthread -lnsl
Oracle makefiles would have used these definitions but we override them:
CC: cc

  CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
        $(SHARED_CFLAG) $(USRFLAGS)
           [$(GFLAG) -O3 $(CDEBUG) $(CCFLAGS) -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/plsql/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/network/public -DLINUX -D_GNU_SOURCE -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS $(LPFLAGS) $(USRFLAGS)]

LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) $(LDPATHFLAG)$(LIBHOME)stubs/
[-o $@ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/ -L$(LIBHOME) -L$(LIBHOME)stubs/]

Linking with OTHERLDFLAGS = -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/ -lclntsh -ldl -lm -lpthread -lnsl -ldl -lm [from 'build' rule]

MakeMaker (v6.03)
  ABSTRACT_FROM => q[Oracle.pm]
  AUTHOR => q[Tim Bunce (dbi-users@perl.org)]
  DEFINE => q[ -DUTF8_SUPPORT]
  DIR => []
  EXE_FILES => [q[ora_explain]]
  INC => q[-I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/plsql/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/network/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI]
  NAME => q[DBD::Oracle]
  OBJECT => q[$(O_FILES)]
  PREREQ_PM => { DBI=>q[0] }
  VERSION_FROM => q[Oracle.pm]
  clean => { FILES=>q[Oracle.xsi dll.base dll.exp sqlnet.log libOracle.def ora_explain mk.pm] }
  dist => { DIST_DEFAULT=>q[clean distcheck disttest ci tardist], COMPRESS=>q[gzip -v9], PREOP=>q[$(MAKE) -f Makefile.old distdir], SUFFIX=>q[gz] }
  dynamic_lib => { OTHERLDFLAGS=>q[ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/ -lclntsh -ldl -lm -lpthread -lnsl -ldl -lm] }
Using PERL=/usr/bin/perl
LD_RUN_PATH=/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib:/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib
Using DBD::Oracle 1.15.
Using DBD::Oracle 1.15.
Using DBI 1.42 (for perl 5.008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.0/i386-linux-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 files.
(Of course, you have read README by now anyway, haven't you?)

Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/plsql/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/network/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -g -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DUTF8_SUPPORT Oracle.c
gcc -c -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/plsql/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/network/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -g -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DUTF8_SUPPORT dbdimp.c
gcc -c -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/plsql/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/network/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -g -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DUTF8_SUPPORT oci7.c
gcc -c -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/plsql/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/network/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/public -I/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -g -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DUTF8_SUPPORT oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib:/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib" gcc -shared -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/lib/ -L/dbmnt/u01/app/oracle/product/9.2.0.1.0/rdbms/lib/ -lclntsh -ldl -lm -lpthread -lnsl -ldl -lm -o blib/arch/auto/DBD/Oracle/Oracle.so
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/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3pm
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base.......ok
t/cursor.....ok
t/general....ok
t/long.......# failed test 103 at line 156. Strings differ at position 1 (\277 vs \23072), Len 20
# failed test 110 at line 177. 10240
# failed test 116 at line 198. 10240
# failed test 125 at line 241. Strings differ at position 1 (\277 vs \23072)
# failed test 146 at line 308.
# failed test 147 at line 309.
Use of uninitialized value in length at t/long.t line 311.
# failed test 148 at line 311.
Use of uninitialized value in substr at t/long.t line 315.
# failed test 149 at line 315.
# failed test 150 at line 319.
# failed test 151 at line 320.
# failed test 152 at line 324.
# failed test 153 at line 328.
# failed test 196 at line 156. Strings differ at position 1 (\277 vs \23072), Len 20
# failed test 203 at line 177. 10240
# failed test 209 at line 198. 10240

Some tests for LONG data type handling failed. These are generally Oracle bugs.
Please report this to the dbi-users mailing list, and include the
Oracle version number of both the client and the server.
Please also include the output of the 'perl -V' command.
(If you can, please study t/long.t to investigate the cause.
Feel free to edit the tests to see what's happening in more detail.
Especially by adding trace() calls around the failing tests.
Run the tests manually using the command "perl -Mblib t/long.t")
Meanwhile, if the other tests have passed you can use DBD::Oracle.

FAILED tests 103, 110, 116, 125, 146-153, 196, 203, 209
Failed 15/372 tests, 95.97% okay
t/meta.......ok
t/ph_type....ok
t/plsql......ok
t/reauth.....skipped
all skipped: no reason given
t/select.....Use of uninitialized value in pattern match (m//) at t/select.t line 95.
Use of uninitialized value in length at t/select.t line 95.
Use of uninitialized value in length at t/select.t line 144.
Use of uninitialized value in string eq at t/select.t line 145.
Use of uninitialized value in concatenation (.) or string at t/select.t line 146.
# failed test 9 at line 95. Strings are of different lengths (0 vs 5)( vs 0

Next message: Kenneth ***: "RE: DBIx::Chart and Zero values"

Previous message: Tim Bunce: "Re: ANNOUNCE: DBI 1.42"
Next in thread: Andy Hassall: "RE: test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2"
Reply: Andy Hassall: "RE: test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]