Re: temporary files

Posted by latifa on Apr 23, 2021; 1:21pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/temporary-files-tp8513p9664.html

Hi Erman,

*What is the filesystem that are using ? ( for the directories used in utl_file_dir):

     APPLPTMP=/usr/tmp/PROD1
      utl_file_dir=/usr/tmp/PROD1,/usr/tmp,/Dir1/dir2/dir3/PROD1/data/out
     /usr is not a file system (df -k doesn't give it out)
        /Dir1/dir2/dir3 is file system
       
        APPLPTMP=/usr/tmp/PROD1
       
        when I am in /usr/tmp/PROD1, I do df -kh .
       
        Filesystem             Size   Used  Available Capacity  Mounted on
        rpool/VARSHARE/tmp      45G   321M        11G     3%    /var/tmp



*Do you have any other EBS instance running in the same servers?
No We have only One EBS instance.
However Database contains almost 10 instances (only one for EBS and it's in RAC)

*Do you have any incorrect directory present in utl_file_dir? I don't understand but I think No

*Do you see the file reported in the error is present there? After getting the error, when you check the file is it present or not?

Yes but they are empty.

*What is the DB Version -> There is an event to be set in 19C (CDB level)

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (Doc ID 2525754.1)
 -- To enable the UTL_FILE functionality on which the supplemental UTL_FILE_DIR parameter depends, ensure that you have set the following
 event at the CDB level in your database initialization parameters: event='10946 trace name context forever, level 8454144'

*What is the actual thing that is failing and reporting this error? For instance: "Maintenance Work Order Detail Report"


Requests are about immobilization and comptabilization and they specific programs


*Are you aligned with the conf given in Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite
 Releases 12.1 and 12.2 (Doc ID 2525754.1)?  

Every thing is ok about configuration

Thank you in advance for your help.

Regards,
Latifa