ORA-20100: Error: FND_FILE failure

[Brian Hogantara]

Hi erman,

when my users create report this error show in log.


XLABAOPE module: Open Period Balances
+---------------------------------------------------------------------------+

Current system time is 20-SEP-2017 14:17:52

+---------------------------------------------------------------------------+

**Starts**20-SEP-2017 14:17:52
**Ends**20-SEP-2017 14:17:52
ORA-20100: Error: FND_FILE failure. Unable to create file, o0912247.tmp in the directory, /usr/tmp.
You will find more information in the request log.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
0


Finished executing request completion options.

+---------------------------------------------------------------------------+

what do you suggest??
for more information.
i have 2 development in 1 server.

regards,
brian

[ErmanArslansOracleBlog]

Do you have /usr/tmp?
Do you have the necessary permissions on that directory to create a file? (write permissions)

[Brian Hogantara]

i do have /usr/tmp.

let's just says that i have devbaru and develmen (two deferent development in one server). the error counter in develmen.

i did "ls -ltr" command with root user and the result :

-rw-r--r--   1 devbaru      dba          616 Dec 21  2016 o0912247.tmp

the permissions in development i believed same as productions.

did i must try to "chmod 777 *" at /usr/tmp so the file can be accessed by two development exist?
or i must delete file o0912247.tmp with devbaru user so the oracle applications from the other development can created?

[ErmanArslansOracleBlog]

Change one of these instances to use a different tmp directory.
Create a directory and make the instance use that directory.
2 instances writing in the same directory cause this issue.. Because some times the names of the tmp files conflict..

[Brian Hogantara]

do you know how to change tmp directory?

i only knew how to change it from clone process. there is step like this:

"Target System utl_file_dir Directory List : /usr/tmp"

[ErmanArslansOracleBlog]

What is the value of the utl_file_dir parameter set for the related database?
What is the value of $APPLTMP in your apps tier?
What is the value of $APPLPTMP in your apps tier?

[Brian Hogantara]

-------------------------------DEVELMEN------------------------------------------

-SELECT value FROM V$PARAMETER WHERE NAME = 'utl_file_dir';
/usr/tmp, /usr/tmp, /d01/DEVELMEN/db/tech_st/11.2.0/appsutil/outbound/DEVELMEN_development-2, /usr/tmp
-bash-3.2$ echo $APPLTMP
/d01/DEVELMEN/inst/apps/DEVELMEN_development-2/appltmp
-bash-3.2$ echo $APPLPTMP
/usr/tmp
------------------------------------------------------------------------------------

-------------------------------DEVBARU------------------------------------------

-SELECT value FROM V$PARAMETER WHERE NAME = 'utl_file_dir';
/usr/tmp, /usr/tmp, /d01/DEVBARU/db/tech_st/11.2.0/appsutil/outbound/DEVBARU_development-2, /usr/tmp
-bash-3.2$ echo $APPLTMP
/d01/DEVBARU/inst/apps/DEVBARU_development-2/appltmp
-bash-3.2$ echo $APPLPTMP
/usr/tmp
------------------------------------------------------------------------------------

is that what you means ?

[ErmanArslansOracleBlog]

Okay. You have a file conflict.
Two instances shares the /usr/tmp.
so if they try to create the same file (a file with the same name), one of them fails..

You should seperate them. You should make one of them to use a different tmp directory.

[ErmanArslansOracleBlog]

Create a directory for develmen
for appltmp - /usr/tmp/appldevelmentmp
give all the required permissions for the db and apps OS users for writing+reading this directory.
Add this directory path to utl_file_dir , shutdown Apps tier services and restart the database.
Lastly, change the APPLTMP parameter value of the Application tier (properly, by editing the context file and running autoconfig) and start the Apps tier services.
Retest.

[Brian Hogantara]

"Add this directory path to utl_file_dir"

how to doing this step?
using software like sqldeveloper and make query like :

UPDATE table_name
SET column1 = value1
WHERE condition;

--------------------------

"change the APPLTMP parameter value of the Application tier"

change APPLTMP to the path usr/tmp/appldevelmentmp ? or somewhere else?

[ErmanArslansOracleBlog]

I think you are not DBA?

tell your dba to update this.

it is done using sqlplus "/as sysdba"
alter system set utl_file_dir ...blabla

or using a text editor (if you are using a pfile)

[ErmanArslansOracleBlog]

You also need to bounce your db for this.

[Brian Hogantara]

ok i get your point :)

i newbie by the way

so some of the typical language still get confused me sometimes

[Brian Hogantara]

Hi erman,

i want to update my issue.

this issue was fix by change the init<SID>.ora which is, in your description said that "(properly, by editing the context file and running autoconfig)".
i can't change with alter system bla bla bla because i'm not using SPFILE


thanks

[ErmanArslansOracleBlog]

if you are using a "P"file , then you will have to update your init<SID>.ora manually for this.

Bytheway, why not using spfile.. spfile is a recommended and good thing .

Anyways, okay. good for you Brian. Thanks for updating the issue.