Connection failover in RAC
We are using JDBC Thin driver to connect to Oracle 12c database (2 nodes) .
- Currently when node1 or node 2 is shutdown then the existing sessions get "Commit failed with exception "Closed Connection". Will rollback current transaction”.
- Can this be averted by changing shutdown mode to transcational local
- How to configure TAF on server side and client side ,so that in case of scheduled or unscheduled down time there is no impact to application.
thanks
0