This error is generated when dealing with a large amount of data, such as doing physical Inventory adjustment, because EBS requires large data, the system will use a temporary file in the/tmp directory *. TMP, the temporary file is deleted after the end.
If the amount of data is too large, it may be reported that the error: Frm-41839:disk I/O error on temporary record buffer file/tmp/... Tmp
The reason for reporting this error may be that the/tmp directory is too small to allocate space for disk space. However, even if this directory space is sufficient, it is still possible that this error occurs because EBS has a limit on the size of this temporary file, before patch 14825718, the size of the file is limited to 2G, after the patch is finished, you can modify the configuration file to increase the size limit of this temporary file.
You can refer to the Common Solutions to FRM-41839 and. tmp Files not Being Deleted (Doc ID 435437.1) 13th.
Specific procedures:
0. Shut down EBS
1. Download patch (Solaris): https://updates.oracle.com/download/14825718.html
2. Upload the patch to DIR:/var/tmp
3. Unzip p14825718_xxx.zip (depends on Ct ' s system)
4. CD 14825718
5. Export path= $PATH:/var/tmp/14825718
6. Use Command:opatch Apply
7. After patch applied, then go to $ORA _config_home/10.1.2/forms/server, find file default.env, find Forms_scroll_all_but_ One in the file, and add
Following in the next line:
Forms_recmgr_recsize_power=4
This would the Allow. tmp file size up to 32Gb.
8. Then bounce EBS and retest.
This is a framework patch, and after this patch is finished, you need to regenerate the form and jar files, using the Adadmin command. Otherwise the form may not open.
Frm-41839:disk I/O error on temporary record buffer file/tmp/... Tmp