Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ETL log contains 'ORA-12801: error signaled in parallel query server P005'

    • Article Type: General
    • Product: Aleph
    • Product Version: 3.0.0

    Problem Symptoms:
    ETL log file in $data_scratch/p_arc_01.log contains the following error:
    select count (*) from ABCR1.mrr_cash
    ERROR at line 1:
    ORA-12801: error signaled in parallel query server P005
    ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
    Linux-x86_64 Error: 11: Resource temporarily unavailable
    Additional information: 3
    Additional information: 128
    Additional information: 1

    Arguments too long

    System configuration

    Change system configuration in /etc/sysctl.conf on the server hosting the ARC DB to
    fs.aio-max-nr =1048576

    Additional Information

    This change should only be applied by qualified system administrators. Explanation for parameter fs.aio-max-nr This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures.

    Category: ETL (ARC)

    Subject: Transform and Load

    • Article last edited: 10/8/2013