Cause
the errors seen above are encountered because the NLS_LENGTH_SEMANTICS initialisation parameter has been set to CHAR. This is not a supported setting for this parameter in an Oracle Fusion Middle ware installation. This is documented in the Release Notes for each platform.
Solution
To remove the ORA-01450 errors when creating the MDS and SOAINFRA components ensure that the requirement for NLS_LENGTH_SEMANTICS=BYTE is met.
To check the current setting of NLS_LENGTH_SEMANTICS, login to the target database as SYSDBA and issue the following command:
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
After resetting the parameter you should restart your database for the change to take effect.
Comments
Tags: APPS DBA, ERP, ERP Application, ORA 01450, ORA 01450 errors, Ora Error, ORA-01450: maximum key length (6398) exceed, ORA-01450: maximum key length (6398) exceeded, Oracle, Oracle Application, Oracle DBA, oracle erp, Oracle erp application, Oracle Forms, racle Apps, Repository Creation Utility - Warning | ORA-01450: maximum key length (6398) exceed, Repository Creation Utility Warning