FRM-41839:在临时记录缓冲区文件/tmp/26alya. tmp中磁盘的输入/输入错误

最新推荐文章于 2021-06-10 11:27:33 发布

转载最新推荐文章于 2021-06-10 11:27:33 发布 · 255 阅读

文章标签：

#数据库

本文介绍了一种在尝试导出大量记录时遇到的甲骨文报表FRM-41839错误及其解决方案。错误原因是临时文件创建过程中磁盘空间不足。提供了三种解决方法：创建软链接到具有更多空间的挂载点、增加磁盘空间或手动设置TMPDIR环境变量并启动表单服务器。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题：

本日12：00至目前时段，一直无法导出PQC 8月和9月的甲骨文报表，系统出现附件

画面，请帮忙处理，客诉调查急需此资料，谢谢!

错误提示：FRM-41839:在临时记录缓冲区文件/tmp/26alya.tmp中磁盘的输入/输入错误

原因：是/TMP目录的空间用完了

解决办法：(从metalink上找的)

 fact: Oracle Application Object Library

 symptom: FRM-41839: Disk I/O error on temporary record buffer file
/var/tmp/AAAJGaa9Z.TMP

 symptom: Querying Values in a value set/Rows in row sets

 change: NOTE ROLE: Also note that per Note 157385.1, this error occurs when
a query is performed which returns a large number of records. Forms is trying
to create a temporary file in which to place the results of the query. There
is not enough disk space on the drive which is assigned to TEMP/TMP. Either
free up more space or move the TEMP directory to a different drive.

 cause: The /var/tmp referenced in the error message was on Web/Forms
tier.
fix:
There are 3 possible solutions:
1. Create a soft link to a mount point with more disk space
2. Add more disk space.
3. Set the TMPDIR environment variable and manually start the forms server. See
How to Change the Directory for the Forms Server Temporary File