今天客户说无法远程连接数据库,配好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