我的网站经常出现如下问题:
Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
127.0.0.1:1521:commweb
此错误只出现在页面的某些连接中,即网站页面有时候能读出所有数据,有时候只能读出一部分数据,重刷新又能读出,apache-tomcat6.0.20抛出上面的异常。我在网上查了很多,大部分资料都是说processes超过最大值,但我查询了下服务器数据库,
select count(*) from v$process;
显示结果:28
select value from v$parameter where name = 'processes';
显示结果:150我用的是Oracle10g
Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
127.0.0.1:1521:commweb
此错误只出现在页面的某些连接中,即网站页面有时候能读出所有数据,有时候只能读出一部分数据,重刷新又能读出,apache-tomcat6.0.20抛出上面的异常。我在网上查了很多,大部分资料都是说processes超过最大值,但我查询了下服务器数据库,
select count(*) from v$process;
显示结果:28
select value from v$parameter where name = 'processes';
显示结果:150我用的是Oracle10g
TNS:no appropriate service handler found
Cause: The listener could not find any available service handlers that are appropriate for the client connection.
Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener, and are accepting connections.
监听服务正常启动了吗
楼主改用连接池吧