unable to change nls_database_parameters even after restart
Hi everyone,
On 11.2.04 database server solaris 11.4
I am changing spfile the NLS_DATABASE_PARAMETERS - NLS_LANGUAGE from french → english and NLS_TERRITORY from france → america.
After database restart, those parameters did NOT changed at all.
Please advise
SQL> alter system set NLS_TERRITORY='AMERICA' scope=spfile;
System altered.
SQL> ALTER SYSTEM SET NLS_LANGUAGE='ENGLISH' scope=spfile;
System altered.
SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL> STARTUP
ORACLE instance started.
Total System Global Area 5.3463E+10 bytes
Fixed Size 2194184 bytes
Variable Size 3623879928 bytes
Database Buffers 4.9795E+10 bytes
Redo Buffers 42532864 bytes
Database mounted.
Database opened.