Re: Multiple Instance = Multiple Homes (Oracle 9.2) Confused...

If you use the Oracle Installer to create a new *database*, then you are using a sledgehammer to crack a nut. The Database Configuration Assistant is what you're after, and it won't ask you about an Oracle Home.

You need to get the concepts clear first: you are creating a new database, which happens to require a second Instance to run it. You are not performing a fresh install of the Oracle executables. So use the right tool for the right job.

Regards
HJR "Andy" <andybush2003_at_yahoo.com> wrote in message news:bb3692fe.0305071250.60ff01c5_at_posting.google.com...
> Ok,
>
> I tried it.. but something confusing happens....
>
> In OUI when you choose the same Home, it never asks you for a new SID
> for the new database, instead the installation options in the end show
> up as "Reinstallation", now if you choose a new home for creating the
> 2nd instance, then the screen comes up which asks about the SID etc...
>
> Thanks
>
> "Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message
news:<3eb82071$0$49101$e4fe514c_at_news.xs4all.nl>...
> > Andy <andybush2003_at_yahoo.com> schreef in berichtnieuws
> > bb3692fe.0305061241.64a8bab3_at_posting.google.com...
> > | I would like to install multiple instances on my system. I am
> > | installing Oracle 9.2 on Win2K system.
> > |
> > | 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.....)
> > |
> > | Thanks
> >
> > You can create as many instances as you want in one oracle home (given
the
> > resources).
> > It's obvious all databases in one home must all run the same version and
> > patch level.
> > In other words: when you apply a patch, you must also patch all
databases.
> > You can have multiple oracle homes in one machine.
> > You can move databases from one home to another home (if the
> > upgrade/downgrade path is supported).
> > Applies for Windows 98/ME/2K/XP (V8 and higher) and Unix and VMS systems
for
> > standard and enterprise edition.
Received on Thu May 08 2003 - 06:13:09 CDT