Re: What are the implications of having several instances on a server sharing the oracle home?

If sufficient resources are available as you explained, one Oracle Home is fine regardless of number of instances. I never seen any contention in binaries. In case of upgrades when all instances can not be upgraded at one time due vendors restriction/certification, a separate Oracle Home can be justified.

Regards
Rafiq

On Wed, 29 Sep 2004 14:13:20 -0400, Ana Choto <achoto_at_american.edu> wrote:
> My boss thinks that this could cause problems. I say it's OK to have, say
> three Oracle instances (or more) sharing the binaries, as long as we have
> enough memory and space. He thinks we should install the software for each
> instance to alleviate contention for the binaries. Space is not an issue
> for him. The problem with this setting is that I will have to apply
> patches to all of them.
>
> I have on a server four databases, three of them share the binaries, they
> are on 9iR2, and I also have a 10G instance on its own oracle home. The 9i
> DBs are not heavily used so I can't tell if there is performance issues
> with them. I don't see a problem with the 10G db, although no one but me
> is using it.
>
> On another server I have three databases in their own oracle home. Two
> instances run on 8.1.7.4, one is the datawarehouse and the other one is
> oltp. No performance problems there. Another oltp database (9iR2) resides
> on the server, and I don't see any performance issues there either.
>
> Is someone out there willing to share his/her experiences with any of these
> settings?
>
> Thanks
>
> Ana E. Choto
> American University
> e-Operations - Information Technology
> Phone (202) 885-2275
> Fax (202) 885-2224
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l