1 Reply Latest reply on Feb 13, 2013 1:05 PM by user530956

    Load balancing the connections in RAC service?

      i have a created the service, but the connections are not properly loadbalancing across 2 rac nodes in 11gr2 and its has rac scan. In Total 200 app session around 150 session are connected to node 1 and 50 connections on node 2. Due to improper load balancing, node 1 is highly utilized and node 2 is very minimal. copied below rac service config. Please advise which parameter i need to change in service to load balance the connections

      $ srvctl config service -d orcl -s orcl_srv
      Service name: orcl_srv
      Service is enabled
      Server pool: orcl_orcl_srv
      Cardinality: 1
      Disconnect: false
      Service role: PRIMARY
      Management policy: AUTOMATIC
      DTP transaction: false
      AQ HA notifications: false
      Failover type: NONE
      Failover method: NONE
      TAF failover retries: 0
      TAF failover delay: 0
      Connection Load Balancing Goal: LONG
      Runtime Load Balancing Goal: NONE
      TAF policy specification: NONE
      Preferred instances: orcl1
      Available instances: orcl2