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
  • December 31, 2018 | 30 views
  • Comments