Wednesday, October 31, 2007

Restricted Session and Listener load balancing.

Morning got a call from a friend who is new RAC DBA. His problem was

on a two node RAC.

On Instance rac1 service " fin" is prefered.
On Instance rac2 service "fin" is available.

So when rac1 is in restricted session he was expecting connections to "fin" is also restricted. But to his surprise connections got diverted to "rac2".

Well this is the expected behaviour. If prefered instance for a service is in restricted session listener will exclude that instance from its load balancing algorithm and new connections will be send to the instance where it is "available"

No comments: