Advice:
1) Build and install the 8.1.7 version as you normally do.
2) Modify your environment as follows (assuming Perl 5.6.1, UNIX and Bourne or
similar shell)
PERL5LIB=/opt/perl_dbd_oracle_920/lib/5.6.1:/opt/perl_dbd_oracle_920/lib/site_perl:$PERL5LIB
export PERL5LIB
3) Set your ORACLE_HOME and other envvars to the 9.2.0 settings.
4) Build a fresh DBI, DBD::Oracle against 9.2.0 and a fresh copy of all other
DBDs you use. I suggest you copy the tarballs to another directory from where
you usually build them. When you do the install part use this command:
make install PREFIX=/opt/perl_dbd_oracle_920
or chose another directory with whatever name and location you like. Just make
sure to specify a PREFIX or else you'll overwrite the 8.1.7 version you
installed in the default location. Furthermore DON'T USE /usr/local, or whatever
the default is on your system, as the value for PREFIX. The idea is to isolate
the 9.2.0 stuff and its relatives.
5) When you need to use the 9.2.0 version in Perl script, do steps 2 & 3 before
you run the script.
If you really want to get adventurous, only build and install DBD::Oracle in
step 4 and see if it will play nice with the default DBI.
---------------------------------------------------------------------------
Matthew Persico
Vice President
Lazard
30 Rockefeller Plaza
New York, NY 10020, USA
Phone Number: 212.632.8255
Fax Number: 212.332.5904
Email: [EMAIL PROTECTED]
---------------------------------------------------------------------------
To: [EMAIL PROTECTED]
"Tim Bunce" cc: [EMAIL PROTECTED]
<[EMAIL PROTECTED]> Subject: (Fwd) Dual DBD::Oracle install
on same box
01 Jul 2003 05:36 AM
----- Forwarded message from "Morton-Allen, Matt" <[EMAIL PROTECTED]>
-----
Delivered-To: [EMAIL PROTECTED]
Subject: Dual DBD::Oracle install on same box
Date: Tue, 1 Jul 2003 13:54:30 +1000
From: "Morton-Allen, Matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
X-Scanned-By: MIMEDefang 2.21 (www . roaringpenguin . com / mimedefang)
Hi Tim,
As keeper of the DBD::Oracle CPAN module I was wondering if you could
offer a quick word of advice on the possibility of building two
DBD::Oracle installs on the same machine. One of our production Solaris
machines has both an Oracle 8.1.7 and an Oracle 9.2.0 install on it and
we cannot get them to play nice.
We can only seem to manage SQL*Net connections to the 8.x's when using 9
libraries and vice versa and the SQL*Net connections are placing a large
overhead on each hit. A logical solution to this seems to be to build to
a "standard" DBD::Oracle for 8 connections (there's more 8 installs than
9 at the moment) and then build a second one against the 9.2.0 DB and
keep it outside the normal tree.
So what do you think? I'd be very interested in any comments/suggestions
you might have on the wisdom of this idea.
Thanks in advance,
Matt.
===============================
Matt Morton-Allen
[EMAIL PROTECTED]
Analyst Programmer - Web Applications
Charles Sturt University
Australia
===============================
----- End forwarded message -----
