Database - RAC/Scalability (MOSC)

MOSC Banner

Listener with USE_SID_AS_SERVICE_LISTENER and RAC and SCAN question

edited Jun 13, 2018 9:39AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

Hi,

our software vendor needs for the setup/updates of his app the SID instead of Service name for his setup.

We have an multitenant Oracle 12.2 env. with SCAN Listener. So there is only a SID for accessing the CDB$ROOT but not connecting to a PDB. He suggested to set

"USE_SID_AS_SERVICE_listener_name" ( https://docs.oracle.com/database/121/NETRF/listener.htm#NETRF2090 ) for the listener (not scan listener).

As there are many other PDBs on that cluster, which all are accesed by separate created services servicenames I'm unsettle to use that parameter.

Does anybody has experiences (good/worse) using  "USE_SID_AS_SERVICE_listener_name" in a multitenant RAC-environment with scan listeners?

Tagged:

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