ORA-12705: Cannot access NLS data files or invalid environment

Question

The other day I got this annoying oracle error: ORA-12705: Cannot access NLS data files or invalid environment specified. Funny thing I wasn't trying to access NLS data files

score 20 · Accepted Answer · answered Oct 08 '11 at 23:04

There are two possible causes:

An attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value.

The NLS_LANG environment variable contains an invalid language, territory, or character set.

Fix:

Unset the NLS_LANG environment variable

Windows - The NLS_LANG must be unset in the Windows registry (re-named is best). Look for the NLS_LANG subkey in the registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, and rename it.

Linux/UNIX - Here you simply issue the Linux command "unset NLS_LANG"

score 15 · Answer 2 · answered Aug 20 '12 at 20:24

15

I have Oracle 10g XE and Windows 7. I resolved this as follows:

Go to Control panel > Regional and language options > Format and set your language.

answered Aug 20 '12 at 20:24

Enrique Amador Samaniego

159
1
2

This classify as a comment, not as a full answer – Yaroslav Oct 06 '12 at 13:06
this was the only thing that worked in my case, thanks. – demian Apr 05 '16 at 23:39
In windows 10: Go to "Control Panel > Region > Format", then set Format to "English (United States)", then restart your client tool (ex: oracle sql developer). – Abolfazl Hashemi Apr 16 '19 at 04:45

score 3 · Answer 3 · answered Jun 15 '15 at 10:55

Follow this procedure to set the NLS_LANG environment variable for Oracle databases. To set the NLS_LANG environment variable for Oracle databases Determine the NLS_LANG value. In the data warehouse database, run the command SELECT * FROM V$NLS_PARAMETERS

Make a note of the NLS_LANG value, which is in the format [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET]. For example: American_America.UTF8 For Windows: Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables. In System variables section, click New. In the Variable Name field, enter NLS_LANG. In the Variable Value field, enter the NLS_LANG value that was returned in Step 1. The format for the NLS_LANG value should be [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET]. For example: American_America.UTF8. For UNIX, set the variable as shown below: setenv NLS_LANG

For example: setenv NLS_LANG American_America.UTF8. If your data is 7-bit or 8-bit ASCII and the Informatica Server is running on UNIX, then set NLS_LANG _.WE8ISO8859P1 CAUTION: Make sure you set the NLS_LANG variable correctly, as stated in this procedure, or your data will not display correctly.

Reboot the machine after creating the variable.

score 3 · Answer 4 · edited Jul 01 '23 at 13:27

3

In my case, I was creating a database adapter in the Oracle WebLogic console, solve the problem by doing the following configuration. Windows -> control panel -> region:

Change the format to English (United States) date format M / d / yy and
Change my address to the United States.

Perform this configuration because my machine was configured with the Spanish language, then restart the computer and I worked without problems.

edited Jul 01 '23 at 13:27

Mirko Raimo

1,469
1
12
19

answered Oct 13 '17 at 22:29

Dario Alberto Castro Martinez

41
2

So in latest build of Win10, you cannot change the address from the control panel, so just change the rest and that worked for me. – Yousha Arif Aug 09 '20 at 12:51
Worked for me. Don't forget to restart your PC after you make the change. – Rishi Latchmepersad May 14 '21 at 19:39

score 2 · Answer 5 · answered Jun 15 '15 at 12:46

2

After addition of path in Environment variable of Oracle Instant client the Oracle SQLPLUSW goes to Oracle Instant client and for that client it required to set NLS LANG AS American_America.UTF8

answered Jun 15 '15 at 12:46

जयदेव

51
1

score 1 · Answer 6 · answered Nov 08 '17 at 15:06

1

In case if above solutions not helped, can try my solution. I just replaced my latest version of Ojdbc14.jar to an older version Ojdbc5.jar. It helped me to solve my issue.

answered Nov 08 '17 at 15:06

Yithirash

377
3
6
18

for Oracle 12C I used ojdbc7.jar, solved my problem. – KKA Oct 04 '21 at 07:54

score 1 · Answer 7 · edited Nov 05 '16 at 12:32

1

You can also just set the NLS config in your oracle settings

edited Nov 05 '16 at 12:32

Malik Daud Ahmad Khokhar

13,470
24
79
81

answered Oct 23 '11 at 16:24

user1009668

23
4

score 0 · Answer 8 · answered Nov 03 '21 at 10:04

I was trying to configure my Data Source on WebLogic 12c that was pointing to an 11g Database and I kept getting this error. I found out that WL 12c is not compatible with oracle 11g databases. I know it is not related but I am sure someone else will find this useful.

ORA-12705: Cannot access NLS data files or invalid environment

8 Answers8

Linked

Related