While Running Autoconfig txkCfgUtlfileDir.sh directory does not exist



When running adconfig.sh in database, getting below error

Error:
WARNING: [CVM Error Report]
The following report lists errors encountered during CVM Phase

/u01/app/oracle/product/19c/db_home1/appsutil/bin/txkCfgUtlfileDir.sh 1

No. of scripts failed in CVM phase: 1


Solution :

1) Check adconfig.log file

ERROR DESCRIPTION:
(FATAL ERROR
PROGRAM : (/u01/app/oracle/product/19c/db_home1/appsutil/bin/txkCfgUtlfileDir.pl)
TIME : Sat Jul 22 10:00:39 2023
FUNCTION: main::checkUtlFileDir [ Level 1 ]
ERRORMSG: Directory /u01/TEST/temp/EBSTEST does not exist.
)
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

2) Create directory /u01/TEST/temp/EBSTEST

run below script to add this directory in utl_file_dir

perl /u01/app/oracle/product/19c/db_home1/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/oracle/product/19c/db_home1/appsutil/EBSTEST_funebs122.xml -oraclehome=/u01/app/oracle/product/19c/db_home1 -outdir=/u01/app/oracle/product/19c/db_home1/appsutil/log -mode=addUtlFileDir
Enter the APPS Password:

Enter the SYSTEM Password:

Enter the new OS path to be added to UTL_FILE_DIR: /u01/TEST/temp/EBSTEST

Script Name : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.11
Started : Sat Jul 22 13:08:30 +03 2023

Log File : /u01/app/oracle/product/19c/db_home1/appsutil/log/TXK_UTIL_DIR_Thu_Apr_21_13_08_14_2023/txkCfgUtlfileDir.log

Context file: /u01/app/oracle/product/19c/db_home1/appsutil/EBSTEST_funebs122.xml exists.

Completed : Sat Jul 22 13:08:43 +03 2023

Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END

3) Sync UTL

perl /u01/app/oracle/product/19c/db_home1/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/oracle/product/19c/db_home1/appsutil/EBSTEST_funebs122.xml -oraclehome=/u01/app/oracle/product/19c/db_home1 -outdir=/u01/app/oracle/product/19c/db_home1/appsutil/log -mode=syncUtlFileDir

4) Run adconfig.sh again





If you like please follow and comment