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
Leave a Reply