SQL Developer ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified
May 15, 2021 5 Comments
Problem:
Connection from the SQL Developer fails with the following error:
ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified
Solution:
Find sqldeveloper.conf
file:
$ find / -name sqldeveloper.conf 2>>/dev/null ^@/System/Volumes/Data/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf /Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
Add the following two parmeters in /Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
AddVMOption -Duser.language=en AddVMOption -Duser.country=US
Restart SQL Developer and try connection again.
Thank you so much. I had trouble with this issue, but you helped me to solve it.
Thankyou very much for this help
You saved my day!!! Thanks so much.
Help! I can’t find the folder of sqldeveloper.conf
What is the result of find command?