Thanks a bunch. That was the link I was missing. I have it all setup now.
Hans Forbrich <forbrich_at_telusplanet.net> wrote in message news:<3EB95C45.DAB3300A_at_telusplanet.net>...
> Andy wrote:
>
> > I would like to install multiple instances on my system. I am
> > installing Oracle 9.2 on Win2K system.
>
> Not unusual
>
> > Do I have to create a seperate home for each instance of can you have
> > multiple instances per Oracle Home (in other words does installing a
> > new instance also mean installing another set of software product
> > files.....)
>
> No
>
> > Thanks
>
> Oracle HOME is used to separate the executables ... thus you can have an
> OH for each version of the product. This has virtually nothing to do
> with the instance other than providing a {sic] home for the executable of
> the instance.
>
> Oracle Instance is a running copy of the set of Oracle executables that
> is using CPU and Memory to manage access to an Oracle Database. You can
> have many instances using one OH.
>
> So on one machine, you can have several Oracle Homes, each of which
> provides the s/w to run several Oracle Instances, each capable of
> supporting several Schemas, each in turn capable of holding several
> tables (and other database objects).
>
> This fascinating subject is explored in depth in the Concepts manual
> found at http://tahiti.oracle.com - great place to start.
Received on Fri May 09 2003 - 17:39:52 CDT
