WRR Generates OFA*.t Temp File in /var/tmp Directory Instead of $APPLTMP [ID 276695.1]
Applies to:
Oracle Application Object Library - Version 11.5.9 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
This problem can occur on any platform.
Checked for relevance on 23-DEC-2012
Symptoms
The Web Report Review Agent is generating OFA*.t temp files in the /var/tmp directory instead of $APPLTMP.
Cause
FNDWRR does use APPLTMP as its temp directory, but remember FNDWRR is a CGI program so you must set APPLTMP in your WEBSERVER environment.
Solution
1. Define the APPLTMP variable in apps.conf as:
($IAS_ORACLE_HOME/Apache/Apache/conf 例如: /u02/mis/app/gdprd/gdprdora/iAS/Apache/Apache/conf )
SetEnv APPLTMP "/home9/apps/actcomn/temp"
2. Bounce the Apache server.
Note: The path above would be the full path of your $APPLTMP
References
NOTE:181371.1 - FRM-41839: Disk I/O error on Temporary Record Buffer File /var/tmp/AAAJGaa9Z.TMPNOTE:276695.1 - WRR Generates OFA*.t Temp File in /var/tmp Directory Instead of $APPLTMP
BUG:5581772 - FRM-41839 :DISK I/O ERROR ON TEMPORARY RECORD BUFFER WHEN EXPORTING
@ BUG:4014106 - DATA EXPORT RUNS SLOWER IN 11.5.9 THAN IN 11.0.3