Database Administration (MOSC)

MOSC Banner

How to change NLS_LANGUAGE system level

edited Jan 29, 2014 1:53AM in Database Administration (MOSC) 19 commentsAnswered ✓
I do the followingSQL> alter session set NLS_LANGUAGE='GERMAN';

Session altered.

SQL> show parameter NLS_LANGUAGE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_language                         string      GERMAN

Then I do the following
SQL> alter system set  NLS_LANGUAGE='GERMAN' scope=spfile;

System altered.

SQL> STARTUP FORCE;
...........................................
SQL> show parameter NLS_LANGUAGE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_language                         string      ENGLISH

Why it's not reflected at system level? I check the spfile and I see the below
*.nls_language='GERMAN'

Thanks

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