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/
