We have a 2 node RAC. Local and remote listeners are configured on both nodes. I read somewhere that when a node is over-loaded, the local listener routes new client connection requests to remote listener.
My questions are:
1. Is my understanding correct?
2. If my understanding is correct, how can I find connections that were made initially to listener (local listener) of node 1 but redirected later to listener (remote listener) of node 2?
If remote listeners are configured, at the connection initiation Oracle determines which instance to direct the connection to based on work load. This is called server side load balancing. I am not sure if Oracle records the redirection event.
If remote listeners are configured, at the connection initiation Oracle determines which instance to direct the connection to based on work load. This is called server side load balancing. I am not sure if Oracle records the redirection event.
Reply With Quote
Originally Posted by skhanal
Bookmarks