ORA-12520听程序无法为请求的服务器类型找到可用的处理程序

今天客户说无法远程连接数据库，配好TNS自己测，发现报错

ORA-12520听程序无法为请求的服务器类型找到可用的处理程序

远程登陆服务器用sqlplus连接 报错

C:\Users\Administrator>sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on 星期二 9月 15 16:56:01 2015


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


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

后台alert报错

Tue Sep 15 16:34:12 2015
ORA-00020: 超出最大进程数 (150)
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
Process m000 submission failed with error = 20
Tue Sep 15 16:54:17 2015
ORA-00020: 超出最大进程数 (150)
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
Process m000 submission failed with error = 20
Tue Sep 15 16:56:01 2015
ORA-00020: maximum number of processes (150) exceeded
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.

通过调整进程参数值来缓解压力

SQL> alter system set processes=500 scope=spfile;


系统已更改。


SQL> shutdown immediate

数据库已经关闭。

已经卸载数据库。

ORACLE 例程已经关闭。

C:\Users\Administrator>set ORACLE
oracle_sid=GDDB


C:\Users\Administrator>sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on 星期二 9月 15 17:04:05 2015


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


已连接到空闲例程。


SQL> startup
ORACLE 例程已经启动。


Total System Global Area 4710043648 bytes
Fixed Size                  2289120 bytes
Variable Size            1073742368 bytes
Database Buffers         3623878656 bytes
Redo Buffers               10133504 bytes
数据库装载完毕。
数据库已经打开。
SQL> show parameter processes


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

SQL> select value from v$parameter where name = 'processes';


VALUE
--------------------------------------------------------------------------------
500

修改之后 远程可以连接。

感谢链接 ：http://blog.itpub.net/24558279/viewspace-752828