Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Routing all connections through a one node in a 2 node RAC cluster

user573914Jan 17 2011 — edited Jan 18 2011
Hi everyone

My client has the following requirement: an active/active RAC cluster (eg node1/node2), but with only one of the nodes being used (node1) and the other sitting there just in case.

For things like services, i'm sure this is straightforward enough - just have them set to preferred on node1 and available on node 2.

For connections, I imagine I would just have the vips in order in the tns file, but with LOAD_BALANCING=OFF, so they go through the tns entries in order (i.e node 1, then node 2), so this would still allow the vip to failover if node 1 is down.

Does that sound about right? Have I missed anything?

Many thanks
Rup
This post has been answered by Billy Verreynne on Jan 18 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2011
Added on Jan 17 2011
3 comments
1,427 views