NLS_LANG IN ORACLE - Online Tech Support
  Home
 

This page is based on examples to be easier to follow. About this topic there have been many questions about why my Windows or DOS prompts are showing Oracle messages and texts in different language? There could be a couple of reasons for that like your Windows’ Region and Language has the language defined in the settings or you have installed your Oracle client version in that language. Now to fix the problem you can change your Windows’ Region and Language settings but if that would not fix your problem you can try following and define your own NLS_LANG variable.

This Online Tech Support tutorial has written using Oracle client Spanish version and we would like to set it to show messages in (American) English language. The first test below is to execute Oracle command tnsping that would return some messages like “TNS-03505: Failed to resolve name” when you look at the example below the output is returned in Spanish “TNS-03505: Fallo al resolver el nombre“.

C:\>tnsping oracle_db

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-JUL-2015 10:10:10

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Archivos de parßmetros utilizados:
C:\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora

TNS-03505: Fallo al resolver el nombre

C:\>

online tech support computer help computer technician computer problems computer NLS_LANG oracle NLS_LANG in oracle database programming oracle windows NLS_LANG windows NLS_LANG in windows retirement planning retirement

Let’s assume your Windows’ Region and Language setting did not fix the language and all Oracle messages are still in Spanish and the next step would be to define NLS_LANG variable in your computer. The first step would be to launch “System Properties” window by right clicking on My computer icon in the start menu and then selecting Properties. This “System Properties” window can also be opened directly from Run window by executing the command “sysdm.cpl“.

online tech support computer help computer technician computer problems computer NLS_LANG oracle NLS_LANG in oracle database programming oracle windows NLS_LANG windows NLS_LANG in windows retirement planning retirement

On the System Properties window select tab “Advanced” and click on button “Environment Variables…” as on the picture below.

online tech support computer help computer technician computer problems computer NLS_LANG oracle NLS_LANG in oracle database programming oracle windows NLS_LANG windows NLS_LANG in windows retirement planning retirement

The new Oracle variable can be added on the system level (available to all users) or only to your current user on . We will add this variable to “System Variables” level by pressing on button “New…”. We are adding to “Variable name:” NLS_LANG and to “Variable value:” American_America.UTF8. This Oracle link is showing some NLS_LANG options but the list is incomplete .

online tech support computer help computer technician computer problems computer NLS_LANG oracle NLS_LANG in oracle database programming oracle windows NLS_LANG windows NLS_LANG in windows retirement planning retirement

And to save the new variable press the “OK” button. And “Ok” plus “Ok” more until you are out from the System Properties window.

online tech support computer help computer technician computer problems computer NLS_LANG oracle NLS_LANG in oracle database programming oracle windows NLS_LANG windows NLS_LANG in windows retirement planning retirement

Open a new Command window and repeate the same command “tnsping oracle_db”

online tech support computer help computer technician computer problems computer NLS_LANG oracle NLS_LANG in oracle database programming oracle windows NLS_LANG windows NLS_LANG in windows retirement planning retirement

C:\>tnsping oracle_db

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-JUL-2015 12:39:42

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\>



See Also:
Online Tech Support Home