RAC Node Preference for sessions
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-lReceived on Sat Feb 02 2013 - 19:32:15 CET