Errors installing DBD on Red Hat 9 with Oracle 9.2

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

  • Next message: Janet Goldstein: "DBD::Oracle won't build on DEC Alpha" 
    Date: Tue, 16 Mar 2004 21:20:55 -0500
To: dbi-users@perl.org

    Hi,

    I've got some errors in the make test stage of installing DBD. The error I get is:

    t/select.t 35 5 14.29% 9-11 20 31
    1 test skipped.
    Failed 2/9 test scripts, 77.78% okay. 20/545 subtests failed, 96.33% okay.
    make: *** [test_dynamic] Error 29

    And here's details of my config including the tests:

    Here's what I get when I start oracle:

    sqlplus /nolog

    SQL*Plus: Release 9.2.0.1.0 - Production on Tue Mar 16 21:14:24 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL> connect / as sysdba
    Connected to an idle instance.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 89198852 bytes
    Fixed Size 450820 bytes
    Variable Size 71303168 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 667648 bytes
    Database mounted.
    Database opened.

    And here's the results of the test I ran after reading the README:

    [root@beast DBD-Oracle-1.15]# perl Makefile.PL -v
    Using DBI 1.32 installed in /usr/lib/perl5/vendor_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/vendor_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/vendor_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.32 installed in /usr/lib/perl5/vendor_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?)

    [root@beast DBD-Oracle-1.15]# make test
    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.......ok 102/372# failed test 103 at line 156. Strings differ at position 1 (\277 vs \23072), Len 20
    t/long.......ok 109/372# failed test 110 at line 177. 10240
    t/long.......ok 114/372# failed test 116 at line 198. 10240
    t/long.......ok 124/372# failed test 125 at line 241. Strings differ at position 1 (\277 vs \23072)
    t/long.......ok 145/372# failed test 146 at line 308.
    t/long.......NOK 146# failed test 147 at line 309.
    t/long.......NOK 147Use of uninitialized value in length at t/long.t line 311.
    # failed test 148 at line 311.
    t/long.......NOK 148Use of uninitialized value in substr at t/long.t line 315.
    # failed test 149 at line 315.
    t/long.......NOK 149# failed test 150 at line 319.
    t/long.......NOK 150# failed test 151 at line 320.
    t/long.......NOK 151# failed test 152 at line 324.
    t/long.......NOK 152# failed test 153 at line 328.
    t/long.......ok 195/372# failed test 196 at line 156. Strings differ at position 1 (\277 vs \23072), Len 20
    t/long.......ok 202/372# failed test 203 at line 177. 10240
    t/long.......ok 207/372# failed test 209 at line 198. 10240
    t/long.......ok 315/372
    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.
    t/long.......ok 316/372(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.

    t/long.......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.....ok 8/35Use 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: Janet Goldstein: "DBD::Oracle won't build on DEC Alpha"

    Relevant Pages