Hi folks,
I just tried the new DBD-Oracle 1.12 under SuSE Linux 7.2
(2.2.19/glibc 2.2.2). It wouldn't build because of two undefined
symbols. I had to comment OCI_HTYPE_SUBSCRIPTION and OCI_DTYPE_LOCATOR
out. After that it build and tests worked ok.
Here is the output of 'perl Makefile.PL -v'
Using DBI 1.20 installed in /usr/lib/perl5/site_perl/5.6.0/i586-linux/auto/DBI
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /opt/oracle
4.0.3.0.0 Oracle Unix Installer
8.0.5.0.0 Client Software
8.0.5.0.0 Ordts Common Libraries
8.0.5.0.0 ORACLE NLS Libraries and Utilities
8.0.5.0.0 ORACLE Core Libraries
8.0.5.0.0 ORACLE Common RDBMS Libraries and Utilities
8.0.5.0.0 ORACLE PL/SQL Libraries
8.0.5.0.0 ORACLE Common Libraries
8.0.5.0.0 ORACLE Common Precomp Libraries
8.0.5.0.0 ORACLE Common Network Libraries and Utilities
8.0.5.0.0 ORACLE Common Trace Libraries
8.0.5.0.0 ORACLE Common Utilities
8.0.5.0.0 ORACLE Common Agent Libraries
8.0.5.0.0 ORACLE Common Libraries and Utilities
8.0.5.0.0 Platform specific Libraries and Utilities
8.0.5.0.0 Net8
8.0.5.0.0 TCP/IP Protocol Adapter
3.0.2.0.0 Remote Operations
.... Oracle Names
8.0.5.1.0 PL/SQL
8.0.5.0.0 Oracle8 Objects Option
3.0.5.0.0 Oracle Server Manager
8.0.5.1.0 Oracle8 Enterprise (RDBMS)
1.0.0.0.1 <Database Startup> Load Files
4.0.0 Oracle Trace
8.0.5.1.0 Precomp
8.0.5.1.0 Pro*C/C++
8.0.5.0.0 Oracle8 JDBC Drivers
8.0.5.0.0 Object Type Translator
8.0.5.0.0 SQL*Plus
2.0.0.0 Common documentation resources
8.0.5.0 Intel LINUX Documentation
Found rdbms/demo/oratypes.h
Found rdbms/demo/ociapr.h
Found rdbms/demo/ocidef.h
Found rdbms/demo/ocidem.h
Found rdbms/demo/ocidfn.h
Found rdbms/demo/ocikpr.h
Found header files in rdbms/demo.
Found /opt/oracle/rdbms/demo/demo_rdbms.mk
Found /opt/oracle/otrace/demo/atmoci.mk
Found /opt/oracle/precomp/demo/proc/demo_proc.mk
Using /opt/oracle/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/rdbms/demo/demo_rdbms.mk.
Reading /opt/oracle/rdbms/lib/env_rdbms.mk.
Read a total of 726 lines from /opt/oracle/rdbms/lib/env_rdbms.mk (including
inclusions)
Read a total of 886 lines from /opt/oracle/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=/usr/i486-glibc20-linux/bin/gcc
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) $(CCFLAGS) $(QACCFLAGS)
$(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=-o $@ -L$(PRODLIBHOME) -L$(LIBHOME)
-L/usr/i486-glibc20-linux/lib
LMAKE macro redefined by Oracle
from make
to /usr/bin/make
FIND macro redefined by Oracle
from find
to /usr/bin/find # gnu find!
Deleting $(COMPOBJ)/crti.o from COMPOBJS because /opt/oracle/lib/GCC2.7.2.3/crti.o
doesn't exist.
Deleting $(COMPOBJ)/crt1.o from COMPOBJS because /opt/oracle/lib/GCC2.7.2.3/crt1.o
doesn't exist.
Deleting $(COMPOBJ)/crtn.o from COMPOBJS because /opt/oracle/lib/GCC2.7.2.3/crtn.o
doesn't exist.
Edited COMPOBJS definition
from: COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
to: COMPOBJS=
DEVTTLIBS macro redefined by Oracle
from $(TTLIBS)
to $(NAUTAB) $(NAETAB) $(NAEDHS) $(NALDFLAGSLIST) \
$(NETLIBS) $(LLIBRDBMS_CLT) $(LLIBMM) $(CORELIBS)\
$(NETLIBS) $(LLIBRDBMS_CLT) $(LIBPLS_CLT)\
$(LLIBEPC) $(CORELIBS) $(LLIBRDBMS_CLT) $(CORELIBS)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE2)
AR macro redefined by Oracle
from ar
to /usr/ccs/bin/ar
Deleted AR definition: AR=/usr/ccs/bin/ar
AS macro redefined by Oracle
from as
to /usr/ccs/bin/as
Deleted AS definition: AS=/usr/ccs/bin/as
CPP macro redefined by Oracle
from cpp
to $(CC) -E $(ANSI)
Deleted CPP definition: CPP=$(CC) -E $(ANSI)
CHMOD macro redefined by Oracle
from chmod
to /bin/chmod
Deleted CHMOD definition: CHMOD=/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=
Deleted CCFLAGS definition: CCFLAGS= -DLINUX -DUNIFIED_INTEL $(NOKPIC_CCFLAGS) -K PIC
PLATFORM macro redefined by Oracle
from unified_intel
to
MOTIFHOME macro redefined by Oracle
from /usr/X11R6/
to
GUILIBHOME macro redefined by Oracle
from $(OPENWINHOME)lib/
to
GMAKE macro redefined by Oracle
from /usr/bin/make
to gmake
MAKE macro redefined by Oracle
from $(LMAKE)
to gmake
LMAKE macro redefined by Oracle
from /usr/bin/make
to make
FIND macro redefined by Oracle
from /usr/bin/find
to /bin/find # gnu find!
PS macro redefined by Oracle
from ps -aux
to ps -feda
LINK macro redefined by Oracle
from /usr/i486-glibc20-linux/bin/gcc
to /usr/i486-glibc20-linux/bin/gcc $(COMPOBJS)
MOTIFLIBS macro redefined by Oracle
from -L$(MOTIFHOME)lib -lXm -lgen -L$(GUILIBHOME) \
-lXt -lX11 -lw -lm
to -lXm -lXt -lX11 -lgen -lm
XLIBS macro redefined by Oracle
from -L$(GUILIBHOME) $(GUILIBHHOME)libXaw.so.4 -lXt -lXmu\
-lXext -lX11 -lm
to
CCVER macro redefined by Oracle
from GCC2.7.2.3
to SC4.2
COMPOBJS macro redefined by Oracle
from $(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
to
EXSYSLIBS macro redefined by Oracle
from -ldl
to -ldl
DEVTTLIBS macro redefined by Oracle
from $(NAUTAB) $(NAETAB) $(NAEDHS) $(NALDFLAGSLIST) \
$(NETLIBS) $(LLIBRDBMS_CLT) $(LLIBMM) $(CORELIBS)\
$(NETLIBS) $(LLIBRDBMS_CLT) $(LIBPLS_CLT)\
$(LLIBEPC) $(CORELIBS) $(LLIBRDBMS_CLT) $(CORELIBS)
to $(NAUTAB) $(NAETAB) $(NAEDHS) $(NALDFLAGSLIST) \
$(NETLIBS) $(LLIBRDBMS_CLT) $(LLIBMM) $(CORELIBS)\
$(NETLIBS) $(LLIBRDBMS_CLT) $(LIBPLS_CLT)\
$(LLIBEPC) $(CORELIBS) $(LLIBRDBMS_CLT) $(CORELIBS) \
$(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) -lc -laio $(MATHLIB) $(USRLIBS)
OPTIMIZE macro redefined by Oracle
from $(OPTIMIZE2)
to $(OPTIMIZE3)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE3)
SPFLAGS macro redefined by Oracle
from -D_SVID_GETTOD
to `$(ORACLE_HOME)/unified_bin/spflags`
AR macro redefined by Oracle
from /usr/ccs/bin/ar
to ar
Deleted AR definition: AR=ar
AS macro redefined by Oracle
from /usr/ccs/bin/as
to as
Deleted AS definition: AS=as
CPP macro redefined by Oracle
from $(CC) -E $(ANSI)
to /lib/cpp
Deleted CPP definition: CPP=/lib/cpp
Deleted CHMOD definition: CHMOD=/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=
NOKPIC_CCFLAGS macro redefined by Oracle
from -Xa $(PROFILE) -xstrconst -xF -I$(ORACLE_HOME)/shdrs $(XS) -mr \
-xarch=v8 -xcache=16/32/1:1024/64/1 -xchip=ultra -D_REENTRANT
to `$(ORACLE_HOME)/unified_bin/ccflags`
CCFLAGS macro redefined by Oracle
from -DLINUX -DUNIFIED_INTEL $(NOKPIC_CCFLAGS) -K PIC
to $(NOKPIC_CCFLAGS)
Deleted CCFLAGS definition: CCFLAGS= $(NOKPIC_CCFLAGS)
SHARED_LDFLAG macro redefined by Oracle
from -shared -L$(ORACLE_HOME)/lib -R$(ORACLE_HOME)/lib -o
to -shared -L$(ORACLE_HOME)/lib -o
Deleted AR definition: AR=ar
SSORED macro redefined by Oracle
from $(RDBMSLIB)ssoraed.$(OBJ_EXT)
to $(RDBMSLIB)ssoraed.$(OBJ_EXT) # oracle prog. mgr. data
MTS_NCR macro redefined by Oracle
from $(LIBHOME)ncrstab.$(OBJ_EXT)
to ncrstab.$(OBJ_EXT)
NETLIBS macro redefined by Oracle
from $(LLIBSQLNET) $(LLIBRPC) $(LLIBSQLNET)
to -lnetv2 -lnttcp -lnetwork -lncr
Appending '-ldl -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr
-lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp
-lnetwork -lncr -lsql -lsql' to LDLIBS
LIBNM macro redefined by Oracle
from $(LIBDLM)
to $(CLUSTERDIR)/lib/libudlm.so
LLIBNM macro redefined by Oracle
from $(LLIBDLM)
to $(SKGXN) -ludlm
Deleted CC definition: CC=/usr/i486-glibc20-linux/bin/gcc
CCFLAGS macro redefined by Oracle
from $(NOKPIC_CCFLAGS)
to
Deleted CCFLAGS definition: CCFLAGS=
SPFLAGS macro redefined by Oracle
from `$(ORACLE_HOME)/unified_bin/spflags`
to
OPTIMIZE macro redefined by Oracle
from $(OPTIMIZE3)
to
Deleted OPTIMIZE definition: OPTIMIZE=
LINK macro redefined by Oracle
from /usr/i486-glibc20-linux/bin/gcc $(COMPOBJS)
to /usr/i486-glibc20-linux/bin/gcc
MAKE macro redefined by Oracle
from gmake
to make
Deleted AR definition: AR=ar
LLIBOBK macro redefined by Oracle
from -lobk
to
LIBDLM macro redefined by Oracle
from $(SKGXN) $(LIBHOME)libudlm.$(LIB_EXT)
to `echo "$(SKGXN) /usr/lib/libdlm.so"`
LLIBDLM macro redefined by Oracle
from $(SKGXN) -L /var/opt/ncrdlm/lib -ludlm
to `echo "$(SKGXN) -ldlm`
LIBNM macro redefined by Oracle
from $(CLUSTERDIR)/lib/libudlm.so
to $(LIBDLM)
LLIBNM macro redefined by Oracle
from $(SKGXN) -ludlm
to $(LLIBDLM)
RDBMSLIB macro redefined by Oracle
from $(RDBMSHOME)lib/
to $(ORACLE_HOME)/rdbms/lib/
LDFLAGS macro redefined by Oracle
from -o $@ -L$(PRODLIBHOME) -L$(LIBHOME) -L/usr/i486-glibc20-linux/lib
to -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
Deleted LDFLAGS definition: LDFLAGS=-L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
CONFIG macro redefined by Oracle
from $(RDBMSLIB)config.$(OBJ_EXT)
to $(ORACLE_HOME)/rdbms/lib/config.o
Evaluating `cat $(LIBHOME)naldflgs`
expanded `cat /opt/oracle/lib/naldflgs`
returned ''
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /opt/oracle/lib/sysliblist`
returned '-lnsl -lm'
Attempting to discover Oracle OCI build rules...
cc -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
by executing:
make -f /opt/oracle/rdbms/demo/demo_rdbms.mk build ECHODO=true ECHO=echo
GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE
OBJS=DBD_ORA_OBJ.o
Oracle oci build command:
true echo -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib -o DBD_ORA_EXE
DBD_ORA_OBJ.o /opt/oracle/rdbms/lib/defopt.o /opt/oracle/lib/sscoreed.o
/opt/oracle/lib/libclntsh.so /opt/oracle/lib/nautab.o /opt/oracle/lib/naeet.o
/opt/oracle/lib/naect.o /opt/oracle/lib/naedhs.o `cat /opt/oracle/lib/naldflgs`
-lnetv2 -lnttcp -lnetwork -lncr -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3
-lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr -lclient -lvsn
-lcommon -lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient
-lvsn -lcommon -lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 `cat
/opt/oracle/lib/sysliblist` -ldl -lm -ldl -lnetv2 -lnttcp -lnetwork -lncr -lnetv2
-lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork
-lncr -lnetv2 -lnttcp -lnetwork -lncr -lsql -lsql
System: perl5.006 linux subbotin 2.4.3 #1 tue may 8 21:54:34 gmt 2001 i686 unknown
Compiler: cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -lnsl -lm
Oracle makefiles would have used these definitions but we override them:
CC: /usr/i486-glibc20-linux/bin/gcc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) $(QACCFLAGS) -I/opt/oracle/rdbms/demo -I/opt/oracle/rdbms/public
-I/opt/oracle/plsql/public -I/opt/oracle/network/public $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
[-L$(LIBHOME) -L/opt/oracle/rdbms/lib]
Linking with OTHERLDFLAGS = -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib
/opt/oracle/rdbms/lib/defopt.o /opt/oracle/lib/sscoreed.o /opt/oracle/lib/libclntsh.so
/opt/oracle/lib/nautab.o /opt/oracle/lib/naeet.o /opt/oracle/lib/naect.o
/opt/oracle/lib/naedhs.o `cat /opt/oracle/lib/naldflgs` -lnetv2 -lnttcp -lnetwork
-lncr -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4
-lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr -lclient -lvsn -lcommon -lgeneric -lepc
-lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -lcommon -lgeneric
-lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 `cat /opt/oracle/lib/sysliblist` -ldl
-lm -ldl -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lnetv2
-lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork
-lncr -lsql -lsql [from 'build' rule]
MakeMaker (v5.45)
Checking if your kit is complete...
Looks good
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce ([EMAIL PROTECTED])]
DEFINE => q[]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-I/opt/oracle/rdbms/demo -I/opt/oracle/rdbms/public
-I/opt/oracle/plsql/public -I/opt/oracle/network/public -I/opt/oracle/rdbms/demo
-I/opt/oracle/rdbms/demo -I/usr/lib/perl5/site_perl/5.6.0/i586-linux/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],
PREOP=>q[$(MAKE) -f Makefile.old distdir], COMPRESS=>q[gzip -v9], SUFFIX=>q[gz] }
dynamic_lib => { OTHERLDFLAGS=>q[ -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib
/opt/oracle/rdbms/lib/defopt.o /opt/oracle/lib/sscoreed.o /opt/oracle/lib/libclntsh.so
/opt/oracle/lib/nautab.o /opt/oracle/lib/naeet.o /opt/oracle/lib/naect.o
/opt/oracle/lib/naedhs.o `cat /opt/oracle/lib/naldflgs` -lnetv2 -lnttcp -lnetwork
-lncr -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4
-lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr -lclient -lvsn -lcommon -lgeneric -lepc
-lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -lcommon -lgeneric
-lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 `cat /opt/oracle/lib/sysliblist` -ldl
-lm -ldl -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lnetv2
-lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork
-lncr -lsql -lsql ] }
Using PERL=/usr/bin/perl
LD_RUN_PATH=/opt/oracle/lib:/opt/oracle/rdbms/lib
Using DBD::Oracle 1.12.
Using DBI 1.20 installed in /usr/lib/perl5/site_perl/5.6.0/i586-linux/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?)
--
MfG/Regards
/====
/ Ridderbusch / ,
/ /./ Franz Kahmen Str. 15
/=== /,== ,===/ /,==, // 33104 Paderborn, Germany
/ // / / // / / \ Tel.: (49) 5254-939284
/ / `==/\ / / / \ Email: [EMAIL PROTECTED]
Since I have taken all the Gates out of my computer, it finally works!!
