Re: Creating db with multiple homes

I believe James is correct. One thing to be carefull with is the PATH enviroment on NT. I installed Oracle 8i and the Enterprise manager on my development machine and noticed that the order of the oracle homes in the PATH effects certain applications. I would be extra cautious running different versions!

The behaviour I saw was that then TNS entries under the EM home were getting hit but not the ones under my DB home. This was due to the pathing and apparently
relative pathing oracle does to get to tnsnames.ora

I simply switched the order of the homes in the system PATH to resolve this.

John

James Hanway <hanwayj_at_dfo-mpo.gc.ca> wrote in message news:380F4E40.36223409_at_dfo-mpo.gc.ca...
> I am sure I will be corrected on this if I am wrong, but essentially,
> everything hinges on the value of the variable ORACLE_HOME , that is the
> directory where the current oracle software is to sit. You can have
> multiple versions of oracle installed on your system, but just make sure
> you have your ORACLE_HOME setting pointing to the directory of where you
> installed the latest product
>
> Ed Stevens wrote:
>
> > We have a total of 7 NT servers, each hosting multiple Oracle
> > databases. Most of them are running 8.0.5, while one is running 7.4
> > and 8.0.5 and one test machine is running 8.0.5 and 8.1.5. I have been
> > somewhat out of the picture for all of the 8.x work, and the DBA who
> > did the 8.x installations is gone. Now I have been tasked with
> > upgrading all of our 8.0 databases to 8.1.5 (8i). I am pretty confused
> > over how these multiple homes work (see other postings I've made today
> > regarding multiple homes at the client end). With both 8.0 and 8.1
> > installed on a server (or worse, with these two in addition to 7.4)
> > how does one distinguish between creating an 8.0 database vs. creating
> > an 8.1 database? What is it exactly that makes a database one version
> > or the other? With software for multiple versions installed on a
> > server, how does database startup and operation distinguish which is
> > correct for a given database?
> >
> > If all these questions are answered in a fairly direct way in the fine
> > manual(s) just point me to where. If not, all input is appreciated.
> >
> > - Ed Stevens
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
Received on Thu Oct 21 1999 - 13:09:42 CDT