Setting REMOTE_LISTENER or LOCAL_LISTENER Yields ORA-00972
(Doc ID 1387187.1)
Last updated on MARCH 31, 2022
Applies to:Oracle Net Services - Version 10.2.0.5 to 220.127.116.11.0 [Release 10.2 to 18.1]
Information in this document applies to any platform.
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
Each of these attempts would fail with the following message:
ORA-00972: identifier is too long or ORA-32021: parameter value longer than 255 characters
This is likely a new installation or a change to LOCAL_LISTENER or REMOTE_LISTENER is required in a RAC / SCAN environment.
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