R12 rup3 做autocfg报错0RA-12705-优快云博客

本文记录了在Oracle数据库中使用AutoConfig时遇到的错误报告及解决方案，详细描述了错误发生的过程，包括环境变量设置问题，特别是NLS10配置错误导致的ORA-12705错误，并提供了正确的环境变量设置方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[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/PROD/db/tech_st/10.2.0/appsutil/install/PROD_oper
afdbprf.sh INSTE8_PRF 1

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

按照clone要求做autocfg

Copy AutoConfig to the RDBMS ORACLE_HOME
Update the RDBMS ORACLE_HOME file system with the AutoConfig files by performing the following steps:
- On the application tier (as the APPLMGR user):
  - Log in to the APPL_TOP environment (source the environment file)
  - Create appsutil.zip file
    perl /bin/admkappsutil.pl
  - This will create appsutil.zip in /admin/out
- On the database tier (as the ORACLE user):
  - Copy or FTP the appsutil.zip file to the
  - cd
  - unzip -o appsutil.zip
Run AutoConfig on the database tier

在database tier的时候报上面的错误，单独运行其中脚本又出现错误信息如下：

[oraprod@oper PROD_oper]$ ./afdbprf.sh

afdbprf.sh started at Tue Nov 6 18:50:59 CST 2007

The environment settings are as follows ...

ORACLE_HOME : /u01/oracle/PROD/db/tech_st/10.2.0
ORACLE_SID : PROD
PATH : /u01/oracle/PROD/db/tech_st/10.2.0/perl/bin:/u01/oracle/PROD/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PROD/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/PROD/db/tech_st/10.2.0/perl/bin:/u01/oracle/PROD/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/PROD/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/oraprod/bin
Library Path : /u01/oracle/PROD/db/tech_st/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/PROD/db/tech_st/10.2.0/lib:/usr/dt/lib:/u01/oracle/PROD/db/tech_st/10.2.0/ctx/lib

Executable : /u01/oracle/PROD/db/tech_st/10.2.0/bin/sqlplus

Enter the APPS username: apps

Enter the APPS password:

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Nov 6 18:51:03 2007

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

根据错误信息，怀疑是环境变量中的NLS10有问题，登录也报127错误

[oraprod@oper ~]$ env|grep NLS10
ORA_NLS10=/u01/oracle/PROD/db/tech_st/10.2.0/ocommon/nls/admin/data

明显不对，没有ocommon这个目录不说，ORA_NLS10这个变量对应的位置应该是ORACLE_HOME/nls/data/9idata

修改环境变量，通过

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/594850/viewspace-577993/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/594850/viewspace-577993/