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.
Thursday, August 4, 2011
ORA-00020: maximum number of processes (n) exceeded in ASM Instance
Posted by M A D A N M O H A N at 9:02 PM 23 comments
Labels: ASM
Subscribe to:
Posts (Atom)