Re: Announce DBD::Oracle 1.21

On Tue, 29 Apr 2008 08:40:41 -0400, John Scoles <[email protected]>
wrote:

> Thanks  Merijn
> 
> That will defiantly make it into the next release. I will try to get it 
> into trunk later this week

A few more notes

1. On a 64bit machine, I got these rpm's:

   oracle-instantclient-basic-11.1.0.1-1.x86_64.rpm
   oracle-instantclient-devel-11.1.0.1-1.x86_64.rpm
   oracle-instantclient-jdbc-11.1.0.1-1.x86_64.rpm
   oracle-instantclient-odbc-11.1.0.1-1.x86_64.rpm
   oracle-instantclient-sqlplus-11.1.0.1-1.x86_64.rpm

   and to add to the confusement, they install to

   /usr/include/oracle/11.1.0.1/client64
   /usr/lib/oracle/11.1.0.1/client64
   /usr/share/oracle/11.1.0.1/client64

   Oh, joy!

   Additional patch below (applies over previous patch)

2. Test results are the same

3. I added a note about "lsnrctl" under point 3 in my personal note.
   Guess that would help others too:

   Real world example changed to hide the obvious. Important bits are
   "ODBCO", which is the ODBC name, and it can be anything, as long as
   you use this in ORACLE_DSN too (please don't use whitespace, colons,
   semicolons and/or slashes. "rhost" is the hostname of where the DB
   is running, and "odbctest" is available on "rhost". To check that,
   run "lsnrctl services" on "rhost".


--8<--- Makefile.PL-64.diff
--- Makefile.PL.new     2008-04-29 16:52:27.000000000 +0200
+++ Makefile.PL 2008-04-29 16:50:22.000000000 +0200
@@ -1093,7 +1093,8 @@ sub find_mkfile {
        'rdbms/demo/demo_rdbms.mk',
     );
     $iclient_version and push @mk_proc,        # Oracle Instant Client
-       "/usr/share/oracle/$iclient_version/client/demo.mk";
+       "/usr/share/oracle/$iclient_version/client/demo.mk",
+       "/usr/share/oracle/$iclient_version/client64/demo.mk";
     my @mkplaces = ($::opt_p) ? (@mk_proc,@mk_oci) : (@mk_oci,@mk_proc);
     if ($::opt_m) {
        $::opt_m = cwd()."/$::opt_m" unless $::opt_m =~ m:^/:;
@@ -1460,6 +1461,7 @@ sub find_headers {
        "/include/oracle/$client_version_full/client", # Instant Client for RedHat FC3
        "/include/oracle/$client_version_trim/client", # Instant Client for RedHat FC3
        "/usr/include/oracle/$iclient_version/client", # Instant Client 11.1 and up
+       "/usr/include/oracle/$iclient_version/client64", # Instant Client 11.1 and up
    );
    unshift @try, $::opt_h if $::opt_h;
    @try = grep { -d $_ } @try;
-->8---

-- 
H.Merijn Brand         Amsterdam Perl Mongers (http://amsterdam.pm.org/)
using & porting perl 5.6.2, 5.8.x, 5.10.x  on HP-UX 10.20, 11.00, 11.11,
& 11.23, SuSE 10.1 & 10.2, AIX 5.2, and Cygwin.       http://qa.perl.org
http://mirrors.develooper.com/hpux/            http://www.test-smoke.org
                        http://www.goldmark.org/jeff/stupid-disclaimers/