1
May

ORACLE error 20100 in FDPSTP

Error :

ORACLE error 20100 in FDPSTP
FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.

Action:

Check that the directory is a valid directory with wri06-APR-2016 14:48:29

Cause:

The concurrent program was unable to write to the specified temporary file because the virtual path assigned to the APPLPTMP environment variable is not referenced in the UTL_FILE_DIR

Solution:

Check the location of the APPLPTMP on all application servers.
The value of this parameter is specified in the CONTEXT FILE of the application server.

[applprod@dbaarena01 ebsprod_dbaarena01]$ echo $APPLPTMP
/u01/app/oracle/product/11.2.0.3/dbhome_1/tmp

Applications also produces temporary PL/SQL output files used in concurrent processing. These files are written to a location on the database server node specified by the APPLPTMP environment setting. The APPLPTMP directory must be the same directory as specified by the utl_file_dir parameter in your database initialization file.


SQL> show parameter utl

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
create_stored_outlines string
utl_file_dir string /u01/app/oracle/tmp


Take backup of the current parameter file.

Edit the parameter file and change the value of the utl_file_dir parameter to a readable/writable directory (i.e. $APPLPTMP, '/u01/app/oracle/tmp')
Make sure that the value for APPLPTMP comes first in this listing for UTL_FILE_DIR, as this is the key to this solution.

alter system set utl_file_dir='/u01/app/oracle/product/11.2.0.3/dbhome_1/tmp','/u01/app/oracle/tmp' scope=spfile;

System altered.

Bounce the application and database.


SQL> show parameter utl

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
create_stored_outlines string
utl_file_dir string /u01/app/oracle/product/11.2.0.3/dbhome_1/tmp, /u01/app/oracle/tmp


Run the concurrent request and check again.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to Top