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

Question

I have an OracleXE 11g instance on a remote server machine. Some developers who have Russian Windows 7 SP1 can't connect to it. They got this error message:

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

There is no error if you use enUS Windows 7 SP1 machine. I tried many ways to solve this:

I checked language settings on server machine:

SELECT * FROM V$NLS_PARAMETERS;
SELECT USERENV ('language') FROM DUAL; 

Both returns GERMAN_GERMANY.AL32UTF8.

I tried different ways to solve this issue by doing this:

1. Rename registry key NLS_LANG to NLS_LANGX on server machine. Did nothing.
2. Create NLS_LANG environment variable with value of GERMAN_GERMANY.AL32UTF8.
3. Control panel > Regional and language options > Format and set Russian there.

None of this works. What should I do?

Solution 1

had similar problem
adding following to VM arguments helped:

-Duser.language=en
-Duser.region=us

Solution 2

I had this problem with MacOS, when installing SQL developer several times. Adding VM option helped me (@kilonet answer). But here I am adding a new answer specifically for resolve MacOS problem.

Modify SQL Developer product configuration file (product.conf) in below path.

~/.sqldeveloper/<sqldeveloper version>/product.conf

Add add following two entries.

AddVMOption -Duser.language=en
AddVMOption -Duser.region=us

Thanks for question and the answer.

Solution 3

setting _JAVA_OPTIONS is an alternative global solution to all the Java applications are stating in a terminal.

export _JAVA_OPTIONS='-Duser.language=en -Duser.region=us'