解决oracle最大连接数已满的问题（调整最大连接数）：ORA-00020:maximum number of processes (150) exceeded

1. 连接数据库

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 12 10:45:04 2019

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn as sysdba
Enter user-name: myusername
Enter password: 
Connected.
SQL> 

2. 修改最大连接数为1000

SQL> show parameter processes;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes 		     integer	 0
db_writer_processes		     integer	 2
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>  alter system set processes=1000 scope=spfile;

System altered.

3. 重启数据库 

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP;
ORACLE instance started.

Total System Global Area 1235959808 bytes
Fixed Size		    2212896 bytes
Variable Size		  956304352 bytes
Database Buffers	  268435456 bytes
Redo Buffers		    9007104 bytes
Database mounted.
Database opened.
SQL> show parameter processes;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes 		     integer	 0
db_writer_processes		     integer	 2
gcs_server_processes		     integer	 0
global_txn_processes		     integer	 1
job_queue_processes		     integer	 1000
log_archive_max_processes	     integer	 4
processes			     integer	 1000
SQL>