R12.2 Apps DBA. Powered by Blogger.

FDPSTP failed due to ORA-20100

No comments :
Cause: FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, o4824028.tmp in the directory, /usr/tmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
Solution:
To Implement the solution please follow the below
Take backup of /usr/tmp directory
1. Purge the /usr/tmp directory in TEST instance.
2. Check if the Directory has all the accesses ie.mode should be 777.
3. try to move a new file in the directory manually to check if its allowing to copy.
4.If its successful please reproduce the issue and check.
5.Move the fix to appropriate environment if the issue is resolved.
=========
File o0006564.tmp already exists in /tmp with no re-write permission
applmgrp [/tmp] ls -l /tmp/o0006564.tmp
-rw-r--r-- 1 oraclet dbat 368 Apr 14 22:10 /tmp/o0006564.tmp
As the file already exists it cannot be overwritten and process fails
1- From the UNIX user that starts the concurrent processors
ls -l /tmp/o0006564.tmp
rm /tmp/o0006564.tmp
==========================
Ensure that the directories specified in the utl_file_dir parameter in the V$PARAMETER table are writeable by the Oracle owner.
The profile option CSI: Log File Path must be the first entry in the utl_file_dir parameter.
Make sure that $APPLPTMP and $APPLTMP are set to this same value.
Verify that the profile 'CSI: Log File Path' has a valid directory path (NO trailing slash) and that it is defined in the 'utl_file_dir' parameter.
=========================
FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, oXXXXXXXX.tmp in the directory, /usr/tmp
A TEST instance was already up and running and I created another production clone on the same server/machine. Once the services of both the instances
The concurrent programs were completing in error and when checked the log files, the following error message was there:
ORACLE error 20100 in FDPSTP
Cause: FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, o0031866.tmp in the directory, /usr/tmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
When investigated, I found that both the instnaces were creating .tmp files in /usr/tmp directory with the same name. This error was being thrown when one instance was trying to create .tmp file and a file with the same name was already created by the other instance.
To resolve the issue I shutdown both the apps and db services of one instance.
Created a directory 'temp' in '/usr/tmp' and changed the ownership of this dir to user owner of this instance
Logon to database as sysdba
Create pfile from spfile
modified UTL_FILE_DIR parameter's first entry from '/usr/tmp' to '/usr/tmp/temp'
Created spfile from pfile
Brought up the db and listener
Now modified the $APPLPTMP variable in TEST_oratest.xml file from '/usr/tmp' to '/usr/tmp/temp'
Run the autoconfig on apps tier/node
Brought up the apps services
Retested the issue and it was resolved
==================

No comments :

Post a Comment

Note: only a member of this blog may post a comment.