Pages

Tuesday, April 5, 2016

adpatch, Jtfpfcreate.Sql Fails During a Patch Application : ORA-20100: File xxxxxx.tmp creation for FND_FILE failed.

adpatch, Jtfpfcreate.Sql Fails During a Patch Application : ORA-20100: File xxxxxx.tmp creation for FND_FILE failed.

Error:

sqlplus -s APPS/***** @/<JTF_TOP>/patch/115/sql/jtfpfcreate.sql
DECLARE
*
ERROR at line 1:
ORA-20100: File o0015389.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at "APPS.FND_FILE", line 378
ORA-06512: at "APPS.FND_FILE", line 473
ORA-06512: at line 50

Cause:

There is a permission or space problem with the directory being used to write a temporary file
during patch application.

Solution:

To implement the solution, please execute the following steps:

1. Exit adpatch (via adctrl, using hidden option 8) if it is still running.

2. Navigate to the directory which  is pointed to by the $APPLTMP environment variable.

Login as apps user
cd $APPL_TOP
. ./APPSORA.env
cd  $APPLTMP
pwd

3. Please attempt to delete any *.tmp files in this directory ($APPLTMP).

4. Change the permissions on the directory to 777 to ensure permissions is not a problem.

5. Please ensure there is sufficient free space for this directory.
df -kb

6. Change the database parameter file (init.ora) and ensure the UTL_FILE_DIR contains the
directory pointed to by the $APPLTMP variable.

Nb:
UTL_FILE_DIR can contain different directory, but please  make sure the directory pointed by APPLPTMP is the first entry on the UTL_FILE_DIR.

7. Restart the Database and Listener.

8. Ensure the APPS Middle tier is shutdown excepts the Database and Listener.

9. Rerun the patch and determine if the issue is repeated.

Reference metalink Doc ID 557860.1

No comments:

Post a Comment