ORA-12801: error signaled in parallel query server , ORA-27090: Unable to reserve kernel resources
ORA-12801: error signaled in parallel query server , ORA-27090: Unable to reserve kernel resources
Problem:
-------------------
Solution:
------------------
Run as root:
modify fs.aio-max-nr value to 3145728 in /etc/sysctl.conf
Read the actual parameters with sysctl.
ORA-12801: error signaled in parallel query server , ORA-27090: Unable to reserve kernel resources
Problem:
-------------------
ORA-12801: error signaled in parallel query server P006, instance
mdvreddy.markmotels.com:mdvreddy (1)
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O and hence change
Solution:
------------------
Run as root:
modify fs.aio-max-nr value to 3145728 in /etc/sysctl.conf
Save the file and Run to make the changes permanent
###fs.aio-max-nr = 1048576
fs.aio-max-nr= 3145728
sysctl -p
Read the actual parameters with sysctl.
sysctl -a
No comments:
Post a Comment