*.TMP files in /tmp re: Oracle Financials

[TwoProc]

Does anyone know what variable defines the output of the *.TMP files that are landing in /tmp for Oracle Forms server tiers hosting Oracle Applications ?

I'd like them a) gone or b) moved to another directory.

[James R. Ferguson · Accepted solution]

Hi:

One would hope that temporary files are created using the TMPDIR variable's value. See the manpages for 'mktemp(1 and 3C)' for more information.

Regards!

...JRF...

[Steven E. Protter]

Shalom,

Check the date on those files, if they are old, you may be able to delete right away.

Question: Do you have a daily job that gets rid of old files in /tmp ? Thats standard in Linux but you actually have to write, borrow or steal one with HP-UX.

I think redirecting the files by setting the TMPDIR variable should best be done in the startup script for the Oracle Forms server.

Pesky little product those app servers. Ate a couple of years out of my life in my last job.

SEP

[TwoProc]

Steven and James,

Thanks for the tip, I'll give it a try today.
I don't have "TMPDIR" defined, so I'm guessing that it is defaulting to /tmp.

To answer your question Steven, I do delete them every hour for any file over 1 day old (find -mtime +0). I really don't like them in a public area - If I have to have them, I'd prefer them in a directory of my own choosing. It's one of those things that have been bugging me that I'm finally getting around to addressing. Too bad that the list is sooo long...

[A. Clay Stephenson]

I don't know specifically about Oracle Financials but I have seen Oracle use TMPDIR, TEMP, and TMP as envionment variables. You should check your documentation but I would set all three of those variables. No harm is done if you simply do:
export TEMP=${TMPDIR}
export TMP=${TMPDIR}

[Yogeeraj_1]

hi John,

You would normally set the environment variable TMP which is most of the time used by Oracle.

We run something similar Oracle Application Server. Here we had to edit our OPMN.XML to get the info about temp files location:

e.g.
SLAX1:$ORACHLE_HOME/opmn/conf>grep -i tmpdir opmn.xml


hope this helps!

kind regards
yogeeraj

[John Brooks_1]

If your system is autconfig enabled, then you should be able to use editcontext to view all the enviromental settings and make changes.

Editcontext is found $COMMON_TOP/util/editcontext

You will need to know the location of your context file usually found under $APPL_TOP/admin. The file name has the form of (INSTANCE_NAME)_(HOST_NAME).xml

See oracle notes 165195.1 and 218089.1 for help with autoconfig.

[TwoProc]

Thanks all, I just added TMPDIR to the customized environment files that I use to startup those tiers, and it is working great.

Really appreciate the help,

thank you!