Hey I am running a two node rac on grid 11.2 and db 126.96.36.199
My application does not like the scan listener, therefore I have to configure the remote listener parameter to the vips of the two hosts, which is working fine.
But it comes out the the system needs the service registered with the scan listener.
So. How can I add a static service entry for my scan listener ?
Is there any specific error from the application. The best practice is to use SCAN listener.
Configure the remote_listener parameter to point to SCAN listener and let us know what is the error message from your application.
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