How To Set APPLPTMP and UTL_FILE_DIR

 

How To Set APPLPTMP and UTL_FILE_DIR 

How to set APPLPTMP and UTL_FILE_DIR for Run/Patch systems?

If using another instance on same node, how to separate APPLPTMP.

Run/Patch filesystems are switched in ADOP cutover phase.
Therefore, need to implement the conditions of the following for APPLPTMP and UTL_FILE_DIR.

• Set the path to outside of filesystem (fs1/fs2).
• Set the same APPLPTMP value for Run and Patch file systems. Set the APPLPTMP value as the first value in utl_file_dir.
• If using another instance on same node, create new directory to be able to separate for each instance.

Good example
   APPLPTMP of fs1 : /home/oracle/PROD/temp
   APPLPTMP of fs2 : /home/oracle/PROD/temp
   utl_file_dir : /home/oracle/PROD/temp, /usr/tmp

Bad example
   APPLPTMP of fs1 : /home/oracle/PROD/fs1/EBSapps/comn/temp
   APPLPTMP of fs2 : /home/oracle/PROD/fs2/EBSapps/comn/temp
   utl_file_dir : /home/oracle/PROD/fs1/EBSapps/comn/temp, /usr/tmp

NOTE:
If APPLPTMP is set to the directory in the file systems, they will be synchronized in ADOP prepare phase.
This will cause the error reported　Document:2099179.1 in Document:2099179.1 while running ADOP cutover phase.

To change the APPLPTMP:

  1. Please use the OAM context editor to edit the application context file and change APPLPTMP value.
  2. Run the autoconfig application tier.

To change the UTL_FILE_DIR:

  1. Edit the database context file using OAM (not manually - this is not supported) and save the new context file.
  2. Keeping database and listener up, shutdown the application.
  3. Remove the old init.ora.
  4. Run autoconfig database tier and let autoconfig generate a brand new init.ora.
  5. Bounce database.

Ref :- (Doc ID 2141438.1)