oracle-sqldeveloper

How to fix 'ORA-12705: Cannot access NLS data files or invalid environment specified'

I have an error trying to connect to oracle database:

Query execution failed

Reason:
SQL Error [12705] [72000]: ORA-12705: Cannot access NLS data files or invalid environment specified
ORA-02063: preceding line

My platform is a MacOs running obviously over a Mac, try to connect to remote oracle database. How can I fix this problem?

Solution

  • If you are using SQL Developer you have to follow this steps:

    1. Open SQL Developer package content. Go to Applications, right click on SQL Developer and select "Show Package Contents".
    2. Go to Contents/Resources/sqldeveloper/sqldeveloper/bin/
    3. Open sqldeveloper.conf using a text editor.
    4. Add the following lines:
    # Options to avoid "ORA-12705: Cannot access NLS data files or invalid environment specified."
AddVMOption -Duser.language=en
AddVMOption -Duser.region=US
AddVMOption -Duser.country=en
    1. Restart SQL Developer