Frm-41839:disk I/O error on temporary record buffer file/tmp/... Tmp

Source: Internet
Author: User
Tags tmp file

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.