Autoconfig error in 19C for txkCfgUtlfileDir.sh

 

Error Details:

Database was cloned from source to target environment. While running autoconfig in DB tier  autoconfig is failing with following error

 Environment Details:- 

Application : EBS R12.1.3

Database : 19.9.0

sh adautocfg.sh  Enter the APPS user password: The log file for this session is located at: /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/EBSCLONE_ccuine105/07172228/adconfig.log   AutoConfig is configuring the Database environment... …. …. Updating rdbms version in Context file to db19 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ...   AutoConfig completed with errors.     Logfiles shows:-   [CVM Error Report] The following report lists errors encountered during CVM Phase       <filename>  <return code where appropriate>   /u01/ebsclone/db/tech_st/19.3.0/appsutil/bin/txkCfgUtlfileDir.sh  1   No of scripts failed in CVM phase: 1     AutoConfig is exiting with status 1

 

 

Solution:-

First make sure following directories exist in target location. If its not present, create them.

 

<19c Oracle Base>/temp/<PDB NAME>

<19c ORACLE_HOME>/appsutil/outbound/<context name>

 

Make sure $APPLPTMP value in application tier is referenced in utl_file_dir supplemental parameter. The path should be correct

and should be the first entry in utl_file_dir supplemental parameter.

 

[ebscloneapp@ccuine105 EBSCLONE_ccuine106]$ echo $APPLPTMP

/ebs/EBS19C/db/tech_st/temp/EBS19C

 

mkdir -p /u01/ebsclone/db/tech_st/temp/EBSCLONE

 

[ebsclonedb@ccuine105 19.3.0]$ . EBSCLONE_ccuine105.env

[ebsclonedb@ccuine105 19.3.0]$ sqlplus apps/apps@EBSCLONE

 

 

SQL> select value from v$parameter where name='utl_file_dir';   VALUE -------------------------------------------------------------------------------- /ebs/EBS19C/db/tech_st/temp/EBS19C,/ebs/EBS19C/db/tech_st/temp/EBS19C, ,/usr/tmp/GSTR1_File_Backup,/usr/tmp/PREFERRED/OUT/NEW,/tmp,/usr/tmp/ewaybill,/var/tmp,/u01/ebsc lone/db/tech_st/temp/EBSCLONE

 

Now, since we cloned this instance from a source instance, there are many paths that dont exist in this server.

So we need to remove them from database else  txkCfgUtlfileDir script will fail during syncronization phase.

 

First, retrieve the list of directory paths that are currently stored in the UTL_FILE_DIR supplemental parameter. To do so,

source the PDB environment file and then run the txkCfgUtlfileDir.pl script in getUtlFileDir mode using the following commands:

 

[ebsclonedb@ccuine105 19.3.0]$ . EBSCLONE_ccuine105.env

 

[ebsclonedb@ccuine105 dbs]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=getUtlFileDir -servicetype=onpremise Enter the APPS Password:   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_05_17_2021/txkCfgUtlfileDir.log Program :  started @ Sat Jul 17 23:05:19 2021   *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_05_17_2021/txkCfgUtlfileDir.log     Script Name    : txkCfgUtlfileDir.pl Script Version : 120.0.12010000.9 Started        : Sat Jul 17 23:05:20 IST 2021   Log File       : /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_05_17_2021/txkCfgUtlfileDir.log   Context file: /u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml exists.   ==============================================================================   Successfully generated the below file with UTL_FILE_DIR content: /u01/ebsclone/db/tech_st/19.3.0/dbs/EBSCLONE_utlfiledir.txt   ==============================================================================     Completed        : Sat Jul 17 23:05:22 IST 2021     Successfully Completed the script ERRORCODE = 0 ERRORCODE_END

 

 

Edit the created EBSCLONE_utlfiledir.txt file, as this contains all the directories list.

Remove and add any directories as per your requirement. Make sure if any directory is being added they are physically

present in the server. Also , if  deleting any directory they should not be referenced by application.

 

run the txkCfgUtlfileDir.pl script in setUtlFileDir mode using the following command:

 

ebsclonedb@ccuine105 dbs]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -servicetype=onpremise Enter the APPS Password:   Enter the SYSTEM Password:   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_08_56_2021/txkCfgUtlfileDir.log Program :  started @ Sat Jul 17 23:09:02 2021   *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_08_56_2021/txkCfgUtlfileDir.log     Script Name    : txkCfgUtlfileDir.pl Script Version : 120.0.12010000.9 Started        : Sat Jul 17 23:09:02 IST 2021   Log File       : /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_08_56_2021/txkCfgUtlfileDir.log   Context file: /u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml exists.   Value for s_applptmp on Apps Tier nodes is valid       Completed        : Sat Jul 17 23:09:07 IST 2021     Successfully Completed the script ERRORCODE = 0 ERRORCODE_END

 

 copy $ORACLE_HOME/jdk/jre folder inside $ORACLE_HOME/appsutil directory.

[oracle@ccuine106 jdk]$ cd $ORACLE_HOME/jdk

[oracle@ccuine106 jdk]$ cp -rpf jre/ $ORACLE_HOME/appsutil/

Finally, synchronize the modified UTL_FILE_DIR value with the database context file.

 

Source PDB Environment file

[ebsclonedb@ccuine105 19.3.0]$ . EBSCLONE_ccuine105.env

 

[ebsclonedb@ccuine105 ebsclone]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=syncUtlFileDir Enter the APPS Password:   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/txkCfgUtlfileDir.log Program :  started @ Sat Jul 17 23:14:42 2021   *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/txkCfgUtlfileDir.log     Script Name    : txkCfgUtlfileDir.pl Script Version : 120.0.12010000.9 Started        : Sat Jul 17 23:14:42 IST 2021   Log File       : /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/txkCfgUtlfileDir.log   Context file: /u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml exists. Execute SYSTEM command : /u01/ebsclone/db/tech_st/19.3.0/perl/bin/perl /u01/ebsclone/db/tech_st/19.3.0/appsutil/bin/adconfig.pl -contextfile=/u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml ************** -log=/u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/acfg_log_Sat_Jul_17_23_14_41_2021.log   The log file for this session is located at: /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/acfg_log_Sat_Jul_17_23_14_41_2021.log   AutoConfig is configuring the Database environment...   AutoConfig will consider the custom templates if present.         Using ORACLE_HOME location : /u01/ebsclone/db/tech_st/19.3.0         Classpath                   : :/u01/ebsclone/db/tech_st/19.3.0/jdbc/lib/ojdbc8.jar:/u01/ebsclone/db/tech_st/19.3.0/appsutil/java/xmlparserv2.jar:/u01/ebsclone/db/tech_st/19.3.0/appsutil/java:/u01/ebsclone/db/tech_st/19.3.0/jlib/netcfg.jar:/u01/ebsclone/db/tech_st/19.3.0/jlib/ldapjclnt19.jar           Using Context file          : /u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.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 db19 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ...   AutoConfig completed successfully.     Completed        : Sat Jul 17 23:15:11 IST 2021     Successfully Completed the script ERRORCODE = 0 ERRORCODE_END

 

 

Now re run autoconfig on DB Tier again and it should successfully run.