Repository Creation Utility - Warning | ORA-01450: maximum key length (6398) exceed

Issue: While trying to create repository schema using rcu, we were getting the following error

Repository Creation Utility - Warning | ORA-01450: maximum key length (6398) exceed

Solution: The NLS_LENGTH_SEMANTICS parameter was set to a value of CHAR. Change the value to BYTE and again invoke the rcu, it will go through.

SQL> show parameter NLS_LENGTH_SEMANTICS

NAME                     TYPE        VALUE
------------------------ ----------- -------
nls_length_semantics     string      CHAR

SQL> alter system set nls_length_semantics=BYTE;

System altered.

SQL> show parameter NLS_LENGTH_SEMANTICS

NAME                     TYPE        VALUE
------------------------ ----------- -------
nls_length_semantics     string      BYTE


Note: Though this parameter is system modifiable, in one of the scenario, after setting this parameter still it was not working, when I bounced the database.. it worked.