Question

1
Replies
32
Views
Lee Gardner (LGardner)
IBM

IBM
GB
LGardner Member since 2011 1 post
IBM
Posted: May 19, 2021
Last activity: May 27, 2021
Posted: 19 May 2021 4:18 EDT
Last activity: 27 May 2021 4:58 EDT

Pega 8 Setting NLS_LENGTH_SEMANTICS appropriately

We are performing an upgrade from Pega 6 to Pega 8 as part of the upgrade instructions the Pega-platform-85-upgrade-websphere-oracle.pdf guide states that:

NLS_LENGTH_SEMANTICS=CHAR be set at the SPFILE level

Oracle documentation reports this setting as inadvisable at that level - 

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/NLS_LENGTH_SEMANTICS.html#GUID-221B0A5E-A17A-4CBC-8309-3A79508466F9

"Oracle strongly recommends that you do NOT set the NLS_LENGTH_SEMANTICS parameter to CHAR in the instance or server parameter file. This may cause many existing installation scripts to unexpectedly create columns with character length semantics, resulting in run-time errors, including buffer overflows."

Can you advise firstly on the appropriate way to define CHAR length semantics.  

Secondly is installation with default BYTE semantics supported by Pega?

***Edited by Moderator: Pooja Gadige to change category from Product to Upgrade***
Pega Platform 8.5.1 System Administration Upgrades Government Solutions Engineer Upgrade