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.
Error:-
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
Solution:-
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;
System altered.
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’
Retest:-
Run the autoconfig on appsTier.
Brought up the apps services
Retested the issue and it was resolved