Forum Stats

  • 3,874,173 Users
  • 2,266,677 Discussions


change nls parameters


I have a rac cluster SE, and a new database using charset al32utf8.

I would like to change date language and format to make it compatible with applications, so I typed:

alter system set nls_date_format='DD/MON/RR' sid='*' scope=both;

alter system set nls_date_language='FRENCH' sid='*' scope=both;

then restarted database (srvctl stop/start database -d ...).

The nls settings are well recorded in spfile (checked creating pfile from spfile), but when I do

  • select * from v$nls_parameters
  • select sysdate from dual

I see old parameter is in use ('-' instead of '/' in date format). I guess it is also stored on voting disk? How do I change that behaviour?