Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off

大量并发连接 oracle时报错：Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off

查询数据库进程数上限：

select value from v$parameter where name =‘processes’;

 

查询实际连接数：

select count(*) from v$process;

 

如果实际连接数 快超过 数据库进程上限数就会报错

修改 数据库进程上限数即可：

alter system set processes = 1000 scope = spfile;