Listener refused the connection with the follow
ing error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
192.168.1.6:1521:webtest
我的系统是JSP+Tomcat5.0.28,系统里面使用了连接池对数据库进行连接,开始可以运行一段时间,但是几个小时就会发生上面的异常,请问我应该怎样做啊???哪位高手可以指点下不?
ing error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
192.168.1.6:1521:webtest
我的系统是JSP+Tomcat5.0.28,系统里面使用了连接池对数据库进行连接,开始可以运行一段时间,但是几个小时就会发生上面的异常,请问我应该怎样做啊???哪位高手可以指点下不?
java.lang.Exception: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
好多人遇到这问题阿。
怎么解决阿。
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.运行 $ORALCE_HOME/bin/lsnrctl services 查看有没有services下的实例状态
一边默认oracle注册实例是动态
修改oracle注册实例为静态就可以解决了
有时候连得上数据库,有时候又连不上。
可能是数据库上当前的连接数目已经超过了它能够处理的最大值。 select count(*) from v$process --当前的连接数
select value from v$parameter where name = 'processes' --数据库允许的最大连接数 修改最大连接数:
alter system set processes = 300 scope = spfile; 重启数据库:
shutdown immediate;
startup; --查看当前有哪些用户正在使用数据
SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine
from v$session a, v$sqlarea b
where a.sql_address =b.address order by cpu_time/executions desc;
看看你的实例状态是不是BLOCK如果是就参照6楼,多半是应用出了问题,比如建立连接之后不关闭。