NLS settings like NLS_DATE_FORMAT in spfile or init.ora ignored, incorrect or not as expected on Oracle 126.96.36.199 and higher
(Doc ID 1368966.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
Oracle RDBMs 184.108.40.206 and up
This note does NOT apply to any version lower than 220.127.116.11
This is seen:
* After upgrade to 18.104.22.168 when comparing the configuration of the older version with the 22.214.171.124 (or up) config
* After trying to set a NLS settings like NLS_DATE_FORMAT in spfile or init.ora in 126.96.36.199 (or up) and checking the result.
AND The way the setting is checked is one of these 2 methods: using "show parameter" or selecting from v$parameter.
SQL>select name,value from V$PARAMETER where name like '%nls%';
Using 188.8.131.52 or higher
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!