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

Autoconfig failed with the error below.

Error :

WARNING: [AutoConfig Error Report]

The following report lists errors AutoConfig encountered during each

phase of its execution.  Errors are grouped by directory and phase.

The report format is:

      <filename>  <phase>  <return code where appropriate>

  [SETUP PHASE]

  AutoConfig could not successfully execute the following scripts:

    Directory: /dbtier/oracle/CLONE/product/11.2.0/dbhome_1/perl/bin/perl -I /dbtier/oracle/CLONE/product/11.2.0/dbhome_1/perl/lib/5.10.0 -I /dbtier/oracle/CLONE/product/11.2.0/dbhome_1/perl/lib/site_perl/5.10.0 -I /dbtier/oracle/CLONE/product/11.2.0/dbhome_1/appsutil/perl /dbtier/oracle/CLONE/product/11.2.0/dbhome_1/appsutil/scripts/CLONE_proddb

      adchknls.pl             INSTE8_SETUP       1

Looking for the directory : /dbtier/oracle/CLONE/product/11.2.0/dbhome_1/nls/data/9idata 
Directory does not exist

Looking for file : /dbtier/oracle/CLONE/product/11.2.0/dbhome_1/nls/data/old/cr9idata.pl
File exists


Reason :

Below step were not executed after database installation.

perl $ORACLE_HOME/nls/data/old/cr9idata.pl


Solution :

To complete the autoconfig execute following steps:

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

1. Run the $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.

query to find timezone (DST) version in oracle database 11.2.0.4?

Hello DBA's,

Use the below query to find daylight savings timezone version in the database. 

select * from v$timezone_file; 

Output :

SQL> select * from v$timezone_file;

timezlrg_18.dat              18

It shows that the database in version 18 and oracle home has been patched with DSTv18.