Andrea Loris Gialain (AndreaG86)
Accenture SPA

Accenture SPA
AndreaG86 Member since 2018 12 posts
Accenture SPA
Posted: April 30, 2021
Last activity: 2 weeks 2 days ago
Posted: 30 Apr 2021 6:17 EDT
Last activity: 9 Sep 2021 6:15 EDT

Oracle DB semantics Character set for upgrading application from Pega 7.1.9 to 8.5.3.


We're in the process of Pre-Upgrade of our application from PRPC 7.1.9 to 8.5.3. version.

We've seen the following Oracle DB settings in Pega 8.5.3. Platform Upgrade Guide. "Verify that Oracle semantics is set to CHAR to support localization: 1. On the database server, open the file SPFILEDBNAME.ora in the database directory. 2. Verify that the settings are as follows: NLS_LENGTH_SEMANTICS=CHAR scope=both; NLS_CHARACTERSET=AL32UTF8; NLS_NCHAR_CHARACTERSET=AL16UTF16; 3. If the semantics settings differ, migrate the database character set."

Currently on our Oracle 11g DB we have NLS_LENGTH_SEMANTICS=BYTE .

it's necessary to change the NLS_LENGTH_SEMANTICS or we can keep this one?

this setting is only necessary to avoid errors on 2 byte characters?

thank you, Andrea

***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Platform 7.1.9 System Administration Upgrades Upgrade