RAC Node Preference for sessions

From: <Christopher.Taylor2_at_parallon.net>
Date: Sat, 2 Feb 2013 12:32:15 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E885710467F4_at_NADCWPMSGCMS10.hca.corpad.net>

Is there a way to influence [thru manual intervention] which node is preferred for sessions? The reason I ask this question, in this way, is that we have 3 nodes, and node 2 continuously seems to be favored for new sessions.

These are identical servers (DELL R900s) with the same OS, the same server characteristics (CPU speeds etc).

We have the default RAC listener service configured:

SERVICE_ID      NAME    NAME_HASH       NETWORK_NAME    CREATION_DATE   CREATION_DATE_HASH      FAILOVER_METHOD FAILOVER_TYPE   FAILOVER_RETRIES        FAILOVER_DELAY  MIN_CARDINALITY MAX_CARDINALITY GOAL    DTP     ENABLED AQ_HA_NOTIFICATIONS     CLB_GOAL
3       CCMNASP1        2295827025      CCMNASP1        5/12/2010 1:58:52 PM    2134570705                                                              N       NO      NO      LONG

As an example, we had 2 nodes idling (1 & 3) and I was running a perf test on node2 generating a lot of IO (but little CPU) and we kicked off some web reports and they connected to node2 (from Business Objects server).

I have verified that the BOBJ server is set to use the CCMNASP1 network name so I know it's not setup to only connect to the instance name on node2.

Part of the issue is that node2 is having "issues" of its own - so when it gets loaded, the issues get exasperated.

I'm wondering what I'm overlooking (if anything).

Chris Taylor
Oracle DBA
Parallon IT&S

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Feb 02 2013 - 19:32:15 CET