RE: DBD-Oracle and Oracle versions



Paula,

Unless you are keeping the older versions of Oracle on the system, I
would definitely rebuild both DBD::Oracle and DBI when moving to a new
client.

I'm not a Windows guy, but if you install DBD::Oracle under a 9.2 client
and then remove that client, replacing it with a 10.2 client, doesn't
the DBD::Oracle stop working?

Just my $0.02 worth.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Capacio, Paula J [mailto:PCAPACIO@xxxxxxxxx]
Sent: Tuesday, December 19, 2006 1:16 PM
To: dbi-users@xxxxxxxx
Subject: DBD-Oracle and Oracle versions

From lurking around this mail list over the years,
I've seen numerous items relating to building
DBD-Oracle against a specific version of the Oracle
client software on *nix systems.

Example: if DBD-Oracle was built using version 9,
then the Oracle client is upgraded to 10g;
it is necessary to rebuild DBD-Oracle with the 10g client.

I have used Perl on HP/UNIX, AIX, Linux and Windows.
On the *nix systems, Perl came with the OS and I have
had to install the DBI and DBD-Oracle modules using
the standard make process. On windows, I used
ActiveState Active Perl and PPM to install DBI and
DBD-Oracle modules. In the windows environment I
never have to worry about which version of the Oracle
client is present and I can upgrade to a different
client version of Oracle without having to reinstall
the DBD-Oracle module.

What trick allows PPM modules to work regardless of
Oracle client versions? Ultimately, I'd like to know
if there is a way to 'make' the modules on *nix systems
so that they don't rely on a specific version?

Thanks in advance,
Paula

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.



Relevant Pages

  • DBD-Oracle and Oracle versions
    ... DBD-Oracle against a specific version of the Oracle ... client software on *nix systems. ... had to install the DBI and DBD-Oracle modules using ...
    (perl.dbi.users)
  • Re: DBD-Oracle and Oracle versions
    ... DBD-Oracle against a specific version of the Oracle ... client so you change you client you have to rebuild your DBD::Oracle ... I have used Perl on HP/UNIX, AIX, Linux and Windows. ...
    (perl.dbi.users)
  • Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch wont install
    ... Currently all my Oracle inst client files are user oracle group oinstall yet lib bin and other dirs have 755 permission so root should be able to access and execute these softlibs. ... As I have written, I have installed DBD::Oracle-1.19 many times with a full client without problem, yet with the limited instant client it does not find the mk file, and the one mk file that the instant client installs does not work. ... It also gives me a makefile for DBD::Oracle but install and test fail ...
    (perl.dbi.users)
  • Re: DBD::Oracle / Instant Client segfaults
    ... I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. ... When i run the script with the 'use Digest::SHA1;' line commented ...
    (perl.dbi.users)
  • Re: ORATCL help needed!
    ... set cursor ... Wow, An Oratcl 3.3. ... It is coded with the the OCI layer released with Oracle ... Oracle instant client is available for many many platforms, ...
    (comp.lang.tcl)