In this article, will see how to resolve Cause cmlmcm failed due to ora-20100 Temporary file creation for FND_FILE failed in our ebs.
Cause: cmlmcm() failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.
This error was being thrown when one instance was trying to create .tmp file
To resolve this issue Cause cmlmcm failed due to ora-20100 ,shutdown both the apps and db services of one instance and we have to set utl_file_dir properly.
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
set ‘/usr/tmp’ and changed the ownership of this dir to user owner of this instance
Logon to database as sysdba
Create pfile from spfile
SQL> alter system set utl_file_dir=’/usr/tmp’,’/data01/orahome/appsutil/outbound/DEV_xxxapps’,’/usr/tmp’ scope=spfile;
modified UTL_FILE_DIR parameter’s first entry from ‘/usr/tmp’ ;
Created spfile from pfile
Brought up the db and listener
Now modified the $APPLPTMP variable in TEST_oratest.xml file as ‘/usr/tmp’
Run the autoconfig on appsTier.
Brought up the apps services
Retested the issue and it was resolved