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

Upgare Oracle E-Business Suite R12.0.0 to R12.0.4 After runing adautocfg.sh geting Error ORA-12705: Cannot access NLS data files or invalid environment specified

Autoconfig Log

[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:


[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/VIS/db/tech_st/10.2.0/appsutil/install/VIS_sys38
afdbprf.sh INSTE8_PRF 1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/VIS/db/tech_st/10.2.0/appsutil/install/VIS_sys38
adcrobj.sh INSTE8_APPLY 1


AutoConfig is exiting with status 2


adcrobj.sh started at Sun Nov 16 02:21:23 IST 2008

Parameters passed are : -nopromptmsg

The environment settings are as follows ...

ORACLE_HOME : /u01/oracle/VIS/db/tech_st/10.2.0
ORACLE_SID : VIS
TWO_TASK :
PATH : /u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/VIS/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/VIS/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin
Library Path : /u01/oracle/VIS/db/tech_st/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/VIS/db/tech_st/10.2.0/lib:/usr/dt/lib:/u01/oracle/VIS/db/tech_st/10.2.0/ctx/lib

SQLPLUS Executable : /u01/oracle/VIS/db/tech_st/10.2.0/bin/sqlplus


SQL*Plus: Release 10.2.0.2.0 - Production on Sun Nov 16 02:21:23 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.


Solution:


1.Check $ORA_NLS10
2.Check ORACLE_HOME/nls/data/9idata
3.Check xml file in the Parameter s_db_oranls
/u01/oracle/VIS/db/tech_st/10.2.0/ocommon/nls/admin/data
Change $ORA_NLS10 Path
/u01/oracle/VIS/db/tech_st/10.2.0/nls/data/9idata

or

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

Create nls/data/9idata directory

cd $ORACLE_HOME/nls/data/old

perl cr9idata.pl

Creating directory /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata ...
Copying files to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata!

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata