Re: Creating db with multiple homes

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 - 12:32:23 CDT