Search This Blog

Tuesday, July 31, 2018

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.

No comments:

Post a Comment

You cannot complete this task because one of the following events caused a loss of page data: A system failure has occurred "Front end is locked after 12.2 upgrade"

  If you have upgraded to Oracle E-Business Suite 12.2.10 Release Update Pack from Oracle E-Business Suite 12.2.6 Release Update Pack (or ea...