7 Replies Latest reply on Jul 10, 2018 3:37 AM by Beauty_and_dBest

    How to sync APPLTMP with UTL_FILE_DIR

    Beauty_and_dBest

      EBS 12.2.x

       

      Hi ALL,

       

      I can not understand what the docs is explaining

       

      EBS Docs requires to:

      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 on both the File Systems is set to the first directory listed in the UTL_FILE_DIR parameter from the database's init.ora

       

      How can the UTL_FILE_DIR in the database able to write folder that belongs to the apps Tier which is on another node?

       

      For example the value of APPLPTMP is:

      [apppsar@test01 ~]$ echo $APPLPTMP

      /u02/orapsar/PSAR/12.1.0/appsutil/outbound/PSAR_test01

       

      And the value of UTL_FILE_DIR is:

      SQL> show parameter utl_file_dir

       

      NAME                                 TYPE        VALUE

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

      utl_file_dir                         string      /usr/tmp, /tmp, /u02/orapsar/P

                                                       SAR/12.1.0/appsutil/outbound/P

                                                       SAR_test01, /usr/tmp

       

      This means the above setup is not true? Since the first directory listed in the UTL_FILE_DIR =  /usr/tmp.

       

       

      Please shed lights....

       

       

      Kind regards,

      jc