Database Networking (MOSC)

MOSC Banner

Fake service through USE_SID_AS_SERVICE_listener does not failover on RAC

edited Jan 10, 2023 7:17PM in Database Networking (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center