This content has been marked as final. Show 7 replies
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.
I know thats its recommended to use the scan. But my developers won´t change there application.
how to add a static service entry for the scan listener ?
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
OK, you are right. Using the scan entry as remote listener, is registering the service on the vip address. Thats good. thx anyway.
Hey, I solved my problem by entering both parameters to the remote listener parameters:
can you show me an example the the configuration you have made?