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

Last updated on MAY 15, 2017

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@ramseyprd:/home/applprod # env | grep -i tmp
TMPDIR=/u03/tmp
TEMP=/u03/tmp
REPORTS60_TMP=/p01/oracle/prodcomn/temp
APPLPTMP=/p01/oracle/prodcomn/temp
TMP=/p03/tmp
APPLTMP=/p01/oracle/prodcomn/temp
applprod@ramseyprd:/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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms