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

Published on by Advait

While running autoconfig in oracle apps on database side, you might encounter this error. Also you can see this when you do sqlplus from command prompt.

Cause: 

Either your NLS_LANG parameter is not set correctly or NLS_ORA10 parameter is not set correctly.

Solution :

check $ORA_NLS10 path. This should point to ORACLE_HOME/nls/data/9idata

if this is not set correct, then you need to set the same manually using export command. Also if this is an oracle application database ( either 11i or R12), then make sure to change the variable s_db_oranls in CONTEXT_FILE and then run autoconfig.

If  ORACLE_HOME/nls/data/9idata path is not present then you can create the same using $ORACLE_HOME/nls/data/old/cr9idata.pl script. Run this script and it will create the desired directories and after that set ORA_NLS10 parameter.

If this doesn’t resolve the issue then you need to check NLS_LANG parameter setting. This should be (Language)_(Territory).(character set). Example American_America.UTF8.

Hope this helps !!

4 thoughts on “ORA-12705: Cannot access NLS data files or invalid environment specified”

  4. Hi,

    I’m facing same issue while running adcfgclone/autoconfig on application tier. Please help me to fix the issue.

    Creating the DBC file…
    java.sql.SQLException: ORA-12705: Cannot access NLS data files or invalid environment specified
    ORA-06512: at “SYS.DBMS_SESSION”, line 177
    ORA-06512: at line 1
    – Database error modifying the server

    ADD call failed with exit code 1

    Updating Server Security Authentication
    java.sql.SQLException: Invalid number format for port number
    Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
    Updating Server Security Authentication failed with exit code 1

    Thanks

    Reply

Leave a comment