Tuesday 12 August 2014

Solution of ORA-00020 maximum number of processes (%s) exceeded

Hi Oracle Lovers , This is a very common problem if u don't plan for your DB processes :-) 
Don't worry this problem is solved with a minimum down time :-( To effect this in your DB u need to restart your DB    :-(


I've solve the problem(ORA-00020 maximum number of processes (%s) exceeded) Normally.
Just login Database as sysdba (Wait for a process end normally ), then just alter the system parameter file to maximum process 1500.
1.SQL> select count(*) from v$process;      to see the number of processes running. After that I've change the  parameter file by following command.  
2. SQL> alter system set processes=1500 scope=spfile; 

SQL> shutdown immediate
SQL> startup 
:-)

No comments:

  Oracle 21c Cluster Setup & DB Creation on OEL-8.4 using Virtual-box       Moto: This document is created on traditional way to Insta...