【Oracle ERP Note 】Looking for the directory : 9idata Directory does not exist

Problem

當執行 adconfig.sh 時，系統出現 AutoConfig completed with errors 此錯誤。


[proddba]$ $ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=/u01/proddb/proddb/11.2.2/appsutil/PROD_erp.xml
Enter the APPS user password:
The log file for this session is located at: /u01/proddb/proddb/11.2.2/appsutil/log/PROD_erp/04161914/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/proddb/proddb/11.2.2
        Classpath                   : :/u01/proddb/proddb/11.2.2/jdbc/lib/ojdbc5.jar:/u01/proddb/proddb/11.2.2/appsutil/java/xmlparserv2.jar:/u01/proddb/proddb/11.2.2/appsutil/java:/u01/proddb/proddb/11.2.2/jlib/netcfg.jar:/u01/proddb/proddb/11.2.2/jlib/ldapjclnt11.jar

        Using Context file          : /u01/proddb/proddb/11.2.2/appsutil/PROD_erp.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed with errors.



查看 /u01/proddb/proddb/11.2.2/appsutil/log/PROD_erp/04161914/adconfig.log 此 log時，發現有紀錄以下錯誤:


##########################################################################
             Validating information needed for NLS........
##########################################################################
DATABASE version : db112

Looking for the directory : /u01/proddb/proddb/11.2.2/nls/data/9idata
Directory does not exist

Looking for file : /u01/proddb/proddb/11.2.2/nls/data/old/cr9idata.pl
File exists

In a 11g instance, this amounts to either of the following
        - an uncertified version of 11g for Apps
        - an unsuccessful installation
Please refer to Metalink note: 883874.1 for details on further steps
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.
****************************************************


Soution

參考 Oracle 文件 AutoConfig is Failing with status 4 for a New Database with NLS Environment Error ORA-12705 (DOC ID 1612017.1) , 其建議下列步驟:


1. Run the $ORACLE_HOME/nls/data/old/cr9idata.pl scipt to create the $ORACLE_HOME/nls/data/9idata directory

2. After creating the directory, make sure 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


依舊，解決方式為先 shutdown AP，再以 proddba 用戶執行 cr9idata.pl此 script。執行完，系統會新增一個目錄為 9idata。以下為整個解決步驟的Action Plan。


0. Login as prodmgr
# su - prodmgr
$ cd $APPL_TOP
$ . ./APPSPROD_erp.env

1. disable Maintenance Mode
$ adadmin

2. shutdown AP Tier
$ $INST_TOP/admin/scripts/adstpall.sh

3. generate 9idata directory
$ perl /u01/proddb/proddb/11.2.2/nls/data/old/cr9idata.pl

4. set ORA_NLS10 environment
$ ORA_NLS10=/u01/proddb/proddb/11.2.2/nsl/data/9idata

5. execute the command, adautocfg.sh on db tier
$ sh $ORACLE_HOME/appsutil/scripts/PROD_erp/adautocfg.sh


跑完 adautocfg.sh 之後，會更新 PROD_erp.env 檔案，而以 $ echo $ORA_NLS10 時，這環境變數指向   /u01/proddb/proddb/11.2.2/nls/data/9idata