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.

4 comments:

  1. Hi Soumya,
    I can see that 5 paths are mentioned in the "utl_file_dir" parameter, exceeding 250 character limit for the same parameter within context file. Actually how many paths are expected for this purpose?

    ReplyDelete