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
Cause:
System configuration
Resolution:
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