Grid Infra Version : 11.2.0.4
OS : Oracle Linux 6.8
I am planning to create 4 databases on a 6-node RAC cluster. In this RAC cluster , the 3 SCAN IPs will ideally be plumbed on 3 nodes. ie. at any given time , there won't be any SCAN listeners running in three nodes.
Whenever the application connects to the SCAN listener, it will 'hand over' the connection to the least loaded node's Local listener.
But, can the SCAN listener hand over the connection to a node where the SCAN listener is not running ? How will the load balancing work in such a configuration ?