RAC Aware Applications
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.