ORA-12519, TNS:no appropriate service handler found

java.sql.SQLException: Listener refused the connection with the following error:

ORA-12519, TNS:no appropriate service handler found

The Connection descriptor used by the client was:

oracle超出最大链接数！

select count(*) from v$process --当前的连接数

--查看当前有哪些用户正在使用数据

 

alter system set processes = 600 scope = spfile;

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

 

修改processes和sessions值必须重启 oracle 服务器 才能生效