Thursday, August 4, 2011

ORA-00020: maximum number of processes (n) exceeded in ASM Instance

Solution
---------

Increase the PROCESSES parameter in the ASM parameter file

Processes = 25 + 15 * n, where n is the number of instances on the box using ASM for their storage.

NOTE : this formula is for a basic instance and does not accomodate for

* Multiple ARCH processes
* Multiple LGWR processes

Should the ORA-0020 occur even after implementing this formula ... add additional for any multiples of these background processes


Refer NOTE 265633.1 "ASM Technical Best Practices" for more information.