Posted by
satish on
Feb 28, 2023; 12:39pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/txkCfgUtlfileDir-sh-19c-EBS-database-tp11669.html
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