6 Replies Latest reply on Sep 27, 2018 11:56 AM by Beauty_and_dBest

    Synchronize values of APPLPTMP with UTL_FILE_DIR

    Beauty_and_dBest

      Upgrade EBS 12.0.6  to 12.2.7

       

      Oracle® E-Business Suite

      Upgrade Guide

      Release 12.0 and 12.1 to 12.2

      Part No. E73540-04

      July 2018

       

       

      Hi ALL,

       

      In page 104, section 4-42 Oracle E-Business Suite Upgrade Guide, mentioned below requirement.

       

      5. Synchronize values of APPLPTMP with UTL_FILE_DIR for PL/SQL based

      Concurrent Requests (required)

       

      Concurrent processing (CP) may run PL/SQL (inside of the database) that

      creates output and log files using the utl_file package. On all CP nodes, ensure that the

      $APPLPTMP environment variable is set to the first directory listed in the UTL_FILE_DIR

      parameter from the database init.ora. If you use a RAC database, then $APPLPTMP

      should point to a directory on a shared file system visible to all the RAC nodes.

      This ensures that CP can locate the output and log files created from PL/SQL.

       

       

      I do not understand the above statement?

       

      I check our database utl_file_dir which shown below:

       

      SQL> show parameter utl_file

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      utl_file_dir                         string      /usr/tmp, /tmp, /mnt/data/d01/

                                                       oracle/PPAPROD/db/tech_st/10.2

                                                       .0/appsutil/outbound/PPAPROD,

                                                       /usr/tmp

       

      So the first dir is  > /usr/tmp ?

       

      But when I echo $APPLTMP  in our apps-tier, I got below:

       

      $ echo $APPLTMP

      /u01/oracle/PPAPROD/fs1/inst/apps/PPAPROD_oraapps-2/appltmp

       

      So, how can I link it to the database folder, if the disk is not shared?

       

       

      Please shed lights....

       

       

      Kind regards,

      jc