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.