ORA-00020: maximumnumberofprocesses (500) exceeded error Solution

Today, I just received a system warning text message. It is the OA database system. I logged on to the server and found an error in the connected database. ORA-00020: maximumnumberofprocess

Today, I just received a system warning text message. It is the OA database system. I logged on to the server and found an error in the connected database. ORA-00020: maximum number of process

Today, I just received a system warning text message. It is the OA database system. I logged on to the server and found an error in the connected database.

[Oracle @ oadb ~] $ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.4.0 Production on Tue Jul 21 10:38:28 2015

Copyright (c) 1982,201 3, Oracle. All rights reserved.

ERROR:
ORA-00020: maximum number of processes (500) exceeded

According to the error message, the maximum number of processes has been reached.

This parameter is a static parameter. After modification, you need to start the database.

SQL> set linesize 1000
SQL> show parameter processes

NAME TYPE VALUE
----------------------------------------------------------------------------------------
Aq_tm_processes integer 1
Db_writer_processes integer 3
Gcs_server_processes integer 0
Global_txn_processes integer 1
Job_queue_processes integer 1000
Log_archive_max_processes integer 4
Processes integer 500

The system production system cannot restart the database. Fortunately, the system returns to normal after a while.
This system is a set of OA systems, which are caused by too many people handling office affairs in the morning and too many user visits.
Solution:
When the system is idle, modify the system parameters and restart the database.
SQL> alter system set processes = 1000 scope = spfile;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
SQL> show parameter processes

NAME TYPE VALUE
----------------------------------------------------------------------------------------
Aq_tm_processes integer 1
Db_writer_processes integer 3
Gcs_server_processes integer 0
Global_txn_processes integer 1
Job_queue_processes integer 1000
Log_archive_max_processes integer 4
Processes integer 1000

This article permanently updates the link address: