Saturday, April 27, 2013

ASM ORA-00020: maximum number of processes


ASM - ORA-00020: maximum number of processes



The Oracle parameter PROCESSES has been exceeded as a result of multiple database instances connecting to the ASM instance. The default value (often 40) is insufficient to support more than one database connecting to the ASM instance

Solution : Increase the PROCESSES parameter in the ASM parameter file and bounce the ASM instance.


For 11.2 set up, the formula is  PROCESSES = 50 + 50*n
where n is the number database instances connecting to the Oracle ASM instance.


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 accommodate for
 
             * Multiple ARCH processes
             * Multiple LGWR processes 


This is in the standard document

No comments:

Post a Comment