ORA-00020: maximum number of processes (150) exceeded
1、When you execute “sqlplus / as sysdba” to connect SQL,you can stop all
processes of oracle with the following command if this error occured
ps -ef |grep $ORACLE_SID|grep -v grep|awk ‘{print $2}’ | xargs kill -9
ipcs -m | grep oracle | awk ‘{print $2}’ | xargs ipcrm shm
2. execute “sqlplus / as sysdba” ,login oracle,checking maximum process and session.
SQL> show parameter processes;
NAME TYPE VALUE
———————————— ———– ——————————
aq_tm_processes integer 1
db_writer_processes integer 5
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150
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
session_cached_cursors integer 50
session_max_open_files integer 10
sessions integer 350
shared_server_sessions integer
3. modify processes and sessions
SQL> alter system set processes=3000 scope=spfile;
System altered.
SQL> alter system set sessions=4560 scope=spfile;
System altered.
4.restart oracle
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 2.0176E+10 bytes
Fixed Size 2261928 bytes
Variable Size 3959426136 bytes
Database Buffers 1.6173E+10 bytes
Redo Buffers 41463808 bytes
Database mounted.
This error will be resloved.