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 184.108.40.206.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:\>
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“.
On the System Properties window select tab “Advanced” and click on button “Environment Variables…” as on the picture below.
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 .
And to save the new variable press the “OK” button. And “Ok” plus “Ok” more until you are out from the System Properties window.
Open a new Command window and repeate the same command “tnsping oracle_db”
C:\>tnsping oracle_db TNS Ping Utility for 64-bit Windows: Version 220.127.116.11.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:\>
Online Tech Support Home