Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: two databases in a server

Re: two databases in a server

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 31 Mar 2006 23:08:52 +0200
Message-ID: <c2213f680603311308o78adba05i9dd059def84c2c86@mail.gmail.com>


Tom,

Well, we can afford that luxury only on our test systems - for example, we are running 40 DBs (RAC and non-RAC) on a two HP Superdome nodes cluster. These are not development machines and have their SLA's. We have had several situations when the whole node (or even cluster) is stuck and required us to reset it. From time to time, one of databases goes a bit wild impacting others. We can live with those kind of problems but not in real production environment.

Production nodes have usually less than 5 DBs. Recently, we've had to split one of our clusters as it had grown too much and too complex causing instability so we are moving several DBs away.

On development side, I know that they are sharing one (or very few) database for many teams and this works ok.

In the end - no one size fits all.

Cheers,
Alex

2006/3/31, Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us
>:
>
> Alex,
>
>
>
> This is funny. What you call extreme I call normal. I have an IBM AIX
> p570 as a development machine with 15 Oracle databases on it. And a P690
> with twice that. Right now they all share the same Oracle home (although we
> are finally applying the January security patches using a new Oracle home).
>
>
>
> Very stable. Reboot time is what I would call normal (less than 1
> minute). The databases are always available never down.
>
>
>
> So I guess I disagree with your assessment. The big machines (in my view)
> are the better machines for me.
>
>
>
> Tom
>
>
> ------------------------------
>
> *From:* Alex Gorbachev [mailto:gorbyx_at_gmail.com]
> *Sent:* Thursday, March 30, 2006 3:42 PM
> *To:* Mercadante, Thomas F (LABOR)
> *Cc:* MFontana_at_verio.net; roger_xu_at_dp7uptx.com; Oracle-L_at_Freelists. Org
> (E-mail)
>
> *Subject:* Re: two databases in a server
>
> --
>
>
>
> Hi Tom,
>
>
>
> These are two extreme.
>
> - 30 servers with two DB's - too much efforts unless proper software
> management/deployment method plus monitoring is implemented.
> - Having 30 DB's on single machine is another extreme because one
> going "crazy" will impact others. Monitoring can be also a bit more
> difficult in this case. Also big machines with many DBs and many disks are
> less stable and boot time can be quite high in case it goes down or needs to
> be rebooted.
>
> I would prefer in this case something in the middle - like 5 machines
> each hosting 6 DBs. Here you can flexibility to group them to get more
> convenient maintenance windows as well as limit system outage impact.
>
>
>
> Cheers,
>
> Alex
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 31 2006 - 15:08:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US