ITPub博客

首页 > Linux操作系统 > Linux操作系统 > listener.log文件中出现大量的TNS-12519

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

原创 Linux操作系统 作者:crpp0902 时间:2019-01-21 15:33:06 0 删除 编辑
最近前台应用日志中不断出现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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2002-11-14

  • 博文量
    23
  • 访问量
    15955