Are you on Win 2000? -If you are , maybe it has something to do with regional settings. It have to be set two places. In the first window on regional settings and pres the "set default" buton and set it there as well

You can try to set nls_lang on the top level of hkey_local_mashine\software\oracle ??

Have you restarted the server after changing registry? MS claims you do not have to , but you know.....

Hope this help!!

Med vennlig hilsen
Torgeir Toms
Systemkonsulent Teknisk IT

==================================
Good Judgment Comes From Experience. Experiences Comes From Bad Judgment.
=====================================



-----Opprinnelig melding-----
Fra: tamizh [mailto:[Email Address Removed] 30. november 2003 17:23
Til: Torgeir Toms; LazyDBA.com Discussion
Emne: RE: Question Reg. NLS_LANGUAGE


Thanks Torgeir for your response. But..

I tried the same but still I am getting messages in english. Reg key value GERMAN_AMERICA.WE8MSWIN1252(I have only one oracle_home)

NLS_LANG environment variable also set to

C:\>set NLS_LANG=GERMAN_AMERICA.WE8MSWIN1252

C:\>echo %NLS_LANG%
GERMAN_AMERICA.WE8MSWIN1252

C:\>sqlplus scott/[Email Address Removed] Release 9.2.0.4.0 - Production on So Nov 30 11:21:49 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production

SQL> alter session set NLS_LANGUAGE=GERMAN;
Session altered.


-----Original Message-----
From: Torgeir Toms [mailto:torgeir.[Email Address Removed] Sunday, November 30, 2003 9:58 AM
To: LazyDBA.com Discussion
Subject: SV: Question Reg. NLS_LANGUAGE


Go to regedit, hkey_local_machine\software\oracle\home?\nls_lang - Locate where it says America_american. Change it to German_American. Then you will have systemmessages in german Second question !!! why do you want that - Metalink and oracle support requiers english. I have tried to translate them back to english from norwegian -it is not easy. I suppose it is not easier from german.



Med vennlig hilsen
Torgeir Toms
Systemkonsulent Teknisk IT

==================================
Good Judgment Comes From Experience. Experiences Comes From Bad Judgment. =====================================



-----Opprinnelig melding-----
Fra: Thiagoo [mailto:[Email Address Removed] 30. november 2003 09:46
Til: LazyDBA.com Discussion
Emne: Re: Question Reg. NLS_LANGUAGE


Hi Tamizh,

Pls try this..Am not sure..

Please check your database characterset & national character set..What's ur current NLS_LANGUAGE & NLS_TERRITORY?..I think this will have an impact...

If am wrong, someone pls corect me..! If you need the system's response to be in German, there may be some other settings.

-Thanks!

tamizh <[Email Address Removed] wrote:
Hi Gurus,

When I say
SQL> ALTER SESSION SET NLS_LANGUAGE=german;
System altered.

But manual says
SQL> ALTER SESSION SET NLS_LANGUAGE=german;
Session wurde geändert.



==================================================

Thanks & Best Regards,

Thiagu

==================================================


---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page