connection failover in RAC

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

connection failover in RAC

Postby sivakumarocp » Thu Oct 25, 2012 3:19 am

Hi Tim,

consider this scenario,

we have 2 node RAC, each node has sessions parameter to 500

currently node1 has 300 sessions and node2 has 300 sessions. After sometime node1 going down due to some issues, now what happen to the sessions connected in NODE1?

whether all sessions from NODE1 will get failedover to NODE2? or only first 200 sessions could failover.

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: connection failover in RAC

Postby Tim... » Thu Oct 25, 2012 7:44 am


I've never tried it, but what I'm guessing is the sessions will start failing over until you hit the limit, then they will start erroring when attempting to restart on the new node.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle RAC and Clusterware”

Who is online

Users browsing this forum: No registered users and 1 guest