Session reconnect after 8i Data Guard Switchover
My goal is to have currently connected sessions reconnect (conn user@sid) to the "new" primary thru Net8 successfully, and brand new connections connect to the "new" primary as well. My connect tool of choice is SLQ*Plus. I would like to achieve this without having to modify all my tnsnames.ora files after the switchover. Isn't this the definition of Net8 failover or TAF?
I have tried all the flavors of the tnsnames.ora file that are found on metalink, all five of them. Anybody got a version that works. I am on db version 8.1.7.0.
Session reconnect after 8i data guard
did you use two separate init.ora files? one specifically for after switchover or did you add the instance name with an alter system command?