Listener with USE_SID_AS_SERVICE_LISTENER and RAC and SCAN question
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?