DBD::Oracle won't install for Oracle 10G XE

[Anup Singh]

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/demo/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
_______________________________________________________________________

[sco...@pythian.com]

Thoug it hasn't been tested for 10G XE you might want to try this
Makefile

http://svn.perl.org/modules/dbd-oracle/branches/pythian

Your best bet is to install the instantcleint 4 first though.

[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") {

[Chuck Harding]

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.

--
Charles D. (Chuck) Harding <char...@llnl.gov> 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. --

[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.