Tuesday, December 20, 2016

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


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


 

###fs.aio-max-nr = 1048576
fs.aio-max-nr= 3145728

Save the file and Run to make the changes permanent

 sysctl -p



Read the actual parameters with sysctl.

 
sysctl -a