Monday, April 25, 2011

ORA-01450

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 parameters nls_length_semantics

SQL> alter system set NLS_LENGTH_SEMANTICS=BYTE scope=both

After resetting the parameter you should restart your database for the change to take effect.


No comments:

Post a Comment