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

adnanBIH

Dear professionals,

I'm facing next problem: when try to execute SQL query inside SQL Developer it raises error: ORA-12705 Cannot access NLS data files or invalid environment specified.

Error appeared after I changed some region settings in Windows 10 (unfortunately, I cannot remember which one). Exactly the same query executed smoothly before that change in OS.

I tried to alter sqldeveloper.conf file according to this but no success. 

AddVMOption -Duser.language=en
AddVMOption -Duser.region=US
AddVMOption -Duser.country=en

I'm using Sql Developer version 20.4.0.379 and 21.2.1. 

Thanks in advance

adnanBIH

@thatJeffSmith-Oracle

In case someone else encounters the same problem, here's how the problem is solved - by setting the territory option.

I noticed that this change didn't make any change in sqldeveloper.conf nor in product.conf files.

thatJeffSmith-Oracle

try putting that in your product.conf file instead

adnanBIH

https://community.oracle.com/tech/developers/discussion/comment/16810777#Comment_16810777

Thanks for answer, but that didn't help. Also, I noticed that during upgrade of database we have such situation: is it possible that nls_lang parameter in the database could cause this problem?

thatJeffSmith-Oracle

No this is all about your client communicating with the database, and your pc is saying, hey, I am in...COUNTRYABC...and the database is saying, I have no idea how to talk to you

Your JVM flags SHOULD fix this problem. Can you check the Help - About dialog to see if the user. properties are what we expect?

adnanBIH

https://community.oracle.com/tech/developers/discussion/comment/16810825#Comment_16810825

Dear @thatJeffSmith-Oracle , thanks for your kindness help, but I'm still facing the same problem. And, I'm now much more confused.

Here is "about" section from SqlDeveloper in comparison with sqldeveloper.conf file. How is that possible that user.country parameter is set to "en"? Is there any other source, apart from sqldeveloper.conf and product.conf, from which SqlDev could use this setting?

thatJeffSmith-Oracle

the product.conf file pulls in other conf files like ide.conf - and i see in your screenshot you've got other non-standard stuff going on, so not sure what you have done on your side.

you have an include for java11.conf and sqldeveloper-nondebug.conf - check those files.

adnanBIH

https://community.oracle.com/tech/developers/discussion/comment/16810856#Comment_16810856

Could you please be more specific - what do you suggest to change in those files? SqlDeveloper was good product for me for years, but errors like this make me desperate.

Thanks in advance

thatJeffSmith-Oracle

I have no idea what you've done on your machine.

adnanBIH

Dear Jeff, thank you very much again for your time and try to help me.

But I have to say that after using Oracle products for so long, it is not uncommon for something to suddenly not work and no one knows why. So, we have 2 configuration files from which SqlDeveloper should download the settings, but this is obviously not the case. I hope someone else from the experts will see this issue and try to help.

I will also talk to the DBA team to see if they have any explanation.

adnanBIH

@thatJeffSmith-Oracle

In case someone else encounters the same problem, here's how the problem is solved - by setting the territory option.

I noticed that this change didn't make any change in sqldeveloper.conf nor in product.conf files.