Nope, it just opens up a whole lot more questions. :)

Having two environments on one cluster is, of course, possible, but generally not desirable. That's the case in single instance as well, but probably more so for a RAC environment (to my humble way of thinking anyway!) The sorts of issues you're going to come across are:

1. Development is usually a resource intensive operation. Not so much because of the amount of data which may or may not be the same as Production (I won’t enter into the “should or should not” argument here), but because of things like compilation of programs and so on. How are you going to ensure that Production has the resources it requires? After all, it’s Production that runs your business, not Development.

2. How can you test the effect of a patch for CRS (for example)? In general, there is one CRS version running on a cluster. If a patch comes out to that version, in the configuration you’re talking about you end up installing directly into the Production environment – generally considered not a Good Thing ™

3. Probably more worrying is there is no mention in your email of a Test environment. Do you have one on another cluster somewhere or do you simply move code from Development to Production?

4. How do you test the impact on your application of hardware failures? As a simple example, how do you test failover on node failure in such an environment?

And those are just the questions that immediately come to mind. I’m sure there are others if I put my mind to it. ;)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Chen, Sarah
Sent: Saturday, 29 October 2005 4:36 AM
To: 'Pete Sharman'; 'oracle-l@freelists.org'
Subject: RE: 10gR2 RAC

The reason that we are going to create second RAC on the same server where

already had a 2-node RAC running is we would like to separate our

development instance for each production databases, but don't think this is

a good idea of buying another 2 new servers for it. Hope this clear your Qs.

Sarah

-----Original Message-----

From: Pete Sharman [mailto:peter.sharman@oracle.com]

Sent: Friday, October 28, 2005 12:25 PM

To: Chen, Sarah; oracle-l@freelists.org

Cc: Peter Ross Sharman

Subject: RE: 10gR2 RAC

Sarah

I'm a bit unclear on what you're trying to do here. If I'm reading it

correctly, you have an existing cluster running 10gR2 RAC with ASM (are they

in different ORACLE_HOME's, by the way?) and you want to create another RAC

database. Is that correct?

If it is, I guess my question back to you is why? Why not run these

together in a single database? Doing that would minimize resource usage and

administration time. I'm not sure what benefit you get from having two

databases, unless you have some application that has to be in its own

database to be supported by the vendor (and even there I'd go back to the

vendor and ask them to explain why).

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]

On Behalf Of Chen, Sarah

Sent: Friday, 28 October 2005 11:56 PM

To: 'oracle-l@freelists.org'

Subject: 10gR2 RAC

> Hi, Oracle experts

> We are planning to create the second RAC on the same 2-node cluster where

> there is a Oracle 10gR2 RAC running already. Can someone please let me

> know the answers of the following Qs that I have?

> 1. Do I need to give another set of vip and private IP addresses that are

> different than the current RAC?

> 2. Any additional interconnects that I need in order to serve the second

> cluster database?

> 3. Any performance concerns?

> The current 2-node 10gR2 RAC is on RHEL3, using OCFS for clusterware

> service and ASM for Oracle datafiles.

> Thanks a lot.

> Sarah

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