In this post, you’ll learn more about the Oracle ErrorORA-32021: parameter value longer than string characters with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-32021: parameter value longer than string characters
Reason for the Error ORA-32021: parameter value longer than string characters
An attempt was made to alter a parameter value but the number of characters in the parameter value was longer than the allowed maximum. For a list parameter, one of the values in the list was longer than the allowed maximum.
How to fix the Error ORA-32021: parameter value longer than string characters ?
You can fix this error in Oracle by following the below steps
Reduce the parameter value length and retry the command. For the DISPATCHERS parameter, use listener aliases to reduce value length.