Re: multiple databases in a single RAC cluster
Date: Tue, 11 Nov 2008 23:39:07 -0500
Thanks Matt, wondering if there are any specific white papers ( I couldn't find any)
Im thinking this would be a very complex configuration ie
asm disk separation - per database -
data guard DR for multiple databases....
the interconnect would really take a beating...probably needing nics for each database...
I mean that sounds like a "very" complex.
The client here is looking to save allot of money by consolidating environments of 15 databases on single servers with active passive veritas clusters - moving them to rac
The strategy is to save money (hardware and support) - I'm just not feeling it...
Im looking for some white papers for this type of configuration, and feedback for costs.
To me rac is excellent for a single database with the need for extremely high level of connections (amazon type, banking, financial), and high availability, but mixing many disparate (1-4 single application) databses into a cluster to save money just dosnt make sense.
Matthew Zito wrote:
> Yes, absolutely, we have one customer who has an 8 node RAC cluster that's running 12 databases, each with between 2 and 8 instances, and a pile of other customers with 2-4 node clusters with multiple databases. I'm sure there's some internal limitations as to the number of services that can be registered in the CRS, but I doubt many people run into it.
> Matthew Zito
> Chief Scientist
> GridApp Systems
> P: 646-452-4090
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org on behalf of Bob
> Sent: Tue 11/11/2008 9:12 PM
> To: oracle-l
> Subject: multiple databases in a single RAC cluster
> Hi, As much as Ive been browsing / studying rac... Im looking for a
> definitive answers about how many "databases" can be on one rac cluster.
> Say I want to have 4 independent databases on one cluster, is that
> possible? I understand one can easily have multiple instances pointing
> to a single database (sga, control_file, db_name, spfile, archive_dest,
> etc) but what about several independent databses?
> Any documents referencing this?
> I found this on ask tom... just wanted to confirm with this group,
> probably in a more concise manner.
> So, How many databases (sga, control_file, db_name, spfile,
> archive_dest, etc) can be in a single rac cluster?