Below is a list of recommended NLS parameters for Oracle settings when installing the Data Platform:
Parameter |
Value |
NLS_CALENDAR |
GREGORIAN |
NLS_CHARACTERSET |
AL32UTF8 |
NLS_COMP |
BINARY |
NLS_CURRENCY |
$ |
NLS_DATE_FORMAT |
DD-MON-RR |
NLS_DATE_LANGUAGE |
AMERICAN |
NLS_DUAL_CURRENCY |
$ |
NLS_ISO_CURRENCY |
AMERICA |
NLS_LANGUAGE |
AMERICAN |
NLS_LENGTH_SEMANTICS |
BYTE |
NLS_NCHAR_CHARACTERSET |
AL16UTF16 |
NLS_NCHAR_CONV_EXCP |
FALSE |
NLS_NUMERIC_CHARACTERS |
., |
NLS_RDBMS_VERSION |
12.1.0.2.0 |
NLS_SORT |
BINARY |
NLS_TERRITORY |
AMERICA |
NLS_TIMESTAMP_FORMAT |
DD-MON-RR HH.MI.SSXFF AM |
NLS_TIMESTAMP_TZ_FORMAT |
DD-MON-RR HH.MI.SSXFF AM TZR |
NLS_TIME_FORMAT |
HH.MI.SSXFF AM |
NLS_TIME_TZ_FORMAT |
HH.MI.SSXFF AM TZR |
BDNA Data Platform 5.5 Installation Help LibraryJune 2021 |
Copyright Information | Flexera |