This content has been marked as final. Show 4 replies
You probabaly want to implement Transparent Application Failover (aka TAF)
It is expected behavior of oracle RAC, your appliaction must handle the error message and restart the session in order to avoid the end user outage.
learn about TAF.
I think it's possible to configure a service that implements TAF on the server side. Then configure your client tnsnames.ora to connects to this service instead of the database.
see these 2 whitepapers:
Then decide if you want to go for TAF or FCF.