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

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
> To: dbi-users@perl.org
> 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

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
>

RE: Does changing ORACLE_HOME affect DBI?

> All joking aside it would be a good idea to recompile=20
> DBD::Oracle when you Oracle home changes only because this=20
> usually means they (DBAs,SAs) have changed the client,=20
> Version or something else in your Oracle. So to keep=20
> everything in sync I would recompile.
>=20
> That being said once DBD::Oracle is compiled is should be=20
> somewhat stand alone and not rely on the oracle client=20
> directly anymore. So changing the the Home shouldn't matter.
>=20
> Cheers John Scoels
>=20

Thanks, John and Mike for your responses.=20
I'll pass this along to the Powers That Be :)

richf