My Oracle Support Banner

How To Get Forms To Write To A Different /tmp? (Doc ID 1502924.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Goal

While users are using the export functionality or querying large amounts of data, the /tmp is filling up full of deleted files locked by active form sessions.
When people log off the files are removed.

Trying to get forms to write to /u03/tmp where there is more storage space and have changed every temp variables ( APPLTMP, APPLPTMP, TMP,TMPDIR, etc.) to point elsewhere:

applprod@<user>:/home/applprod # env | grep -i tmp
TMPDIR=/tmp
TEMP=/tmp
REPORTS60_TMP=/oracle/prodcomn/temp
APPLPTMP=/oracle/prodcomn/temp
TMP=/tmp
APPLTMP=/oracle/prodcomn/temp
applprod@<user>:/home/applprod #
Removed /tmp from utl_file_dir.

None of the changes have made any difference and forms is still writing to /tmp.

How to get forms to write to a different than the local /tmp directory?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.