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
Last updated on DECEMBER 05, 2016
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms