Fake service through USE_SID_AS_SERVICE_listener does not failover on RAC
According to
Oracle Net 12c: How to enable Clients using SID to connect to PDB? (Doc ID 1644355.1)
if you set USE_SID_AS_SERVICE_listener=ON to listener.ora on the server side, you can have "sid=<service name>" in tnsnames.ora (and most likely also <service name> in the place where you would normally specify <sid> in a software-dependent connection string such as JDBC URL) on the client side, and that string will be interpreted as database service, not sid. The intent of this listener directive is for those clients that do not allow <service name> but insist on <sid>, maybe due to software limitations, to work around the problem that cannot be otherwise solved if the database is a PDB. I tested it