Re: Does changing ORACLE_HOME affect DBI?



Hi,

Moving the ORACLE_HOME should not affect the installed DBI. You simply have to point your scripts to the new ORACLE_HOME after it gets moved as long as the version of the oracle in the new home is the same as the versin of the oracle use to compile and install the DBI.

Regards,
Michael


On Fri, 18 Jan 2008, RICHARD FERNANDEZ wrote:

Date: Fri, 18 Jan 2008 09:47:13 -0500
From: RICHARD FERNANDEZ <rfernandez@xxxxxxxxx>
To: dbi-users@xxxxxxxx
Subject: Does changing ORACLE_HOME affect DBI?

Hello folks,

A while back (months and months, in fact) I was asked to install DBI for
use with an Oracle database. As part of the install I remember that I
was asked for the value of things like ORACLE_HOME and some others.

Today I'm told that they want to move ORACLE_HOME to someplace else on
the same box.

My question is:

Does moving ORACLE_HOME mean that I need to recompile DBI, or was that
information only used for testing during the install?

I've never used it myself, so it's kind of a black box. Any hints, docs,
etc would be appreciated.

Thanks much.

BTW, I'm not on the list, so if you could reply to this address (as well
as the list, of course) I would appreciate it. Thanks!

richf



--
---//---
"He who learns must suffer. And even in our sleep,
pain that cannot forget, falls drop by drop upon the heart; and, in our own despair, against our will,
comes wisdom to us by the awful grace of God."
--- Aeschylus
.



Relevant Pages

  • RE: DBI problem
    ... I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from ... DBD 1.16 and DBI 1.48. ... Did you install DBD::Oracle? ...
    (perl.dbi.users)
  • RE: oracle win2k ORA-1222 problems
    ... AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com. ... Oracle is listed as "failed" if I recall correctly. ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • RE: Accessing oracle from windows 2000
    ... You need oracle net8 anyway for odbc so it is likely you will ... just be able to install the activestate DBD::Oracle and DBI. ... > documentation on DBI and I can't find the answers I'm looking for. ...
    (perl.dbi.users)
  • RE: Accessing oracle from windows 2000
    ... I edited the ppd file to use the correct path. ... Bjorn, I already have DBI installed, so I downloaded DBD-Oracle8.zip ... from active state, unpacked it, and tried 'ppm install ... I didn't need any oracle libraries. ...
    (perl.dbi.users)
  • RE: Accessing oracle from windows 2000
    ... Kind regards. ... Bjorn, I already have DBI installed, so I downloaded DBD-Oracle8.zip ... from active state, unpacked it, and tried 'ppm install DBD-Oracle8.ppd' ... I didn't need any oracle libraries. ...
    (perl.dbi.users)