Load Balancing
I am having one doubt in Load Balancing & Fail-over in RAC database. IF We create a service in a 2 node cluster with 1 node as available & 1 as preferred and mode = basic.
Then why we give LOAD BALCEING = YES & FAILOVER = YES in client side TNS entry.
Because whenever we will create session it will go to preferred node only and always do the failover as per specified in service creation.