SAP Bugger: Troubleshoot ORA-00020 Error

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

Error description:

Solution:

1. Check SAP Note 830576

2. First check whether you are able to connect to DB or not.

oraSID> sqlplus “ /as sysdba”

3. If result showing connected to idle instance that means your DB is down.

Then start your database

SQL>startup;

4. If it is connected, then check no. of processes exists.

    SQL> show parameter process;

    Output:

    SQL> select count (*) from v$process;

5. Check init<SID> parameter file also.(check process parameter).

6. Increase Process of you database instance:

SQL> alter system set process = 500 scope = spfile;

7. Take bounce of the system:

SQL> shutdown immediate;

SQL> startup;

8. Check again process whether it is changed or not!

SAP Bugger