SCAN Registration Issue: Services Fail to Register to SCAN Listeners (Doc ID 1448717.1)

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