Perform the following steps to set the target UTL_FILE_DIR values in the database.
1.Source the environment file
$ source <CONTEXT_NAME>.env
2.Obtain the existing value for the UTL_FILE_DIR using the following commands:
perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \ -oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=getUtlFileDir
This will create a text file <DB_NAME>_utilfiledir.txt under the $ORACLE_HOME/dbs directory with references to the target oracle home.
3.Review the <DB_NAME>_utilfiledir.txt and edit the values ,if required .
4.Execute the following command to store the updated values for UTL_FILE_DIR in the database.
cd <ORACLE_HOME>/appsutil/bin
perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \ -oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log \
-mode=setUtlFileDir
This command will validate the directory paths provided in the <DB_NAME>_utilfiledir.txt.
5.Execute the below command to create a directory object for the outbound directory (Pointed to by the s_outbound_dir context variable in the database tier context file)
perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \- oraclehome= <ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=createDirObject
When prompted for the OS patch for the directory object to be created ,enter the values of the s_outbound_dir context variable in the database tier context file .
6.Sync up the values of UTL_FILE_DIR in the database tier context file by running the following command.
perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \
- oraclehome=<ORACLE_HOME> -outdir= <ORACLE_HOME>/appsutil/log - mode=syncUtlFileDir \ -skipautoconfig=yes
Now source the PDB environment file in the database tier and re-run the autoconfig .
..........................................................................................................Thank you
When prompted for the OS patch for the directory object to be created ,enter the values of the s_outbound_dir context variable in the database tier context file .
6.Sync up the values of UTL_FILE_DIR in the database tier context file by running the following command.
perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \
- oraclehome=<ORACLE_HOME> -outdir= <ORACLE_HOME>/appsutil/log - mode=syncUtlFileDir \ -skipautoconfig=yes
Now source the PDB environment file in the database tier and re-run the autoconfig .
..........................................................................................................Thank you