All about txkCfgUtlfileDir.pl utility in Oracle 19c for EBS database:
Introduction:
Recently, we upgraded our ERP system from version 12.1.0.2 to Oracle 19c in an OCI environment. One challenge we encountered was the deprecation of the utl_file_dir parameter. Oracle has introduced a new approach to manage this functionality. In this blog, we’ll explore how to implement this new method in an OCI environment.
Step1:
The txkCfgUtlfileDir.pl script in get mode, is used to update the value of the supplemental utl_file_dir parameter.
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=getUtlFileDir -servicetype=opc
Step2:
Remove/Add any directories as per your requirement from the newly created “ERPDB_utlfiledir.txt”.
$ cat $ORACLE_HOME/dbs/ERPDB_utlfiledir.txt
/u01/app/oracle/product/19.0.0.0/dbhome_1/temp/ERPDB
/u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/outbound/ERPDB_oci-ebsdbserver01
/u01/app/oracle/product/19.0.0.0/dbhome_1/temp/ERPDB
Step3:
To invoke txkCfgUtlfileDir.pl in set mode.
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -servicetype=opc
Step4:
Copy below directory to appsutil directory.
$ cd $ORACLE_HOME/jdk
$ cp -rpf jre/ $ORACLE_HOME/appsutil/
Step4:
Invoke the txkCfgUtlfileDir.pl script in syncUtlFileDir mode.
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=syncUtlFileDir
Step5:
Run autoconfig on Apps Tier.
Conclusion:
Now you have successfully added/modified new directories for utl_file_dir parameter in 19c Oracle ERP database.
