listener.log文件中出现大量的TNS-12519

最近前台应用日志中不断出现TNS-12519: TNS:no appropriate service handler found的错误，检查后台listener.log文件，确实不段出现该错误。
TNS-12519: TNS:no appropriate service handler found
[oracle@localhost arch]$ oerr TNS 12519
12519, 00000, "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.

出现如上问题的时候，通过
lsnrctl services观察到blocked

[oracle@localhost arch]$ lsnrctl services

LSNRCTL for Linux: Version 9.2.0.5.0 - Production on 28-NOV-2005 16:26:14

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
Services Summary...
Service "pp" has 1 instance(s).
  Instance "pp", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:47616853 refused:0 state:blocked
         LOCAL SERVER
Service "ppXDB" has 1 instance(s).
  Instance "pp", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:188 refused:0 current:3 max:1002 state:ready
         DISPATCHER
         (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=32768))
The command completed successfully




sql>select count(*) from v$session;
-----
216

SQL> show parameter process

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
processes                            integer                          500

linux内核信息：
[root@localhost root]# sysctl -a|grep sem
kernel.sem = 350        32000   100     128
刚开始为
kernel.sem = 250        32000   100     128
以为是信号量设置小了，所以修改到了350
还是报相同的错误。
目前processes  设的为500（应该足够了），比总共的session数量多很多，所以processes  应该不是问题（metalink里面建议增加processes 参数）

各位老大们帮看看

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28419/viewspace-613754/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28419/viewspace-613754/