Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01450 when NLS_LENGTH_SEMANTICS=CHAR

Savo MarovicSep 21 2016 — edited Sep 21 2016

Hi,

We are having a problem with a database with NLS_LENGTH_SEMANTICS=CHAR parameter defined in spfile. There are some different Oracle products (BI Publisher, APEX...) and some third party products that use Oracle database. Everything was functioning fine n that database, but now i want to install Oracle Access Manager on this database. When i run RCU for OAM i get the following error:

Screenshot_1.png

I've found that the problem is because NLS_LENGTH_SEMANTICS is set to CHAR on instance level. So now i would like to change this to BYTE, but i am not sure how this new setting will reflect on the products previously installed on Oracle database.

The version of the db is 12c.

Regards,
Savo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2016
Added on Sep 21 2016
7 comments
635 views