NLS settings like NLS_DATE_FORMAT in spfile or init.ora ignored, incorrect or not as expected on Oracle 11.2.0.2 and higher (Doc ID 1368966.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
Oracle RDBMs 11.2.0.2 and up

This note does NOT apply to any version lower than 11.2.0.2


Symptoms

This is seen:
* After upgrade to 11.2.0.2 when comparing the configuration of the older version with the 11.2.0.2 (or up) config
OR
* After trying to set a NLS settings like NLS_DATE_FORMAT in spfile or init.ora in 11.2.0.2 (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>show parameter NLS%

or

SQL>select name,value from V$PARAMETER where name like '%nls%';

Changes

Using 11.2.0.2 or higher

Cause

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