Sunday, 8 June 2014

ASM terminated ORA-00020: maximum number of processes 100 exceeded

ASM terminated ORA-00020: maximum number of processes 100 exceeded


Login to the ASM as sysasm and change the process value,We need to restart the complete crs since asm hosts data of database as well.

We can do its in rolling forward method from one by one instance.



SQL> alter system set processes=300 scope=BOTH sid='*';

System altered.

SQL>


++ Restart the asm instance one by one.

No comments: