txkCfgUtlfileDir.sh 19c EBS database

[satish]

Dear Erman,

Autoconfig in database failed even when all the utl directories exists.


This is cloned instance a month back. We have all directories required.

WARNING: [CVM Error Report]
The following report lists errors encountered during CVM Phase<filename>  <return code where appropriate>
  /u01/SUPPDB/19.3.0/appsutil/bin/txkCfgUtlfileDir.sh  1 No. of scripts failed in CVM phase: 1  
AutoConfig is exiting with status 1 AutoConfig execution completed on Tue Feb 28 17:27:53 2023 
Time taken for AutoConfig execution to complete : 0 mins  41 secs


perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=getUtlFileDir -servicetype=onpremise

Script Name    : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.11
Started        : Tue Feb 28 17:20:17 IST 2023 
Log File       : /u01/SUPPDB/19.3.0/appsutil/log/TXK_UTIL_DIR_Tue_Feb_28_17_20_14_2023/txkCfgUtlfileDir.log 
Context file: /u01/SUPPDB/19.3.0/appsutil/SUPPDB_erpsupportdb.xml exists.
 ============================================================================== 
Successfully generated the below file with UTL_FILE_DIR content:
/u01/SUPPDB/19.3.0/dbs/SUPPDB_utlfiledir.txt
 ============================================================================== 
Completed        : Tue Feb 28 17:20:20 IST 2023 
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END


[orasupp@erpsupportdb 19.3.0]$ cat /u01/SUPPDB/19.3.0/dbs/SUPPDB_utlfiledir.txt
#############################################################################
#         This file stores the UTL FILE DIR parameter values used           #
#                    by various EBS product teams                           #
#                                                                           #
#       ***** DO NOT CHANGE THE NAME OR LOCATION OF THIS FILE *****         #
#                                                                           #
# IMPORTANT NOTES:                                                          #
# ================                                                          #
#                                                                           #
# 1. OS path should not be a symbolic link                                  #
#                                                                           #
# 2. OS path given in the list should physically exist with proper          #
#    permissions                                                            #
#                                                                           #
# 3. OS path /usr/tmp which generally is a symbolic link is replaced with   #
#    <ORACLE_BASE>/temp/<PDB_NAME>                                          #
#                                                                           #
#    Make sure that OS path <ORACLE_BASE>/temp/<PDB_NAME> exists            #
#                                                                           #
# 4. <APPLPTMP> variable on Apps Tier should match with one of the OS paths #
#    in the list. Otherwise you need to modify <APPLPTMP> on all Apps tiers #
#    and run Autoconfig                                                     #
#                                                                           #
# 5. Ensure that all the paths defined in this file exist physically on the #
#    server                                                                 #
#                                                                           #
# 6. Maximum allowed length of UTL_FILE_DIR parameter (combined length of   #
#    all paths separated by commas) is 4000 characters, hence ensure that   #
#    value does not exceed the limit                                        #
#                                                                           #
#===========================================================================#
# For reference, original contents of UTL_FILE_DIR without any updates are  #
# retained in below file:                                                   #
#                                                                           #
# /u01/SUPPDB/19.3.0/appsutil/log/TXK_UTIL_DIR_Tue_Feb_28_17_20_14_2023/SUPPDB_utlfiledir.txt
############################################################################# 
/u01/SUPPDB/temp/SUPPDB
/u01/SUPPDB/temp/SUPPDB
/u01/SUPPDB/19.3.0/appsutil/outbound/SUPPDB_erpsupportdb
/u01/SUPPDB/temp/SUPPDB
[orasupp@erpsupportdb 19.3.0]$





perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -servicetype=onpremise

Script Name    : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.11
Started        : Tue Feb 28 17:24:18 IST 2023 Log File       : /u01/SUPPDB/19.3.0/appsutil/log/TXK_UTIL_DIR_Tue_Feb_28_17_24_09_2023/txkCfgUtlfileDir.log Context file: /u01/SUPPDB/19.3.0/appsutil/SUPPDB_erpsupportdb.xml exists. Value for s_applptmp on Apps Tier nodes is valid  Completed        : Tue Feb 28 17:24:26 IST 2023 
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END

We have the value in s_appltmp in CONTEXT FILE and it is valid as in above output.


We have these directories

[orasupp@erpsupportdb 19.3.0]$ ls -ld /u01/SUPPDB/temp/SUPPDB
drwxrwxrwx 2 orasupp dba 86016 Feb 28 11:54 /u01/SUPPDB/temp/SUPPDB
[orasupp@erpsupportdb 19.3.0]$ ls -ld /u01/SUPPDB/19.3.0/appsutil/outbound/SUPPDB_erpsupportdb
drwxrwxrwx 2 orasupp dba 4096 Dec 13 17:23 /u01/SUPPDB/19.3.0/appsutil/outbound/SUPPDB_erpsupportdb

Application:

[applsupp@erpsupport ~]$ grep s_applptmp $CONTEXT_FILE
<APPLPTMP oa_var="s_applptmp" osd="UNIX">/u01/SUPPDB/temp/SUPPDB</APPLPTMP>


Thanks,
Satish

[satish]

Dear Erman,

Not sure how autoconfig completed initially and why it errored out now. We identifed the issue s_db_util_filedir pointing to /usr/tmp

         <dbutilfiledir oa_var="s_db_util_filedir" osd="unix">/usr/tmp</dbutilfiledir>

We modified

[orasupp@erpsupportdb dbs]$ grep "s_db_util_filedir" $CONTEXT_FILE
         <dbutilfiledir oa_var="s_db_util_filedir" osd="unix">/u01/SUPPDB/temp/SUPPDB,/u01/SUPPDB/temp/SUPPDB,/u01/SUPPDB/19.3.0/appsutil/outbound/SUPPDB_erpsupportdb,/u01/SUPPDB/temp/SUPPDB</dbutilfiledir>
[orasupp@erpsupportdb dbs]$


and autoconfig completed successfully.

Thanks,
Satish

[ErmanArslansOracleBlog]

Okay. Good..

Did you read the following? ->

****OS path /usr/tmp which generally is a symbolic link is replaced with   #
#    <ORACLE_BASE>/temp/<PDB_NAME>                                          #
#                                                                           #
#    Make sure that OS path <ORACLE_BASE>/temp/<PDB_NAME> exists