DBD-Oracle-1.14 Oracle91 Suse9

From: Daniel Engler (daniel.engler_at_philo.unibe.ch)
Date: 01/26/04

Next message: Tim Bunce: "Re: DBD-Oracle-1.14 Oracle91 Suse9"

Previous message: Steffen Goeldner: "ANNOUNCE: DBD::ADO 2.86"
Next in thread: Tim Bunce: "Re: DBD-Oracle-1.14 Oracle91 Suse9"
Reply: Tim Bunce: "Re: DBD-Oracle-1.14 Oracle91 Suse9"
Maybe reply: Tim Bunce: "Re: DBD-Oracle-1.14 Oracle91 Suse9"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Mon, 26 Jan 2004 11:13:05 +0100
To: dbi-users@perl.org

My installation of DBD-Oracle-1.14 failed. I'm not able to make:
make: *** [Oracle.o] Error 1

System:
Oracle 9.2.010
gcc version 2.9.5.3
Linux SuSE 9.0

below the linsting oft the commands:
perl Makefile.PL -v
make
make test
make test TEST_VERBOSE=1
perl -V

Thank you
Daniel Engler
---------------------------------------------------------------------

pythia2:~/install/oracle/perl/DBD-Oracle-1.14 # perl Makefile.PL -v
Using DBI 1.37 installed in
/usr/lib/perl5/vendor_perl/5.8.1/i586-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/9ir2

Oracle version 9.2.0.0.0
Found header files in rdbms/demo rdbms/public.
Found /opt/oracle/product/9ir2/rdbms/demo/demo_rdbms.mk
Found /opt/oracle/product/9ir2/otrace/demo/atmoci.mk
Found /opt/oracle/product/9ir2/precomp/demo/proc/demo_proc.mk
Using /opt/oracle/product/9ir2/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/product/9ir2/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/product/9ir2/rdbms/lib/env_rdbms.mk
Read a total of 2202 lines from
/opt/oracle/product/9ir2/rdbms/lib/env_rdbms.mk (including inclusions)
Read a total of 2493 lines from
/opt/oracle/product/9ir2/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 '/opt/oracle/product/9ir2/rdbms/lib/libskgxpd.a
/opt/oracle/product/9ir2/rdbms/lib/libskgxpu.a
/opt/oracle/product/9ir2/rdbms/lib/libskgxpt.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxp9.so' to SHLIBS
Appending '/opt/oracle/product/9ir2/rdbms/lib/libskgxp9.a' to LIBS
Appending '/opt/oracle/product/9ir2/rdbms/lib/libskgxns.a
/opt/oracle/product/9ir2/rdbms/lib/libskgxnd.a
/opt/oracle/product/9ir2/rdbms/lib/libskgxnr.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxn9.so' to SHLIBS
Appending '/opt/oracle/product/9ir2/rdbms/lib/libskgxn9.a' to LIBS
Evaluating `cat $(LIBHOME)sysliblist`
   expanded `cat /opt/oracle/product/9ir2/lib/sysliblist`
   returned '-ldl -lm -lpthread -lnsl '

Attempting to discover Oracle OCI build rules
cc -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
by executing: (make -f /opt/oracle/product/9ir2/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/opt/oracle/product/9ir2/lib/
-L/opt/oracle/product/9ir2/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o
-lclntsh `cat /opt/oracle/product/9ir2/lib/sysliblist` -ldl -lm

[-L/opt/oracle/product/9ir2/lib/ -L/opt/oracle/product/9ir2/rdbms/lib/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -ldl -lm -lpthread -lnsl -ldl -lm
]
reduced to:
[-L/opt/oracle/product/9ir2/lib/ -L/opt/oracle/product/9ir2/rdbms/lib/
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -ldl -lm -lpthread -lnsl -ldl -lm
]
Oracle oci build command:
+ -L/opt/oracle/product/9ir2/lib/
-L/opt/oracle/product/9ir2/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o
-lclntsh -ldl -lm -lpthread -lnsl -ldl -lm

Scalar found where operator expected at (eval 198) line 1, near "'int'
$__val"
(Missing operator before $__val?)

System: perl5.008001 linux oldwotan 2.6.0-test3 #1 smp tue may 20
08:20:31 utc 2003 i686 i686 i386 gnulinux
Compiler: cc -O2 -march=i586 -mcpu=i686 -fmessage-length=0 -Wall -pipe
-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-aliasing
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
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/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/opt/oracle/product/9ir2/plsql/public
-I/opt/oracle/product/9ir2/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/opt/oracle/product/9ir2/rdbms/lib/ -L$(LIBHOME)
-L$(LIBHOME)stubs/]

Linking with OTHERLDFLAGS = -L/opt/oracle/product/9ir2/lib/
-L/opt/oracle/product/9ir2/rdbms/lib/ -lclntsh -ldl -lm -lpthread
-lnsl -ldl -lm
[from 'build' rule]

Argument "9.200.0.0" isn't numeric in numeric ge (>=) at Makefile.PL
line 669.

MakeMaker (v6.17)
Checking if your kit is complete...
Looks good
   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/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/opt/oracle/product/9ir2/plsql/public
-I/opt/oracle/product/9ir2/network/public
-I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/usr/lib/perl5/vendor_perl/5.8.1/i586-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 => { COMPRESS=>q[gzip -v9], SUFFIX=>q[gz], DIST_DEFAULT=>q[clean
distcheck disttest ci tardist], PREOP=>q[$(MAKE) -f Makefile.old distdir] }
   dynamic_lib => { OTHERLDFLAGS=>q[ -L/opt/oracle/product/9ir2/lib/
-L/opt/oracle/product/9ir2/rdbms/lib/ -lclntsh -ldl -lm -lpthread
-lnsl -ldl -lm
] }
Using PERL=/usr/bin/perl
LD_RUN_PATH=/opt/oracle/product/9ir2/lib:/opt/oracle/product/9ir2/rdbms/lib
Using DBD::Oracle 1.14.
Using DBD::Oracle 1.14.
Using DBI 1.37 installed in
/usr/lib/perl5/vendor_perl/5.8.1/i586-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?)

pythia2:~/install/oracle/perl/DBD-Oracle-1.14 # make
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp oraperl.ph blib/lib/oraperl.ph
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp Oraperl.pm blib/lib/Oraperl.pm
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oracle.pm blib/lib/DBD/Oracle.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
/usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi/auto/DBI/Driver.xst
> Oracle.xsi
/usr/bin/perl /usr/lib/perl5/5.8.1/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.8.1/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv
Oracle.xsc Oracle.c
cc -c -I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/opt/oracle/product/9ir2/plsql/public
-I/opt/oracle/product/9ir2/network/public
-I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi/auto/DBI
-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-aliasing
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -march=i586 -mcpu=i686
-fmessage-length=0 -Wall -pipe -DVERSION=\"1.14\"
-DXS_VERSION=\"1.14\" -fPIC
"-I/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE" -DUTF8_SUPPORT
Oracle.c
cc1: Invalid option `-fmessage-length=0'
In file included from /usr/include/asm/sigcontext.h:4,
                  from /usr/include/bits/sigcontext.h:28,
                  from /usr/include/signal.h:326,
                  from
/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE/unixish.h:107,
                  from
/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE/perl.h:1969,
                  from
/usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi/auto/DBI/DBIXS.h:19,
                  from Oracle.h:18,
                  from Oracle.xs:1:
/usr/include/linux/compiler.h:71: warning: `__attribute_used__' redefined
/usr/include/sys/cdefs.h:195: warning: this is the location of the
previous definition
Oracle.xs: In function `XS_DBD__Oracle__st_cancel':
Oracle.xs:99: warning: implicit declaration of function `ora_st_cancel'
Oracle.xs: In function `XS_DBD__Oracle__dr_init_oci':
Oracle.xs:122: warning: implicit declaration of function `dbd_init_oci_drh'
make: *** [Oracle.o] Error 1
pythia2:~/install/oracle/perl/DBD-Oracle-1.14 # make test
cc -c -I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/opt/oracle/product/9ir2/plsql/public
-I/opt/oracle/product/9ir2/network/public
-I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi/auto/DBI
-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-aliasing
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -march=i586 -mcpu=i686
-fmessage-length=0 -Wall -pipe -DVERSION=\"1.14\"
-DXS_VERSION=\"1.14\" -fPIC
"-I/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE" -DUTF8_SUPPORT
Oracle.c
cc1: Invalid option `-fmessage-length=0'
In file included from /usr/include/asm/sigcontext.h:4,
                  from /usr/include/bits/sigcontext.h:28,
                  from /usr/include/signal.h:326,
                  from
/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE/unixish.h:107,
                  from
/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE/perl.h:1969,
                  from
/usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi/auto/DBI/DBIXS.h:19,
                  from Oracle.h:18,
                  from Oracle.xs:1:
/usr/include/linux/compiler.h:71: warning: `__attribute_used__' redefined
/usr/include/sys/cdefs.h:195: warning: this is the location of the
previous definition
Oracle.xs: In function `XS_DBD__Oracle__st_cancel':
Oracle.xs:99: warning: implicit declaration of function `ora_st_cancel'
Oracle.xs: In function `XS_DBD__Oracle__dr_init_oci':
Oracle.xs:122: warning: implicit declaration of function `dbd_init_oci_drh'
make: *** [Oracle.o] Error 1
pythia2:~/install/oracle/perl/DBD-Oracle-1.14 # make test TEST_VERBOSE=1
cc -c -I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/opt/oracle/product/9ir2/plsql/public
-I/opt/oracle/product/9ir2/network/public
-I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/demo
-I/opt/oracle/product/9ir2/rdbms/public
-I/usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi/auto/DBI
-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-aliasing
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -march=i586 -mcpu=i686
-fmessage-length=0 -Wall -pipe -DVERSION=\"1.14\"
-DXS_VERSION=\"1.14\" -fPIC
"-I/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE" -DUTF8_SUPPORT
Oracle.c
cc1: Invalid option `-fmessage-length=0'
In file included from /usr/include/asm/sigcontext.h:4,
                  from /usr/include/bits/sigcontext.h:28,
                  from /usr/include/signal.h:326,
                  from
/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE/unixish.h:107,
                  from
/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE/perl.h:1969,
                  from
/usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi/auto/DBI/DBIXS.h:19,
                  from Oracle.h:18,
                  from Oracle.xs:1:
/usr/include/linux/compiler.h:71: warning: `__attribute_used__' redefined
/usr/include/sys/cdefs.h:195: warning: this is the location of the
previous definition
Oracle.xs: In function `XS_DBD__Oracle__st_cancel':
Oracle.xs:99: warning: implicit declaration of function `ora_st_cancel'
Oracle.xs: In function `XS_DBD__Oracle__dr_init_oci':
Oracle.xs:122: warning: implicit declaration of function `dbd_init_oci_drh'
make: *** [Oracle.o] Error 1
pythia2:~/install/oracle/perl/DBD-Oracle-1.14 # perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 1) configuration:
   Platform:
     osname=linux, osvers=2.6.0-test3, archname=i586-linux-thread-multi
     uname='linux oldwotan 2.6.0-test3 #1 smp tue may 20 08:20:31 utc
2003 i686 i686 i386 gnulinux '
     config_args='-ds -e -Dprefix=/usr -Dvendorprefix=/usr
-Dinstallusrbinperl -Dusethreads -Di_db -Di_dbm -Di_ndbm -Di_gdbm
-Duseshrplib=true -Doptimize=-O2 -march=i586 -mcpu=i686
-fmessage-length=0 -Wall -pipe'
     hint=recommended, useposix=true, d_sigaction=define
     usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
     useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
     use64bitint=undef use64bitall=undef uselongdouble=undef
     usemymalloc=n, bincompat5005=undef
   Compiler:
     cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
     optimize='-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -Wall -pipe',
     cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-fno-strict-aliasing'
     ccversion='', gccversion='3.3.1 (SuSE Linux)', gccosandvers=''
     intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
     d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
     ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
     alignbytes=4, prototype=define
   Linker and Libraries:
     ld='cc', ldflags =''
     libpth=/lib /usr/lib /usr/local/lib
     libs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
     perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
     libc=, so=so, useshrplib=true, libperl=libperl.so
     gnulibc_version='2.3.2'
   Dynamic Linking:
     dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic
-Wl,-rpath,/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE'
     cccdlflags='-fPIC', lddlflags='-shared'

Characteristics of this binary (from libperl):
   Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_CONTEXT
   Locally applied patches:
         RC5
   Built under linux
   Compiled at Sep 23 2003 15:42:44
   @INC:
     /usr/lib/perl5/5.8.1/i586-linux-thread-multi
     /usr/lib/perl5/5.8.1
     /usr/lib/perl5/site_perl/5.8.1/i586-linux-thread-multi
     /usr/lib/perl5/site_perl/5.8.1
     /usr/lib/perl5/site_perl
     /usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi
     /usr/lib/perl5/vendor_perl/5.8.1
     /usr/lib/perl5/vendor_perl
     .

Next message: Tim Bunce: "Re: DBD-Oracle-1.14 Oracle91 Suse9"

Previous message: Steffen Goeldner: "ANNOUNCE: DBD::ADO 2.86"
Next in thread: Tim Bunce: "Re: DBD-Oracle-1.14 Oracle91 Suse9"
Reply: Tim Bunce: "Re: DBD-Oracle-1.14 Oracle91 Suse9"
Maybe reply: Tim Bunce: "Re: DBD-Oracle-1.14 Oracle91 Suse9"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Compiling and running DBD for Oracle 10g without installing Oracle
... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
(perl.dbi.users)
Compiling and running DBD for Oracle 10g without installing Oracle
... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
(perl.dbi.users)
RE: Connect to Oracle
... You should always include information about your platform, Perl version, ... DBD::Oracle version and Oracle version, as it almost always helps with the ... It's getting as far as loading the libraries, so you have an Oracle client ... test suite wasn't run on installation. ...
(perl.dbi.users)
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: 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)