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.

Leave a Reply