EBS 19c utl_file

get utl_file目录

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

vi $ORACLE_HOME/dbs/DLUAT_utlfiledir.txt

mkdir -p /dlebs/uat/temp
mkdir -p /dlebs/uat/db/temp/DLUAT

/dlebs/uat/temp
/dlebs/uat/db/temp/DLUAT

set utl_file目录

此步骤的目的是synchronize the modified UTL_FILE_DIR value with the database context file，将新设置的utl_file_dir参数和数据库$CONTEXT_FILE同步

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

createDirObject

grep -i s_outbound_dir $CONTEXT_FILE
         <OUTBOUND_DIR oa_var="s_outbound_dir">/dlebs/uat/db/temp/DLUAT</OUTBOUND_DIR>

mkdir -p /dlebs/uat/db/temp/DLUAT

perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE \
-oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=createDirObject

Enter the APPS Password:

Enter the SYSTEM Password:

Enter the OS path for which directory object needs to be created: /dlebs/uat/db/temp/DLUAT

syncUtilFileDir

source /dlebs/uat/db/19.0.0.0/DLUAT_fmsdluatdb1.env
perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -skipdirvalidation=Yes 

source /dlebs/uat/db/19.0.0.0/DLUAT_fmsdluatdb2.env
perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -skipdirvalidation=Yes 

source /dlebs/uat/db/19.0.0.0/DLUAT_fmsdluatdb*.env
cd $ORACLE_HOME/appsutil/bin
perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=syncUtlFileDir -skipautoconfig=yes

txkCfgUtlfileDir.sh  1

sqlplus apps/ApPsDl#PwD_0327@DLUAT
exec fnd_conc_clone.setup_clean;
commit;

alter session set container=DLUAT;
truncate table link$;
commit;

source /dlebs/uat/db/19.0.0.0/DLUAT_fmsdluatdb*.env
cd $ORACLE_HOME/appsutil/bin
perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -skipdirvalidation=Yes

source /dlebs/uat/db/19.0.0.0/DLUAT_fmsdluatdb*.env
cd $ORACLE_HOME/appsutil/bin
perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=syncUtlFileDir -skipautoconfig=yes