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: Multiple Instances and 9iRAC

RE: Multiple Instances and 9iRAC

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Sat, 15 Mar 2003 04:58:47 -0800
Message-ID: <F001.0056B295.20030315045847@fatcity.com>


We run 4 production databases on one dual node RAC, each node hosting one instance of each database.  

Raj

-----Original Message-----
Sent: Friday, March 14, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L

Sorry I didn't explain the configuration very well- here is what I'm talking about:  

We have an existing HP server currently running 4 instances/databases. Sid1,sid2,sid3,sid4  

Is it advisable to implement RAC for all the databases/sids on this server?  

i.e.  

Cluster1=

Node1= Sid1,sid2,sid3,sid4

Node2= Sid1,sid2,sid3,sid4

Node3= Sid1,sid2,sid3,sid4

Node4= Sid1,sid2,sid3,sid4  

Or does each cluster need to manage a single instance.......  

Cluster1=

Node1= sid1

Node2= sid1

Node3 =sid1  

Cluster2=

Node4=sid2

Node5=sid2

Node6=sid2  

Cluster3= ....  

What we are envisioning is a single huge RAC cluster that will run ALL of our Oracle databases vs. created multiple RAC clusters with one instance/database per cluster.    

-----Original Message-----
Sent: Friday, March 14, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L  

Todd,  

RAC is a multi-instance database. If you have n nodes in a cluster then you generally have (although not necessarily that many) n instances accessing the same database. When you mention 3 or more Oracle instances, perhaps you mean 3 or more "databases" each in a separate cluster of 4 to 8 nodes each.  

Interconnect plays a very important role in performance in this case and depends heavily on the hardware you decide on. For instance if you use Tru64 Clusters on Compaq alphas, you would probably go for Memory channels as interconnect; but for HP clusters you will lean towards CLIC interface.  

The environment you mentioned is not just viable, but that's exactly how it is done.  

HTH.   Arup Nanda

To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L

Sent: Friday, March 14, 2003 1:29 PM    

My company is currently considering using Oracle 9i RAC. One of the proposed environments is to have multiple oracle instances (3 or more) configured on a 4-8 node RAC cluster. Does anyone have any insights as to the viability of this implementation? Will the high speed inter connect be able to handle the traffic from multiple instances? I always thought of RAC as a single instance implementation with each instance needing its own cluster...........


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Mar 15 2003 - 06:58:47 CST

Original text of this message

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