Last updated on AUGUST 16, 2016
Applies to:
Oracle Net Services - Version 11.2.0.1 to 12.1.0.2 [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.
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
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms