oracle RAC-takes time to connect
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: oracle RAC-takes time to connect

  1. #1
    Join Date
    Jul 2007
    Posts
    1

    oracle RAC-takes time to connect

    I have one sample JDBC program which connects to RAC.
    If all the participating node of cluster are up then I m able to connect in some few seconds(say 2 second).
    Even if instance is not running on any one of the nodes of cluster, it takes few seconds to connect.

    But if single node of cluster is completely shutdown(i.e switched off) then it takes some 150 second to 250 second to connect.


    Can someone assist me how to reduce this connect time.?


    I guess it takes more in later case, bcoz it needs to know the status of nodes

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Revise your listeners and tnsnames setup
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    look at your tcp timeouts

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    tell us the version at least

    thanks

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