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
Recent Posts
