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.
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