ORA-12519, TNS:no appropriate service handler found
刘大，您好：我在登录数据库的时候遇到一个问题，所有客户端出现无法连接的现象。重启数据库之后，就恢复正常了。数据库版本为11.1.0.6.0
C：\Users\Daniel>sqlplus system@p_efinance
SQL*Plus:Release 10.1.0.2.0-Production on Sun Feb 15 14:08:04 2015
Copyright (c) 1982,2004,Oracle. All rights reserved.
Enter password:
Error:
ORA-12519 :TNS:no appropriate service handler found
Enter user-name:system
Enter password:
ERROR:
ORA-12560:TNS:protocol adapter error
SQL>select * from v$resource_limit;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------- ------------------- --------------- ------------------ -----------
processes 110 170 600 600
sessions 115 185 665 665
oracle@localhost.localdoamin:lsnrctl service
LSNRCTL for Linux:Version 11.1.0.6.0 -Production on 15-FEB-2015 16:55:31
Copyright (c) 1991,2007,oracle.All rights reserved
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
Service Summary...
Service "efinance" has 1 instance(s).
Instance "efinance",status READY,has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:80375 refused:0 state:blocked
LOCAL SERVER
Service "efinance" has 1 instance(s).
Instance "efinance",status READY,has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER<machine: localhost.localdomain,pid:30534>
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=32788))
Service "efinance" has 1 instance(s).
Instance "efinance_XPT",status READY,has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:80375 refused:0 state:blocked
LOCAL SERVER
麻烦刘大帮忙分析下原因！谢谢！ 本帖最后由 anbob 于 2015-7-14 13:03 编辑
以前遇到过一次，仅供参考 http://www.anbob.com/archives/2587.html
页:
[1]