Re: Does changing ORACLE_HOME affect DBI?



Long answer Yes with a maybe; Short answer No with a But.

All joking aside it would be a good idea to recompile DBD::Oracle when you Oracle home changes only because this usually means they (DBAs,SAs) have changed the client, Version or something else in your Oracle. So to keep everything in sync I would recompile.

That being said once DBD::Oracle is compiled is should be somewhat stand alone and not rely on the oracle client directly anymore. So changing the the Home shouldn't matter.

Cheers John Scoels

RICHARD FERNANDEZ wrote:
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
.



Relevant Pages

  • Re: Oracle error when i use System.Data.OracleClient 1.0.5000.0
    ... and Oracle is trying to automatically recompile it. ... that is using this package - it might not appear directly in your code. ... I don't think this particular error has anything to do with the provider ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: how to access oracle from php4
    ... with php4 already installed. ... Anyone with an advic on how to use oracle with php. ... You do not have to recompile PHP. ...
    (comp.lang.php)
  • Re: how to access oracle from php4
    ... googling...php will have to be recompiled with oracle support. ... Anyone with an advic on how to use oracle with php. ... Normally you don't have to recompile to get Oracle working. ... What you normally do is install the Oracle client, ...
    (comp.os.linux.misc)
  • Re: Recompiling invalid objects in PL/SQL
    ... In article, Frank van Bortel ... > Apart from all the good examples, do you realize Oracle will ... > recompile on an 'as needed' base? ...
    (comp.databases.oracle.server)
  • Re: how to access oracle from php4
    ... googling...php will have to be recompiled with oracle support. ... Anyone with an advic on how to use oracle with php. ... Normally you don't have to recompile to get Oracle working. ... What you normally do is install the Oracle client, ...
    (comp.os.linux.misc)