Autoconfig Database Error after Database Upgrade: ORA-12705: Cannot Access NLS Data Files Or Invalid Environment Specified

(Doc ID 2165613.1)

Last updated on AUGUST 07, 2016

Applies to:

Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Upgrade related issues

During database upgrade project from RDBMS 11g to RDBMS 12cR1:
When attempting to run Autoconfig as per Step 27: Implement and run AutoConfig, from Note: Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1),
the following error occurs.

ERROR
-----------------------
[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: /oracle/db/tech_st/12.1.0.2/appsutil/install/ERPPROD_erpproddb
  afdbprf.sh INSTE8_PRF 1

AutoConfig is exiting with status 3

----

afdbprf.sh started at Tue Jul 26 11:24:40 AST 2016

The environment settings are as follows ...

ORACLE_HOME : /oracle/db/tech_st/12.1.0.2
ORACLE_SID : ERPPROD
PATH : /usr/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oradb/.local/bin:/home/oradb/bin:/oracle/db/tech_st/12.1.0.2/bin:/oracle/db/tech_st/12.1.0.2/OPatch:.
Library Path : /oracle/db/tech_st/12.1.0.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/oracle/db/tech_st/12.1.0.2/lib:/usr/dt/lib:/oracle/db/tech_st/12.1.0.2/ctx/lib

Executable : /oracle/db/tech_st/12.1.0.2/bin/sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 26 11:24:40 2016

Copyright (c) 1982, 2014, 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

ERRORCODE = 1 ERRORCODE_END



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform the steps from Doc ID 1524398.1 -- up to (and including) Step 27: Implement and run AutoConfig

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete database upgrade.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms