Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center