This forum is currently locked. You can't register or post questions at this time. (read more)

Node Eviction due to heart beat fatal error

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

Moderator: Tim...

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

Re: Node Eviction due to heart beat fatal error

Postby Tim... » Wed Oct 16, 2013 8:24 am

Hi.

Some thoughts:

- Your query is you are looking for a specific user. The load balancing is done using all sessions. As a result, having an imbalance for a specific user is possible. It is the total number of sessions on the nodes that should be approximately equal. I'm assuming that although your query is doing this, you are seeing an issue on a larger scale. :)

- Are you using any services that are node-specific. People often use services to partition workloads between different nodes of the cluster. In fact, I've never seen a good RAC implementation that doesn't use services. You can make sure different functional already preferentially run on specific nodes to reduce the likelihood of blocks being shipped over the interconnect.

- I'm not sure why jumbo frames would have any affect on the load balancing unless there is some other problem. Personally, I would probably try turning off jumbo frames to see if the problem still happens. It would be good to know if this is linked or not.

- I think you need to raise your concerns with Oracle Support, in case there are known issues with your patch level. Looking back on earlier posts I can see you are not on the latest patchset for your version...

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


Return to “Oracle RAC and Clusterware”

Who is online

Users browsing this forum: No registered users and 3 guests

cron