maximum number of processes ( s) exceeded

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

Solution:

We have to increase the value of the PROCESSES initialization parameter and we must need one db bounce.

The session and transaction parameter is depends upon the the process parameter value.

Formula for session, transaction increase steps:

Processes=x

Sessions=x*1.1+5

Transactions=sessions*1.1

sql> alter system set processes=250 scope=spfile;
sql> alter system set sessions=280 scope=spfile;
sql> alter system set transactions=308 scope=spfile;

After the db bounce pls ensure the parameter value.

sql>show parameter processes

NAME                                 TYPE                             VALUE

------------------------------------ -------------------------------- ------------------------------

aq_tm_processes                       integer                             1

db_writer_processes                  integer                            1

job_queue_processes                 integer                          10

log_archive_max_processes        integer                           2

processes                                    integer                       250

sql>show parameter session

NAME                                 TYPE                             VALUE

------------------------------------ -------------------------------- ------------------------------

java_max_sessionspace_size           integer                          0

java_soft_sessionspace_limit         integer                            0

license_max_sessions                  integer                               0

license_sessions_warning              integer                              0

logmnr_max_persistent_sessions       integer                          1

mts_sessions                                integer                          275

session_cached_cursors               integer                             0

session_max_open_files               integer                            10

sessions                                        integer                          280

shared_server_sessions                integer                          275

sql>show parameter transaction

NAME                                 TYPE                             VALUE

------------------------------------ -------------------------------- ------------------------------

transaction_auditing                 boolean                          TRUE

transactions                                     integer                          308

transactions_per_rollback_segment    integer                          5

sql>select count(1) from v$process;


  COUNT(1)
----------
       146

The value should be minimum of the process parameter value.

I hope this will help you...