Last updated on AUGUST 16, 2016
Applies to:Oracle Net Services - Version 220.127.116.11 to 18.104.22.168 [Release 11.2 to 12.1]
Information in this document applies to any platform.
***Checked for currency on 9-SEPT-2015***
This issue might occur in an environment where RAC / SCAN was configured and where the Applications or E-Business Suite utility AutoConfig was used to configure the database environment. This issue might also occur when a customer attempts to use a TNS connect string (versus the EZCONNECT setting) for REMOTE_LISTENER where the single SCAN address is specified. See below.
Services are failing to register in new installation of RAC with SCAN configuration.
Lsnrctl services LISTENER_SCAN<n> shows no services registered.
The REMOTE_LISTENER setting might be set in either of the following 2 ways:
1) REMOTE_LISTENER is set to EZCONNECT style string:
For our example:
Where SCANHOST is the SCAN address that resolves to unique ip addresses.
2) REMOTE_LISTENER is set to a tnsnames entry created by the user where only the SCAN hostname is listed in a single address:
SCANHOST resolves to 2 or 3 unique ip addresses.
This is likely a new installation of RAC with SCAN or this is an EBusiness Suite environment and the AutoConfig utility has recently been run in this environment. In an E-Business or Applications environment, the AutoConfig utility might be run to configure the database environment. This could also be a SCAN configuration and the DBA has chosen to set REMOTE_LISTENER to a tnsnames entry versus the recommended EZCONNECT style string.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms