Ora-00020:maximum number of processes (exceeded) Error resolution

Solution Solutions

1. View the number of processes

Sql> Show Parameter Proce

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 150

2. Modify Processes

Sql> alter system set PROCESSES=300 Scope=spfile;

The system has changed.

Sql> Show Parameter Proce

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 150
sql> shutdown Immediate
The database is closed.
The database has been uninstalled.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has been started.

Total System Global area 530128356 bytes
Fixed Size 454116 bytes
Variable Size 503316480 bytes
Database buffers 25165824 bytes
Redo buffers 1191936 bytes
The database is loaded.
The database is already open.
Sql> Show Parameter Proce

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 300

Summary
In this paper, the simulation of ORA-00020 error and the simple processing method are given. The most effective way to avoid ORA-00020 errors in the production environment is to fully evaluate the maximum number of processes required by the system before going online and set them up fully at once. This will fundamentally prevent ORA-00020 errors from occurring.

Ora-00020:maximum number of processes (exceeded) Error resolution