NLS settings like NLS_DATE_FORMAT in spfile or init.ora ignored, incorrect or not as expected on Oracle 188.8.131.52 and higher
Last updated on DECEMBER 05, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
Oracle RDBMs 220.127.116.11 and up
This note does NOT apply to any version lower than 18.104.22.168
This is seen:
* After upgrade to 22.214.171.124 when comparing the configuration of the older version with the 126.96.36.199 (or up) config
* After trying to set a NLS settings like NLS_DATE_FORMAT in spfile or init.ora in 188.8.131.52 (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 184.108.40.206 or higher
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms