ORA-00020: maximum no of processes exceeded

Cause:-

When this maximum is reached, no more requests are processed. 

Action:-

After few minutes try to connect. again you are getting same issue please check with developers and kill the inactive sessions from os level after that you can try to connect. After that also you can't able to connect the database means you need to restart the database.


[oracle@ram ~]$ pwd
/home/oracle

[oracle@ram ~]$sqlplus -prelim "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Jun 6 11:29:54 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

SQL>

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

ORA-01012: not logged on

Process ID: 0

Session ID: 0 Serial number: 0

 

SQL>exit

sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Jun 6 11:33:07 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>startup mount

ORACLE instance started.

Total System Global Area 4175568896 bytes

Fixed Size                  2160352 bytes

Variable Size            3489663264 bytes

Database Buffers          671088640 bytes

Redo Buffers               12656640 bytes

Database mounted.

SQL> alter database open;

Database opened.

Note :-

Now you can change the process parameters