connection made to which listener?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: connection made to which listener?

  1. #1
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322

    connection made to which listener?

    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?

    Thanks!
    lucky

  2. #2
    Join Date
    Dec 2002
    Posts
    60
    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.

  3. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Quote Originally Posted by skhanal View Post
    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.
    That's what I want to know.
    lucky

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width