Re-balancing connections after node outage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Re-balancing connections after node outage

  1. #1
    Join Date
    Mar 2007
    Posts
    3

    Re-balancing connections after node outage

    People,

    I was asked to come up with some procedures to rebalance connection pools
    after a node in the Oracle RAC is restarted after an outage. I just bloged
    my findings:

    http://dev2dev.bea.com/blog/hoos/arc...ring_from.html

    These are all based on what our SOC operations can do using the WLS console.
    I want to know if there is anything that can be done on the database side that can help with these procedures or if other better oprtions exist.

    Please advise.

    Cheers,
    Hoos

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    I am not a big expert here, but search for "Transparent Application Failover" (abreviated TAF)
    Good luck

  3. #3
    Join Date
    Mar 2007
    Posts
    3
    I should have explained we are using the Oracle 10g thin driver. I believe TAF is only available on the thick driver, is this correct?

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    As I said, I am not a big expert here, but I think there is some mechanism where the pmon updates statistics of which instance - it's load, the number of sessions etc. and one can become a subscriber of these statistics and hence achieve load balancing.

  5. #5
    Join Date
    Mar 2007
    Posts
    3
    Thanks, I'll have a look at pmon.

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