DBD::Oracle Installation Problems

From: Mario Cova (mario-a-cova_at_ptinovacao.pt)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 13:07:38 -0000
To: <dbi-users@perl.org>

I get an error when i try to install DBD::Oracle... Please, I need you help.
 
 
[root@recover DBD-Oracle-1.16]# perl Makefile.PL -v
Using DBI 1.46 installed in /usr/lib/perl5/site_perl/5.8.0/ia64-linux-thread-multi/auto/DBI
 
 Configuring DBD::Oracle ...
 
>>> Remember to actually *READ* the README file!
        Especially if you have any problems.
 
Using Oracle in /opt/oracle/product/10.1.0
DEFINE _SQLPLUS_RELEASE = "1001000200" (CHAR)
Oracle version 10.1.0.2 (10.1)
Found /opt/oracle/product/10.1.0/rdbms/demo/demo_rdbms.mk
Using /opt/oracle/product/10.1.0/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/product/10.1.0/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/product/10.1.0/rdbms/lib/env_rdbms.mk
Read a total of 2566 lines from /opt/oracle/product/10.1.0/rdbms/lib/env_rdbms.mk (including inclusions)
Read a total of 2867 lines from /opt/oracle/product/10.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=$(OPTIMIZE1)
Deleted AR definition: AR=/usr/bin/ar
Deleted AS definition: AS=/usr/bin/as
Deleted LD definition: LD=$(GCC)
Deleted CPP definition: CPP=/lib/cpp
Deleted CHMOD definition: CHMOD=/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=
Deleted CCFLAGS definition: CCFLAGS= $(NOKPIC_CCFLAGS) $(KPIC_OPTION)
Appending '/opt/oracle/product/10.1.0/rdbms/lib/libskgxpd.a /opt/oracle/product/10.1.0/rdbms/lib/libskgxpu.a /opt/oracle/product/10.1.0/rdbms/lib/libskgxpt.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxp10.so' to SHLIBS
Appending '/opt/oracle/product/10.1.0/rdbms/lib/libskgxp10.a' to LIBS
Appending '/opt/oracle/product/10.1.0/rdbms/lib/libskgxns.a /opt/oracle/product/10.1.0/rdbms/lib/libskgxnd.a /opt/oracle/product/10.1.0/rdbms/lib/libskgxnr.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxn2.so' to SHLIBS
Appending '/opt/oracle/product/10.1.0/rdbms/lib/libskgxn2.a' to LIBS
Evaluating `cat $(LIBHOME)sysliblist | sed "s%-lm%%"`
  expanded `cat /opt/oracle/product/10.1.0/lib/sysliblist | sed "s%-lm%%"`
  returned '-ldl -lpthread -lnsl -lirc '
 
Attempting to discover Oracle OCI build rules
gcc -c -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 -g -pipe -DVERSION=\"\" -DXS_VERSION=\"\" -fPIC "-I/usr/lib/perl5/5.8.0/ia64-linux-thread-multi/CORE" DBD_ORA_OBJ.c
by executing: [make -f /opt/oracle/product/10.1.0/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
returned:
[true -L/opt/oracle/product/10.1.0/lib/ -L/opt/oracle/product/10.1.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /opt/oracle/product/10.1.0/lib/sysliblist | sed "s%-lm%%"` -ldl /opt/oracle/product/10.1.0/lib/libimf.a -lm ]
reduced to:
[true -L/opt/oracle/product/10.1.0/lib/ -L/opt/oracle/product/10.1.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /opt/oracle/product/10.1.0/lib/sysliblist | sed "s%-lm%%"` -ldl /opt/oracle/product/10.1.0/lib/libimf.a -lm ]
Oracle oci build command:
        [true -L/opt/oracle/product/10.1.0/lib/ -L/opt/oracle/product/10.1.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /opt/oracle/product/10.1.0/lib/sysliblist | sed "s%-lm%%"` -ldl /opt/oracle/product/10.1.0/lib/libimf.a -lm ]
 
Found header files in plsql/public rdbms/public.
 
Checking for functioning wait.ph
 

System: perl5.008 linux rocky.devel.redhat.com 2.4.21-1.1931.2.411.ent #1 smp mon aug 25 14:33:47 edt 2003 ia64 ia64 ia64 gnulinux
Compiler: gcc -O2 -g -pipe -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 -lirc
Oracle makefiles would have used these definitions but we override them:
  CC: cc
 
  CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
        $(SHARED_CFLAG) $(USRFLAGS)
           [$(GFLAG) -O1 $(CDEBUG) $(TRIGRAPHS_CCFLAGS) -fPIC -I/opt/oracle/product/10.1.0/rdbms/demo -I/opt/oracle/product/10.1.0/rdbms/public -I/opt/oracle/product/10.1.0/plsql/public -I/opt/oracle/product/10.1.0/network/public -DLINUX -D_GNU_SOURCE -DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -DORAIA64 -DLINUX_GEN -DLINUX_IA64 $(LPFLAGS) $(USRFLAGS)]
 
  LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) $(LDPATHFLAG)$(LIBHOME)stubs/
           [-o $@ -L/opt/oracle/product/10.1.0/rdbms/lib/ -L$(LIBHOME) -L$(LIBHOME)stubs/]
 

Linking with OTHERLDFLAGS = -L/opt/oracle/product/10.1.0/lib/ -L/opt/oracle/product/10.1.0/rdbms/lib/ -lclntsh `cat /opt/oracle/product/10.1.0/lib/sysliblist | sed "s%-lm%%"` -ldl /opt/oracle/product/10.1.0/lib/libimf.a -lm [from 'build' rule]
 

Reference found where even-sized list expected at /usr/lib/perl5/5.8.0/ia64-linux-thread-multi/DBI/DBD.pm line 1781.
WARNING: HASH(0x6000000000699310) is not a known parameter.
MakeMaker (v6.03)
  HASH(0x6000000000699310) => undef
'HASH(0x6000000000699310)' is not a known MakeMaker parameter name.
  PREREQ_PM => { }
Warning: Guessing NAME [DBD-Oracle] from current directory name.
Using PERL=/usr/bin/perl
LD_RUN_PATH=/opt/oracle/product/10.1.0/lib:/opt/oracle/product/10.1.0/rdbms/lib
Using DBD::Oracle .
Using DBD::Oracle .
Using DBI 1.46 installed in /usr/lib/perl5/site_perl/5.8.0/ia64-linux-thread-multi/auto/DBI
Writing Makefile for DBD-Oracle
 
 
 
[root@recover DBD-Oracle-1.16]# make
Skip blib/lib/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)
cp mk.pm blib/arch/auto/DBD-Oracle/mk.pm
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -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 -g -pipe -DVERSION=\"\" -DXS_VERSION=\"\" -fPIC "-I/usr/lib/perl5/5.8.0/ia64-linux-thread-multi/CORE" Oracle.c
Oracle.xs: In function `XS_DBD__Oracle_ORA_OCI':
Oracle.xs:43: `ORA_OCI_VERSION' undeclared (first use in this function)
Oracle.xs:43: (Each undeclared identifier is reported only once
Oracle.xs:43: for each function it appears in.)
make: *** [Oracle.o] Error 1
 
 
Oracle version: 10G
Server: Itanium 64 bits - Linux
 
 
[ <mailto:root@recover> root@recover DBD-Oracle-1.16]# perl -v
 
This is perl, v5.8.0 built for ia64-linux-thread-multi
(with 1 registered patch, see perl -V for more detail)
 
 
 
 
Thanks
André

Relevant Pages

  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)
  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... On the premise instant client and also tried to run perl Makefile.PL -V ... the status after having connected to Oracle ... Failed 2/33 tests, 93.94% okay ...
    (perl.dbi.users)
  • Re: float bug? perl 5.8, DBI and oracle 10.2.0
    ... If you want to store high precision numbers in oracle, you've got 38 decimal digits to play with, and with minimal coaxing perl will handle them as strings at the appropriate points so that the exact values go in and come out. ... I haven't done any numerical work in 10 years or so, but I seem to recall that one can reasonably expect 6 or so decimal significant digits from a 32 bit floating point number - I'll go out on a limb and hazard that one can expect 12 or so digits from a 64 bit floating point number - at any rate I'd be very surprised to get 18 significant digits. ...
    (perl.dbi.users)
  • RE: Memory fault(coredump) with two DBD type connections
    ... I get a core dump ... all the libraries are the same threaded model(single threaded perl uses ... I am running Perl 5.8.8 with DBD-Oracle 1.19 compiled against Oracle ... when I try to connect to the same Oracle database AND same DB2 database ...
    (perl.dbi.users)
  • Re: suggestions sought on returning rows from oracle proc and deleting them in same proc
    ... this is not Perl stuff but Oracle PL/SQL. ... The reason it is particularly applicable to DBD::Oracle is that it would be possible to solve my problem very easily IF DBD::Oracle supported the returning of oracle table types without pipelining - it doesn't. ... I also needed the gathering of the ids and the deletion done in the same proc. ... create mytable (id int, created timestamp); ...
    (perl.dbi.users)