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

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 <charding@xxxxxxxx>  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. --
.

Relevant Pages

  • Re: MS02-018 Breaking ASP ODBC
    ... > after installing the latest security hotfixes as of April ... >>1) IIS 5 web server can't be contacted. ... >>before the patch and that fixed that problem. ... >>load some VB components that fail to connect to my Oracle ...
    (microsoft.public.inetserver.iis.security)
  • Re: question about oracle advisory
    ... assistance request) to ask that they make the patch available for 8i, ... database account and the create library privilege to exploit the bug, ... that showed whether you were vulnerable would be helpful to many Oracle ... > Oracle is not planning on releasing a patch for 8i releases. ...
    (Bugtraq)
  • Re: Oracle 8.1 on AIX 5.3
    ... On the question of whether to wait for the patch: ... I believe increasing those numbers are for bypassing the Oracle bug, ... There is a notorious bug in Oracle 8 - 9 that requires that the AIO request ... if you have 4 CPUs with 300 AIOs per CPU ...
    (AIX-L)
  • Re: question about oracle advisory
    ... fact I demonstrated exploit code for this vulnerability at the Blackhat ... Security Breifings in Amsterdam in the May of this year. ... do such demonstrations unless a patch is available for a problem. ... We initially informed Oracle about this issue ...
    (Bugtraq)
  • Revision: Multiple Critical and High Vulnerabilities in Oracle Database Server
    ... Having downloaded and given the Oracle October patch a cursory examination, ... some of the flaws Oracle told me were being fixed, ... > critical and high risk vulnerabilities in the Oracle Database Server. ...
    (Bugtraq)