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

When configuring an Oracle Database in EBS environment adcfgclone/autoconfig fails at below

adchknls.pl INSTE8_SETUP 1

Directory /u01/app/oracle/product/11.2.0.4/dbhome_1/nls/data/9idata does not exist.

DATABASE version : db112

Looking for the directory : /u01/app/oracle/product/11.2.0.4/dbhome_1/nls/data/9idata
Directory does not exist

Looking for file : /u01/app/oracle/product/11.2.0.4/dbhome_1/nls/data/old/cr9idata.pl
File exists

In a 11g instance, this amounts to either of the following
- an uncertified version of 11g for Apps
- an unsuccessful installation
Please refer to Metalink note: 883874.1 for details on further steps
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

Solution

On the database server node, as the owner of the Oracle RDBMS file system and database instance,

1. Run the perl $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory.

2. After creating the directory, make sure that the ORA_NLS10 environment variable is set to the full path of the 9idata directory whenever you enable the 11g Oracle home.

3. Verify there are files in 9idata directory.

4. Re-run autoconfig.