Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2519921
  • 博文数量: 323
  • 博客积分: 10211
  • 博客等级: 上将
  • 技术积分: 4934
  • 用 户 组: 普通用户
  • 注册时间: 2006-08-27 14:56








分类: Oracle

2008-11-26 18:43:13

  FRM-41839: 在临时记录缓冲区文件 /tmp/*.TMP中磁盘的输入输出错误
Applies to: Oracle Applications Technology Stack - Version:
This problem can occur on any platform.

The process f60webmx writes files into the server /tmp and let them in memory with status 'deleted' so that it's consuming file system.

Because of these files, the /tmp is sometimes 100% full, rendering the Oracle Applications environment useless.

FRM-41839: Disk I/O error on temporary record buffer file


The /tmp directory is used in several different situations.
- When running long running queries
- Forms or Reports with lots of data
- When viewing a log file for a Concurrent Request a *.t file (example: OFkp7gMa.t) is generated.

CauseNeed to routinely clean up the /tmp directory. Solution

Here are the most Common Solutions to this issue:

1. As documented in Unpublished bug 3006192 and the System Administrator Manual, write a cron job to, every 5 minutes, perform a clean of 30 minute old or older files in the tmp space.

The .TMP files are coming from the f60webmx processes which would normally clean up these files when they are terminated, however, if the script ' stop' is run, it uses kill -9 to terminate all of the currently running forms processes ( the most immediate way of killing a unix process ) this has the side effect of killing any f60webmx processes in memory BEFORE they clean up their .TMP files. Also, if users are exiting or killing a Long LOV or a Request before it completes the tmp file will not get cleaned up. This means that .TMP files are a normal residue of bouncing the forms server and every day operations, and a cron job should be implemented to routinely clean them up.

2. Go back and review the Forms Upgrade note to make sure that you have the latest additional patches - the note is a living documented and is frequently being update with new patches. Ref. Note <125767.1> Upgrading Developer 6i with Oracle Applications 11i:

3. Run the concurrent program called 'Delete data from temporary table'. This program kills active sessions that are more than four hours old by executing the script named ICXDLTMP.sql. Either run the program through Concurrent Request or run it manually through sqlplus.
This should generally be run no more than nightly.
Ref. Note: <153884.1> Is There A Script To Clean up ICX_TEXT and ICX_SESSIONS Tables
Note <397118.1> Where Is 'Delete Data From Temporary Table' Concurrent Program - ICXDLTMP.SQL

4. Add more disk space.

5. Set the TMPDIR environment variable and restart the forms server
TMPDIR=/tmp; export TMPDIR

6. Create a soft link from /var/tmp to a mount point with more disk space

7. Check timeout settings to make sure that inactive user sessions are being dropped.
Heartbeat = ($OA_HTML/bin/appsweb.cfg and $OA_HTML/US/appsbase.htm)

Self Service timeout Profile Options:
ICX: Session Timeout
ICX:Limit Time
ICX:Limit connect

session.timeout= ( in iAS/Apache/Jserv/etc)

Reference the following note for more information on these timeout settings: 269884.1 How to fix Timeout issues in 11i

8. For Concurrent Request, temporary files get written /tmp when viewing output and log files.
Even though the $APPLTMP is set to a directory other than /tmp, the Concurrent Request will still use /tmp unless the $APPLTMP variable is set in the webserver environment.
You would need to add $APPLTMP to the Apache config file if you want it to write to a different director other than /tmp. If $APPLTMP is not set, /tmp is used by default.
Refer to the following notes for more information on how to add new parameters to a configuration file:
  Using AutoConfig to Manage System Configurations with Oracle Applications 11i
 Ext/Pub Customizing an AutoConfig Environment:

Note: Deletion of temporary files created by viewing log files and output files is controlled by system profile 'RRA:Delete Temporary files'.

9. Review the notes below if additional information is needed.

References - Files Types .t and .temp and .tmp, are Saving Under /var/tmp
- Why Does Oracle Forms Create .TMP Files Which Fill Up The Filesystem e.g. /tmp ?
- How to Change the Directories where Applications Temporary Files are Generated
- Where the Forms Server Temporary Files Are Kept on the Disk?
- Large Export Temp Files Filling Up /tmp
- How To Reduce The Size Of Temp File During The Export Process?
阅读(2914) | 评论(0) | 转发(0) |