Database - RAC/Scalability (MOSC)

MOSC Banner

RAC Aware Applications

edited Oct 16, 2014 10:01AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

Our applications use mix of JDBC thin client and oracle wallets. They connect on 5 node RAC. When we move db service from one node to another, the application fails and need to be restarted. Is there anything I can do to make the application "rac aware" and reconnect to the new node? I was wondering if following tnsnames would help -

bubba.world =

  (DESCRIPTION_LIST =

    (FAILOVER = true)

    (LOAD_BALANCE = true)

    (DESCRIPTION =

    (ADDRESS =

      (PROTOCOL = TCP)

      (HOST = redneck)(PORT = 1521))

      (CONNECT_DATA =

        (SERVICE_NAME = bubba)

        (SERVER = dedicated)

        (FAILOVER_MODE =

           (BACKUP=cletus)

           (TYPE=select)          

           (METHOD=preconnect)

           (RETRIES=20)

           (DELAY=3)

        )

      )

    )

Also problem remains for direct connect using think client.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center