ORA-12519, TNS:no appropriate service handler found

风语918

刘大，您好：
       我在登录数据库的时候遇到一个问题，所有客户端出现无法连接的现象。重启数据库之后，就恢复正常了。数据库版本为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:[/home/oracle]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

以前遇到过一次，仅供参考 http://www.anbob.com/archives/2587.html