This content has been marked as final. Show 7 replies
You can't really add a service statically to scan listener.
1) Scan listener redirect to connection to the VIP listener to resolve the service
Set the LOCAL_LISTENER parameter to resolve to VIP listener
and REMOTE_LISTENER parameter to the SCAN Listener
Which should resolve your problem.
For more details about configuring SCAN listener the following PDF may be useful for you.
I don't understand why add static service name. Add static service name on listener is recommended only when you need connect remotely in a Inactive Instance and only to SYS user can connect or if you don't configured LOCAL and REMOTE Listener Parameter.
So, If you configure LOCAL and REMOTE Listener proper the all SERVICE NAME configured on your database will be always automatically added on all Listeners, you don't need worry about in configure the service on Listeners Manually.
With Oracle RAC you should not use the Parameter SERVICE_NAMES, you define Service Using EM or SRVCTL