SCAN Registration Issue: Services Fail to Register to SCAN Listeners
(Doc ID 1448717.1)
Last updated on JULY 23, 2018
Applies to:
Oracle Net Services - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]Information in this document applies to any platform.
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.
Symptoms
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:
REMOTE_LISTENER='SCANHOST:1521'
Where SCANHOST is the SCAN address that resolves to unique ip addresses.
OR:
2) REMOTE_LISTENER is set to a tnsnames entry created by the user where only the SCAN hostname is listed in a single address:
e.g.
REMOTE_SCAN_LISTENERS=
(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=SCANHOST)(PORT=1521)))
SCANHOST resolves to 2 or 3 unique ip addresses.
Changes
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.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |