connection failover in RAC

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

Moderator: Tim...

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.
Regards
Sivakumar.A
www.sivakumardba.com
sivakumarocp
Advisor
 
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: connection failover in RAC

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

Hi.

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.

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17951
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle RAC and Clusterware

Who is online

Users browsing this forum: pb2070 and 1 guest