Fatal NI connect error 12537, connecting to: (LOCAL=NO)

alert日记中出现大量下面的错误

***********************************************************************


Fatal NI connect error 12537, connecting to:
 (LOCAL=NO)


  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.4.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
  Time: 18-11月-2014 16:22:28
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537


TNS-12537: TNS: 连接已关闭
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (30018) as a result of ORA-609
Tue Nov 18 17:14:50 2014
Thread 2 advanced to log sequence 1377 (LGWR switch)
  Current log# 6 seq# 1377 mem# 0: +DATA/orcl/onlinelog/group_6.517.859783227
    nt OS err code: 0
opiodr aborting process unknown ospid (29612) as a result of ORA-609
Tue Nov 18 16:22:12 2014




***********************************************************************


Fatal NI connect error 12537, connecting to:
 (LOCAL=NO)


  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.4.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
  Time: 18-11月-2014 16:22:12
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537


TNS-12537: TNS: 连接已关闭
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (29763) as a result of ORA-609
Tue Nov 18 16:22:20 2014

listener日记中出现了TNS-12518: TNS: 监听程序无法转接客户机连接和TNS-12519: TNS: 找不到适用的服务处理程序;在同一时间内出现了大量的session 连接到数据库。

18-11月-2014 16:21:49 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=SVCTAG-9YVTX2X)(USER=IUSR_SVCTAG-9YVTX2X))) * (ADDRESS=(PROTOCOL=tcp)(HOST=120.31.131.11)(PORT=1465)) * establish * orcl * 12519
TNS-12519: TNS: 找不到适用的服务处理程序
18-11月-2014 16:21:49 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=SVCTAG-9YVTX2X)(USER=IUSR_SVCTAG-9YVTX2X))) * (ADDRESS=(PROTOCOL=tcp)(HOST=120.31.131.11)(PORT=1462)) * establish * orcl * 0
18-11月-2014 16:21:49 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=ASZAAS-WTJCX1)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=120.31.131.12)(PORT=2957)) * establish * orcl * 12518
TNS-12518: TNS: 监听程序无法转接客户机连接
 TNS-12547: TNS: 丢失连接
  TNS-12560: TNS: 协议适配器错误
   TNS-00517: 丢失连接

总结:
1 查看了process参数,参数足够大
2 网上没有找到合适的解决办法
最后根据listener日记,短时间内有大量session连接数据库,询问了应用人员,原来他们重启过所有的WebLogic;重启WebLogic导致 opiodr aborting process unknown ospid (29763) as a result of ORA-609(当一个session不知什么原因被终止时,alert日记就会出现这条信息);重启成功后,由于WebLogic会发起大量到数据库的连接,使得监听来不及转发部分连接,进而出现了TNS-12518: TNS: 监听程序无法转接客户机连接



请使用浏览器的分享功能分享到微信等