My Oracle Support Banner

Setting REMOTE_LISTENER or LOCAL_LISTENER Yields ORA-00972 (Doc ID 1387187.1)

Last updated on JANUARY 07, 2020

Applies to:

Oracle Net Services - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-NOV-2013***

Symptoms

While attempting to set REMOTE_LISTENER or LOCAL_LISTENER using the alter system command, the following error is thrown:

ORA-00972: identifier is too long

Examples:


SQL> alter system set LOCAL_LISTENER="(address_list=(address=(protocol=tcp)(host=<localhost_name_or_IP_address>)(port=1521))(address=(protocol=tcp)(port=1521)(host=<some_long_hostname.domain>)(address=(protocol=tcp)(port=1522)(host=<some_long_hostname.domain>)))" scope=both;

or

SQL> alter system set REMOTE_LISTENER="(address_list=(address=(protocol=tcp)(host=<localhost_name_or_IP_address>)(port=1521))(address=(protocol=tcp)(port=1521)(host=<some_long_hostname.domain>)(address=(protocol=tcp)(port=1522)(host=<some_long_hostname.domain>)))" scope=both;

Each of these attempts would fail with the following message:

ORA-00972: identifier is too long

 

Changes

This is likely a new installation or a change to LOCAL_LISTENER or REMOTE_LISTENER is required in a RAC / SCAN environment.

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!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.