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

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

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

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

fact: Oracle Application Object Librarysymptom: FRM-41839: Disk I/O error on temporary record buffer file
/var/tmp/AAAJGaa9Z.TMPsymptom: Querying Values in a value set/Rows in row setschange: 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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/41594/viewspace-50567/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/41594/viewspace-50567/