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: Single ASM instance for non-RAC and RAC instances in a node ?

Re: Single ASM instance for non-RAC and RAC instances in a node ?

From: Dan Norris <dannorris_at_dannorris.com>
Date: Wed, 21 Nov 2007 19:58:55 -0800 (PST)
Message-ID: <331689.35210.qm@web35401.mail.mud.yahoo.com>


Hi Jay,

I don't know that I've done it with DBCA, but I should expect it will be okay. Technically, there's no reason why this should be a problem. Architecturally, it's the same as if you took down the RAC instances, set cluster_database=false and started one of the RAC instances.

Personally, I always recommend against running anything else on a RAC node if there's any way to avoid it. From my experience, it just makes troubleshooting a bit more difficult and even if the other instance isn't resource intensive, if there are more moving parts on that node, there are that many more things that can go wrong and possibly affect the node's availability. I suppose it's a calculated risk, but a risk that can be avoided. While I do always recommend against running other things on the RAC nodes, many sites still do it and I suspect most of them are doing fine.

Dan

Dan:  

If so, can we use +ASM1 (node1) while creating non-RAC instance in that node using DBCA ? this instance will use DiskGroups mapped to +ASM1  

In our Production landscape, we prefer not to host RAC database for smaller application databases , which won't contribute much load on the server or resource intensive.  

Thanks

Jay  

On 11/21/07, Dan Norris <dannorris_at_dannorris.com> wrote:

Sure. Having clustered ASM instances doesn't stop you from using those diskgroups for non-clustered databases.

The larger question is: Why would you compromise the RAC instance on that node by making it compete for resources with some other instance? As we've reviewed multiple times here, Oracle's resource manager operates within an instance, not across instances on the node. So, you've got little ability to ensure that the RAC instance gets what it needs in this case.

Dan

Subject: Single ASM instance for non-RAC and RAC instances in a node ?

List Members:

Can I map a non-RAC instance to a ASM instance (+ASM1 in node1 or +ASM2 in node2) which is already configured for RAC instances ?

We are running 10.2.0.2 in Linux RHEL 4.

Thanks
Jay

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 21 2007 - 21:58:55 CST

Original text of this message

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