Skip to Main Content

Oracle Database Express Edition (XE)

change nls parameters

AlainNov 3 2022

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?

Post Details
Added on Nov 3 2022