RE: What are the implications of having several instances on a server sharing the oracle home?
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <achoto@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Sep 2004 14:57:20 -0400
Multiple database instances from one Oracle Home is just fine. I can't =
think on a single server we have that has more than one home per version =
and their all running multiple databases. The king of the hill (Dudley, =
a HP-9000/N4000 HP-UX) has 16 instances(peoplesoft), at last count.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Ana Choto [mailto:achoto@xxxxxxxxxxxx]
Sent: Wednesday, September 29, 2004 2:13 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: What are the implications of having several instances on a
server sharing the oracle home?
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
