ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified 00604. 00000

Problem:

While connecting to an Oracle database with SQL Developer or JDeveloper, you might got this error:

Error:

An error was encountered performing the requested operation:
ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified 00604. 00000 -  "error occurred at recursive SQL level %s"

*Cause:    An error occurred while processing a recursive SQL statement            (a statement applying to internal dictionary tables).

*Action:   If the situation described in the next error on the stack            can be corrected, do so; otherwise contact Oracle Support. Vendor code 604

Solution:

The solution for this problem is simple, but I had to go through a number of websites to find its solution. So here it is:

1. If you are using SQL Developer:

Goto SQL Developer directory and there will be another SQL Developer directory, open it. Open bin folder, and you will find sqldeveloper.conf file in it.

Add 2 entries in sqldevelper.conf file:

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

Save the file and reopen SQL developer application, connect the database. Hope it will resolve your problem.

2. For JDeveloper, you have to perform the same procedure as described in (1), but in jdev.conf file.