DBD::Oracle won"t install for Oracle 10G XE
DBD::Oracle won"t install for Oracle 10G XE
am 13.11.2005 22:19:02 von Anup
-----------=_1131916742-9191-360332507
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello,
Tried installing DBD::Oracle on Linux with Oracle 10G XE but it failed.
There is only one .mk file on rdbms/demo and it fails with that also.
The .mk is available at:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/demo_xe.m
k
and the file is attached to this mail
Cheers
Anup
____________________________________________________________ ___________
Mail Service From scorpioinformatics.com
Read Without Opening Mail!
270 MB MailBox Without Ads!
AdvocateMail.com :: Go4Medicare.com :: LocatorBiz.com :: Mail4Biz.com
____________________________________________________________ ___________
-----------=_1131916742-9191-360332507
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="demo_xe.mk.txt"
#/bin/make=0D
############################################################ ###############=
####=0D
# Make file for OCI and OCCI demos=0D
############################################################ ###############=
####=0D
# Usage :=0D
# For compiling & linking the cdemo81.c file=0D
# make -f demo.mk buildoci CDEMOEXE=3Dcdemo81 CDEMOOBJS=3Dcdemo81.o =0D
#=0D
# For compiling & linking the occidml.cpp=0D
# make -f demo.mk buildocci OCCIDEMOEXE=3Doccidml OCCIDEMOOBJS=3Doccidml=
o=0D
#=0D
# For compiling & linking the occiobj.cpp=0D
# make -f demo.mk occiobj =0D
#=0D
# In general, for any occi program=0D
# make -f demo.mk buildocci EXE=3D OBJS=3D"
bjs>"=0D
#=0D
# For compiling all demos=0D
# make -f demo.mk=0D
#=0D
# NOTE: Please change cc and CC to point to the appropiate location on your=
=0D
# machine.=0D
#=0D
############################################################ ###############=
####=0D
=0D
SUFFIXES: .o .c .cpp=0D
=0D
ICINCHOME=3D$(ORACLE_HOME)/rdbms/public/=0D
ICLIBHOME=3D$(ORACLE_HOME)/lib/=0D
ICLIBPATH=3D-L$(ICLIBHOME)=0D
THREADLIBS=3D-lthread=0D
CCLIB=3D$(ICLIBPATH) -lclntsh $(THREADLIBS)=0D
OCCILIB=3D$(ICLIBPATH) -locci -lclntsh $(THREADLIBS)=0D
=0D
CCINCLUDES =3D -I$(ICINCHOME)=0D
=0D
CCFLAGS=3D$(CCINCLUDES) -D_REENTRANT -g -xs =0D
LDFLAGS=
SO_EXT=3D.so=0D
=0D
REMOVE=3Drm -rf=0D
MKLINK=3Dln=0D
MAKE=3Dmake=0D
MAKEFILE=3Ddemo_xe.mk=0D
CLNCACHE=3Dcleancache=0D
=0D
CDEMOEXE=3Dcdemo81=0D
CDEMOOBJS=3Dcdemo81.o=0D
OCCIDEMOEXE=3Doccidml=0D
OCCIDEMOOBJS=3Doccidml.o=0D
OCCIOBJDEMO=3Docciobj=0D
OTT=3D$(ORACLE_HOME)/bin/ott=0D
OCCIOTTUSR=3Dhr=0D
OCCIOTTPWD=3Dhr=0D
ODBCDEMOEXE=3Dodbcdemo=0D
ODBCDEMOOBJS=3Dodbcdemo.o=0D
=0D
cpp.o:=0D
$(CC) -c -I$(ICINCHOME) $(CCFLAGS) $<=0D
=0D
c.o:=0D
$(cc) -c -I$(ICINCHOME) $(ODBCDEMO_INCLUDE) $(CCFLAGS) $<=0D
=0D
all: clean buildoci $(OCCIDEMOEXE) $(OCCIOBJDEMO) $(ODBCDEMOEXE)=0D
=0D
buildoci: $(CLNCACHE) $(LIBCLNT) $(CDEMOOBJS)=0D
$(MKLINK) $(ICLIBHOME)libclntsh$(SO_EXT).10.1 $(ICLIBHOME)libclntsh=
$(SO_EXT)=0D
$(CC) -o $(CDEMOEXE) $(LDFLAGS) $(CDEMOOBJS) $(CCLIB)=0D
$(REMOVE) $(ICLIBHOME)libclntsh$(SO_EXT)=0D
=0D
buildocci: $(CLNCACHE) $(LIBCLNT) $(OCCIDEMOOBJS)=0D
$(MKLINK) $(ICLIBHOME)libclntsh$(SO_EXT).10.1 $(ICLIBHOME)libclntsh=
$(SO_EXT)=0D
$(MKLINK) $(ICLIBHOME)libocci$(SO_EXT).10.1 $(ICLIBHOME)libocci$(SO=
_EXT)=0D
$(CC) -o $(OCCIDEMOEXE) $(LDFLAGS) $(OCCIDEMOOBJS) $(OCCILIB)=0D
$(REMOVE) $(ICLIBHOME)libclntsh$(SO_EXT)=0D
$(REMOVE) $(ICLIBHOME)libocci$(SO_EXT)=0D
=0D
$(CDEMOEXE):=0D
$(MAKE) -f $(MAKEFILE) buildoci OBJS=3D$@.o EXE=3D$@=0D
=0D
$(OCCIDEMOEXE):=0D
$(MAKE) -f $(MAKEFILE) buildocci OBJS=3D$@.o EXE=3D$@=0D
=0D
$(OCCIOBJDEMO):=0D
$(OTT) userid=3D$(OCCIOTTUSR)/$(OCCIOTTPWD) \=0D
intype=3D$@.typ \=0D
outtype=3D$@out.type \=0D
code=3Dcpp \=0D
hfile=3D$@.h \=0D
cppfile=3D$@o.cpp \=0D
attraccess=3Dprivate \=0D
unicode=3Dnone=0D
$(MAKE) -f $(MAKEFILE) buildocci OBJS=3D"$@.o $@m.o $@o.o" EXE=3D$@=
=0D
=0D
ODBCDM_HOME=3D$(ORACLE_HOME)/odbc/public/osds/unixODBC=0D
ODBCDM_INCLUDE=3D$(ODBCDM_HOME)/include=0D
ODBCDM_LIBHOME=3D$(ODBCDM_HOME)/lib=0D
ODBCDEMO_INCLUDE=3D-I$(ODBCDM_INCLUDE) -I. =0D
ODBCDMLIB=3D-lodbc=0D
=0D
buildodbcdemo: $(ODBCDEMOOBJS) =0D
$(cc) -o $(ODBCDEMOEXE) $(ODBCDEMOOBJS) -L$(ODBCDM_LIBHOME) $(ODBCD=
MLIB)=0D
=0D
$(ODBCDEMOEXE):=0D
$(MAKE) -f $(MAKEFILE) buildodbcdemo ODBCDEMOOBJS=3D$@.o ODBCDEMOEX=
E=3D$@=0D
=0D
cleancache:=0D
$(REMOVE) $(ICLIBHOME)libclntsh$(SO_EXT)=0D
$(REMOVE) $(ICLIBHOME)libocci$(SO_EXT)=0D
=0D
clean:=0D
$(REMOVE) cdemo81 cdemo81.o occidml occidml.o occiobj occiobj.o occ=
iobjo* occiobjm* occiobj.h occiobjout.type odbcdemo odbcdemo.o=0D
=0D
=0D
#=0D
# This port-specific file is currently empty on Solaris. Product=0D
# lines may use this file to override compiler definitions and=0D
# flags used in occi.mk.=0D
#=0D
=0D
# Linux compiler definitions=0D
CC=3D/usr/bin/gcc=0D
cc=3D/usr/bin/gcc=0D
=0D
CCFLAGS=3D$(CCINCLUDES) -DLINUX -D_GNU_SOURCE -D_REENTRANT -g=0D
LDFLAGS=3D-g=0D
=0D
# This macro CCINCLUDES has to be redefined on Linux because of=0D
# the existence of the 'new' directory in t_work. The name new=0D
# clashes with a system header file.=0D
CCINCLUDES =3D -idirafter .=0D
=0D
THREADLIBS=3D-lpthread=0D
=0D
ifdef BUILD_CCC296=0D
CC=3D/usr/bin/g++296=0D
endif=
-----------=_1131916742-9191-360332507--
Re: DBD::Oracle won"t install for Oracle 10G XE
am 22.11.2005 00:34:39 von Tim.Bunce
On Mon, Nov 14, 2005 at 02:49:02AM +0530, Anup Singh wrote:
> Hello,
>
> Tried installing DBD::Oracle on Linux with Oracle 10G XE but it failed.
I've implemented support for XE in the next release. Can't say when
that'll be, but here's a patch that may work for you...
(Might need to be applied by hand to your Makefile.PL)
Please (everyone) let me know if this works for you, or not.
Thanks.
Tim.
--- dbd-oracle/branches/pythian/Makefile.PL (original)
+++ dbd-oracle/branches/pythian/Makefile.PL Sun Nov 20 14:54:09 2005
@@ -327,6 +327,31 @@ elsif ($::opt_l and # use -l to enable t
my $inc = join " ", map { "-I$OH/$_" } @h_dirs;
$opts{INC} = "$inc -I$dbi_arch_dir";
}
+
+elsif (-e "$OH/rdbms/demo/demo_xe.mk") { # Oracle XE
+
+ print "Looks like Oracle XE\n";
+
+ fetch_oci_macros("$OH/rdbms/demo/demo_xe.mk");
+ $MK{CCINCLUDES} = '-I$(ICINCHOME)'; # undo odd refinition in demo_xe.mk
+
+ # From linux Oracle XE (10.2.0):
+ # ICINCHOME=$(ORACLE_HOME)/rdbms/public/
+ # ICLIBHOME=$(ORACLE_HOME)/lib/
+ # ICLIBPATH=-L$(ICLIBHOME)
+ # THREADLIBS=-lpthread [initially -lthread then redefined]
+ # CCLIB=$(ICLIBPATH) -lclntsh $(THREADLIBS)
+ # CCINCLUDES = -I$(ICINCHOME) [see above]
+ # CCFLAGS=$(CCINCLUDES) -DLINUX -D_GNU_SOURCE -D_REENTRANT -g [initially without -DLINUX -D_GNU_SOURCE]
+ my $cclib = expand_mkvars($MK{CCLIB}, 0, 1);
+ my $ccflags = expand_mkvars($MK{CCFLAGS}, 0, 1);
+
+ $linkwith_msg = "$cclib";
+ $opts{LIBS} = [ $cclib ];
+ $opts{INC} = "-I$dbi_arch_dir $ccflags";
+ $opts{dynamic_lib} = { OTHERLDFLAGS => "$::opt_g" };
+}
+
# --- special case for Oracle 10g instant client
elsif (-e "$OH/libclntsh.so.10.1") {
Re: DBD::Oracle won"t install for Oracle 10G XE
am 22.11.2005 01:39:40 von charding
The patch does not apply against the 1.16 version of the Makefile.PL as
the code that handles the 10g instant client is not in the file.
On Mon, 21 Nov 2005, Tim Bunce wrote:
> On Mon, Nov 14, 2005 at 02:49:02AM +0530, Anup Singh wrote:
>> Hello,
>>
>> Tried installing DBD::Oracle on Linux with Oracle 10G XE but it failed.
>
> I've implemented support for XE in the next release. Can't say when
> that'll be, but here's a patch that may work for you...
> (Might need to be applied by hand to your Makefile.PL)
>
> Please (everyone) let me know if this works for you, or not.
> Thanks.
>
> Tim.
>
> --- dbd-oracle/branches/pythian/Makefile.PL (original)
> +++ dbd-oracle/branches/pythian/Makefile.PL Sun Nov 20 14:54:09 2005
> @@ -327,6 +327,31 @@ elsif ($::opt_l and # use -l to enable t
> my $inc = join " ", map { "-I$OH/$_" } @h_dirs;
> $opts{INC} = "$inc -I$dbi_arch_dir";
> }
> +
> +elsif (-e "$OH/rdbms/demo/demo_xe.mk") { # Oracle XE
> +
> + print "Looks like Oracle XE\n";
> +
> + fetch_oci_macros("$OH/rdbms/demo/demo_xe.mk");
> + $MK{CCINCLUDES} = '-I$(ICINCHOME)'; # undo odd refinition in demo_xe.mk
> +
> + # From linux Oracle XE (10.2.0):
> + # ICINCHOME=$(ORACLE_HOME)/rdbms/public/
> + # ICLIBHOME=$(ORACLE_HOME)/lib/
> + # ICLIBPATH=-L$(ICLIBHOME)
> + # THREADLIBS=-lpthread [initially -lthread then redefined]
> + # CCLIB=$(ICLIBPATH) -lclntsh $(THREADLIBS)
> + # CCINCLUDES = -I$(ICINCHOME) [see above]
> + # CCFLAGS=$(CCINCLUDES) -DLINUX -D_GNU_SOURCE -D_REENTRANT -g [initially without -DLINUX -D_GNU_SOURCE]
> + my $cclib = expand_mkvars($MK{CCLIB}, 0, 1);
> + my $ccflags = expand_mkvars($MK{CCFLAGS}, 0, 1);
> +
> + $linkwith_msg = "$cclib";
> + $opts{LIBS} = [ $cclib ];
> + $opts{INC} = "-I$dbi_arch_dir $ccflags";
> + $opts{dynamic_lib} = { OTHERLDFLAGS => "$::opt_g" };
> +}
> +
> # --- special case for Oracle 10g instant client
>
> elsif (-e "$OH/libclntsh.so.10.1") {
>
--
Charles D. (Chuck) Harding Voice: 925-423-8879
Senior Computer Associate ICCD Fax: 925-423-6961
Lawrence Livermore National Laboratory Computation Directorate
Livermore, CA USA http://www.llnl.gov GPG Public Key ID: B9EB6601
------------------ http://tinyurl.com/5w5ey -----------------------
-- A new standard in obfuscation, ambiguity, & equivocation. --
Re: DBD::Oracle won"t install for Oracle 10G XE
am 22.11.2005 13:06:15 von Tim.Bunce
On Mon, Nov 21, 2005 at 04:39:40PM -0800, Chuck Harding wrote:
> The patch does not apply against the 1.16 version of the Makefile.PL as
> the code that handles the 10g instant client is not in the file.
Okay. So what happens when you apply it by hand?
Tim.
(Fwd) Re: DBD::Oracle won"t install for Oracle 10G XE
am 14.08.2007 10:53:33 von Tim.Bunce
----- Forwarded message from lr@neukat.com -----
X-IP: 216.150.208.7
From: lr@neukat.com
To: Tim Bunce
Subject: Re: DBD::Oracle won't install for Oracle 10G XE
Date: Mon, 13 Aug 2007 22:42:59 -0700
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US;
rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe)
On Nov 21 2005, 6:34 pm, Tim.Bu...@pobox.com (Tim Bunce) wrote:
> On Mon, Nov 14, 2005 at 02:49:02AM +0530, Anup Singh wrote:
> > Hello,
>
> > Tried installingDBD::Oracleon Linux withOracle10GXEbut it failed.
>
> I've implemented support forXEin the next release. Can't say when
> that'll be, but here's a patch that may work for you...
> (Might need to be applied by hand to your Makefile.PL)
>
> Please (everyone) let me know if this works for you, or not.
> Thanks.
>
> Tim.
>
> ---dbd-oracle/branches/pythian/Makefile.PL (original)
> +++dbd-oracle/branches/pythian/Makefile.PL Sun Nov 20 14:54:09 2005
> @@ -327,6 +327,31 @@ elsif ($::opt_l and # use -l to enable t
> my $inc = join " ", map { "-I$OH/$_" } @h_dirs;
> $opts{INC} = "$inc -I$dbi_arch_dir";
> }
> +
> +elsif (-e "$OH/rdbms/demo/demo_xe.mk") { #OracleXE
> +
> + print "Looks likeOracleXE\n";
> +
> + fetch_oci_macros("$OH/rdbms/demo/demo_xe.mk");
> + $MK{CCINCLUDES} = '-I$(ICINCHOME)'; # undo odd refinition in demo_xe.mk
> +
> + # From linuxOracleXE(10.2.0):
> + # ICINCHOME=$(ORACLE_HOME)/rdbms/public/
> + # ICLIBHOME=$(ORACLE_HOME)/lib/
> + # ICLIBPATH=-L$(ICLIBHOME)
> + # THREADLIBS=-lpthread [initially -lthread then redefined]
> + # CCLIB=$(ICLIBPATH) -lclntsh $(THREADLIBS)
> + # CCINCLUDES = -I$(ICINCHOME) [see above]
> + # CCFLAGS=$(CCINCLUDES) -DLINUX -D_GNU_SOURCE -D_REENTRANT -g [initially without -DLINUX -D_GNU_SOURCE]
> + my $cclib = expand_mkvars($MK{CCLIB}, 0, 1);
> + my $ccflags = expand_mkvars($MK{CCFLAGS}, 0, 1);
> +
> + $linkwith_msg = "$cclib";
> + $opts{LIBS} = [ $cclib ];
> + $opts{INC} = "-I$dbi_arch_dir $ccflags";
> + $opts{dynamic_lib} = { OTHERLDFLAGS => "$::opt_g" };
> +}
> +
> # --- special case forOracle10g instant client
>
> elsif (-e "$OH/libclntsh.so.10.1") {
Hi Tim,
I am a great fan, thanks for all your hard work over the years.
I am running suse 10.2, a dump of the environment shows
CPU=x86_64
MACHTYPE=x86_64-suse-linux
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ser ver
perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=linux, osvers=2.6.18, archname=x86_64-linux-thread-multi
uname='linux eisler 2.6.18 #1 smp tue nov 21 12:59:21 utc 2006
x86_64 x86_64 x86_64 gnulinux '
config_args='-ds -e -Dprefix=/usr -Dvendorprefix=/usr -
Dinstallusrbinperl -Dusethreads -Di_db -D
i_dbm -Di_ndbm -Di_gdbm -Duseshrplib=true -Doptimize=-O2 -fmessage-
length=0 -Wall -D_FORTIFY_SOURCE=
2 -g -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=define use64bitall=define uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -
DDEBUGGING -fno-strict-aliasi
ng -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64',
optimize='-O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g -
Wall -pipe',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -
DDEBUGGING -fno-strict-aliasing -pipe
-Wdeclaration-after-statement'
ccversion='', gccversion='4.1.2 20061115 (prerelease) (SUSE
Linux)', gccosandvers=''
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define,
longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib64'
libpth=/lib64 /usr/lib64 /usr/local/lib64
libs=-lm -ldl -lcrypt -lpthread
perllibs=-lm -ldl -lcrypt -lpthread
libc=/lib64/libc-2.5.so, so=so, useshrplib=true,
libperl=libperl.so
gnulibc_version='2.5'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -
Wl,-rpath,/usr/lib/perl5/5.8.8
/x86_64-linux-thread-multi/CORE'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib64'
Characteristics of this binary (from libperl):
Compile-time options: DEBUGGING MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP THREADS_HAVE_PIDS
USE_64_BIT_ALL
USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
USE_PERLIO USE_REENTRANT_API
Built under linux
Compiled at Nov 25 2006 11:02:03
@INC:
/usr/lib/perl5/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/5.8.8
/usr/lib/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8
/usr/lib/perl5/vendor_perl
I installed oracle XE via the RPM file oracle-xe-10.2.0.1-1.0.i386.rpm
the install worked fine and oracles apex web environment accesses the
sample database just fine from apache.
I had this installed on my previous machine running suse 10.1 which
was 32 bit.
In that case the DBD Oracle Module worked fine.
I tried unsuccessfully to build the DBD::Oracle on my current 64 bit
environment
I applied your patch to the Makefile and ran with the following
results:
# perl Makefile.PL
Using DBI 1.52 (for perl 5.008008 on x86_64-linux-thread-multi)
installed in /usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-
multi/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on linux (x86_64-linux-
thread-multi)
Remember to actually *READ* the README file! Especially if you have
any problems.
Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Looks like Oracle XE
Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/
demo_xe.mk
Checking for functioning wait.ph
Constant subroutine __USE_POSIX undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 8.
Constant subroutine __USE_POSIX2 undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 9.
Constant subroutine __USE_POSIX199309 undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 10.
Constant subroutine __USE_POSIX199506 undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 11.
Constant subroutine __USE_XOPEN undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 12.
Constant subroutine __USE_XOPEN_EXTENDED undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 13.
Constant subroutine __USE_UNIX98 undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 14.
Constant subroutine __USE_LARGEFILE undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 16.
Constant subroutine __USE_LARGEFILE64 undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 17.
Constant subroutine __USE_FILE_OFFSET64 undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 18.
Constant subroutine __USE_BSD undefined at /usr/lib/perl5/vendor_perl/
5.8.8/x86_64-linux-thread-multi/features.ph line 19.
Constant subroutine __USE_SVID undefined at /usr/lib/perl5/vendor_perl/
5.8.8/x86_64-linux-thread-multi/features.ph line 20.
Constant subroutine __USE_MISC undefined at /usr/lib/perl5/vendor_perl/
5.8.8/x86_64-linux-thread-multi/features.ph line 21.
Constant subroutine __USE_GNU undefined at /usr/lib/perl5/vendor_perl/
5.8.8/x86_64-linux-thread-multi/features.ph line 23.
Constant subroutine __USE_REENTRANT undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 24.
Constant subroutine _POSIX_SOURCE undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 49.
Constant subroutine _POSIX_C_SOURCE undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 51.
Constant subroutine _XOPEN_SOURCE undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 53.
Constant subroutine _XOPEN_SOURCE_EXTENDED undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 55.
Constant subroutine _LARGEFILE64_SOURCE undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 57.
Constant subroutine _LARGEFILE_SOURCE undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 104.
Constant subroutine __GNU_LIBRARY__ undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/features.ph line 156.
Scalar found where operator expected at (eval 213) line 1, near
"'int' $__val"
(Missing operator before $__val?)
Hexadecimal number > 0xffffffff non-portable at (eval 244) line 1.
Hexadecimal number > 0xffffffff non-portable at (eval 245) line 1.
Constant subroutine __need_timeval undefined at /usr/lib/perl5/
vendor_perl/5.8.8/x86_64-linux-thread-multi/bits/time.ph line 23.
System: perl5.008008 linux eisler 2.6.18 #1 smp tue nov 21 12:59:21
utc 2006 x86_64 x86_64 x86_64 gnulinux
Compiler: cc -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g -
Wall -pipe -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -
fno-strict-aliasing -pipe -Wdeclaration-after-statement -
D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -ldl -lm -lpthread -lnsl -lirc
Oracle makefiles would have used these definitions but we override
them:
CC: /usr/bin/g++296
LDFLAGS: -g
[-g]
Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
lib/ -lclntsh -lpthread
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ser ver/lib
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.52 (for perl 5.008008 on x86_64-linux-thread-multi)
installed in /usr/lib/perl5/vendor_perl/5.8.8/x86_64-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.txt files.
(Of course, you have read README by now anyway, haven't you?)
and yes I did read the README
running make however gives me the same error as before:
# make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/lib/perl5/vendor_perl/
5.8.8/x86_64-linux-thread-multi/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap /usr/lib/
perl5/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc
&& mv Oracle.xsc Oracle.c
cc -c -I/usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /
auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/
public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -
D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -
pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2
-g -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/
usr/lib/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-
comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\"
Oracle.c
cc -c -I/usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /
auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/
public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -
D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -
pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2
-g -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/
usr/lib/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-
comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\"
dbdimp.c
dbdimp.c: In function ?ora_db_login6?:
dbdimp.c:700: warning: value computed is not used
dbdimp.c: In function ?dbd_rebind_ph_char?:
dbdimp.c:1110: warning: value computed is not used
dbdimp.c: In function ?ora_st_execute_array?:
dbdimp.c:1985: warning: value computed is not used
cc -c -I/usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /
auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/
public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -
D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -
pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2
-g -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/
usr/lib/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-
comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\"
oci8.c
oci8.c: In function ?fetch_func_rset?:
oci8.c:652: warning: value computed is not used
oci8.c: In function ?dbd_rebind_ph_lob?:
oci8.c:748: warning: value computed is not used
oci8.c:779: warning: value computed is not used
oci8.c: In function ?ora_blob_read_mb_piece?:
oci8.c:889: warning: comparison is always false due to limited range
of data type
oci8.c: In function ?ora_describe?:
oci8.c:1391: warning: comparison is always false due to limited range
of data type
oci8.c: In function ?post_execute_lobs?:
oci8.c:2246: warning: value computed is not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/se rver/lib"
cc -shared -L/usr/local/lib64 Oracle.o dbdimp.o oci8.o -o blib/arch/
auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -
lclntsh -lpthread \
/usr/lib64/gcc/x86_64-suse-linux/4.1.2/../../../../x86_64-su se-linux/
bin/ld: skipping incompatible /usr/lib/oracle/xe/app/oracle/product/
10.2.0/server/lib//libclntsh.so when searching for -lclntsh
/usr/lib64/gcc/x86_64-suse-linux/4.1.2/../../../../x86_64-su se-linux/
bin/ld: cannot find -lclntsh
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/Oracle/Oracle.so] Error 1
The sym links are there pointing to the correct .so file for
libclntsh.so.
But the linker indicates that this library is incompatible.
I am not sure where to proceed from here.
Any help would be appreciated.
-- jim
----- End forwarded message -----
Re: (Fwd) Re: DBD::Oracle won"t install for Oracle 10G XE
am 17.08.2007 15:58:01 von hjp
--B0nZA57HJSoPbsHY
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On 2007-08-14 09:53:33 +0100, Tim Bunce wrote:
> ----- Forwarded message from lr@neukat.com -----
>=20
> X-IP: 216.150.208.7
> From: lr@neukat.com
> To: Tim Bunce
> Subject: Re: DBD::Oracle won't install for Oracle 10G XE
> Date: Mon, 13 Aug 2007 22:42:59 -0700
> X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US;
> rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe)
>=20
> perl -V
> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
> Platform:
> osname=3Dlinux, osvers=3D2.6.18, archname=3Dx86_64-linux-thread-multi
^^^^^^
> I installed oracle XE via the RPM file oracle-xe-10.2.0.1-1.0.i386.rpm
^^^^
> But the linker indicates that this library is incompatible.
You cannot link a 32 bit library (i386) to a 64 bit executable (x86_64).
You need to get a 64-bit version of oracle client (or a 32 bit version
of perl). AFAIK the express edition is only available for 32 bit linux,
so you need to get a standard or enterprise edition.
I just got 10201_client_linux_x86_64.cpio (whatever that is :-)) to
work. It needs two extra libraries in LDLOADLIBS:
LDLOADLIBS =3D -L/ora/app/oracle/product/client/lib -lclntsh -ldl -lm -lpth=
read -lnsl -lirc -lnnz10 -ln10
but I haven't yet figured out a patch for Makefile.PL ...
hp
--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
--B0nZA57HJSoPbsHY
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGxalpMdFfQa64PCwRAjfTAJoCJJc5pL/oYlM18cDYpWRJBr27HgCf XpxW
IhfZARk7WhAOVmtFvPHL6WY=
=2ok3
-----END PGP SIGNATURE-----
--B0nZA57HJSoPbsHY--
Re: (Fwd) Re: DBD::Oracle won"t install for Oracle 10G XE
am 22.08.2007 06:01:02 von LR
Peter,
The following URL's did the trick on my SuSE 10.2.
Although the white paper was for the 32 bit version the screens were
nearly identical for the 64 bit installer.
Hope this helps anyone out there with similar problems.
http://www.oracle.com/technology/software/products/database/ oracle10g/htdocs/10201linuxsoft.html
http://en.opensuse.org/Oracle_on_openSUSE
http://ftp.novell.com/partners/oracle/docs/10gR2_openSUSE102 _introduction.pdf
Once the x86_64 bit version was installed the DBD::Oracle module was
easily installed.
Peter J. Holzer wrote:
> On 2007-08-14 09:53:33 +0100, Tim Bunce wrote:
>> ----- Forwarded message from lr@neukat.com -----
>>
>> X-IP: 216.150.208.7
>> From: lr@neukat.com
>> To: Tim Bunce
>> Subject: Re: DBD::Oracle won't install for Oracle 10G XE
>> Date: Mon, 13 Aug 2007 22:42:59 -0700
>> X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US;
>> rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe)
>>
>> perl -V
>> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
>> Platform:
>> osname=linux, osvers=2.6.18, archname=x86_64-linux-thread-multi
> ^^^^^^
>> I installed oracle XE via the RPM file oracle-xe-10.2.0.1-1.0.i386.rpm
> ^^^^
>
>> But the linker indicates that this library is incompatible.
>
> You cannot link a 32 bit library (i386) to a 64 bit executable (x86_64).
> You need to get a 64-bit version of oracle client (or a 32 bit version
> of perl). AFAIK the express edition is only available for 32 bit linux,
> so you need to get a standard or enterprise edition.
>
> I just got 10201_client_linux_x86_64.cpio (whatever that is :-)) to
> work. It needs two extra libraries in LDLOADLIBS:
>
> LDLOADLIBS = -L/ora/app/oracle/product/client/lib -lclntsh -ldl -lm -lpthread -lnsl -lirc -lnnz10 -ln10
>
> but I haven't yet figured out a patch for Makefile.PL ...
>
> hp
>
>
Re: (Fwd) Re: DBD::Oracle won"t install for Oracle 10G XE
am 22.08.2007 10:05:25 von hjp
--envbJBWh7q8WU6mo
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On 2007-08-21 22:01:02 -0600, jim wrote:
> The following URL's did the trick on my SuSE 10.2.
> Although the white paper was for the 32 bit version the screens were near=
ly=20
> identical for the 64 bit installer.
> Hope this helps anyone out there with similar problems.
> http://www.oracle.com/technology/software/products/database/ oracle10g/htd=
ocs/10201linuxsoft.html
Nope. That's the 32 bit version. The 64 bit version is at
http://www.oracle.com/technology/software/products/database/ oracle10g/htdoc=
s/10201linx8664soft.html
Which version did you install?
The database (10201_database_linux_x86_64.cpio.gz)
or the client (10201_client_linux_x86_64.cpio.gz)?=20
I got the client. It is possible that the directory layouts are somewhat
different and that Makefile.PL can cope with one but not the other.
And as I said, I got it to work, I just needed to add two libraries to
the Makefile manually because Makefile.PL didn't pick them up
automatically. So my mail was supposed to serve two purposes:
* Document the needed tweaks so that other people who want to build
DBD::Oracle against the 10.2. oracle client don't need to hunt around
for the correct libraries.
* Inform the maintainers of the needed changes so that they can fix it
in the next release.
hp
--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
--envbJBWh7q8WU6mo
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGy+5FMdFfQa64PCwRArz3AJ9zINW5mJ9UWYbFaW57MkoHxGw7lwCf VzZS
4x4oa5lSkNf33Bir1vo9LvU=
=h8gL
-----END PGP SIGNATURE-----
--envbJBWh7q8WU6mo--