Error Details:
Database
was cloned from source to target environment. While running autoconfig in DB tier
autoconfig is failing with following
error
|
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 |
[oracle@ccuine106 jdk]$ cd $ORACLE_HOME/jdk
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.
