11gR2数据库的ALERT文件频繁出现Fatal NI connect error 12170错误

 11gR2数据库的ALERT文件频繁出现Fatal NI connect error 12170错误
 
 
 

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

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

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
  Time: 18-NOV-2013 09:03:09
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12547
   
TNS-12547: TNS:lost contact
    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 (26446) as a result of ORA-609
Mon Nov 18 09:03:18 2013


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

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
  Time: 18-NOV-2013 09:03:18
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
   
TNS-12535: TNS:operation timed out
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=58.222.188.38)(PORT=1699))
Mon Nov 18 09:03:39 2013


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

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

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
  Time: 18-NOV-2013 09:03:39
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12547
   
TNS-12547: TNS:lost contact
    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 (26716) as a result of ORA-609
Mon Nov 18 09:04:19 2013


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

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
  Time: 18-NOV-2013 09:04:19
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
   
TNS-12535: TNS:operation timed out
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: <unknown>
opiodr aborting process unknown ospid (26720) as a result of ORA-609

 
metalink上说这个错误是客户端经历了一个超时,新的 Automatic Diagnostic Repository (ADR) 机制将超时信息写入了日志文件。
 
These time out related messages are mostly informational in nature.  The messages indicate the specified client connection (identified by the 'Client address:' details) has experienced a time out.  The 'nt secondary err code' identifies the underlying network transport, such as (TCP/IP) timeout limits after a client has abnormally terminated the database connection.
  
 

解决方法:


To revert to Oracle Net Server tracing/logging, set following parameter in the server's sqlnet.ora :

DIAG_ADR_ENABLED = OFF

Also, to back out the ADR diag for the Listener component, set following parameter in the server's listener.ora:

DIAG_ADR_ENABLED_<listenername> = OFF

   - Where the <listenername> would be replaced with the actual name of the configured listener(s) in the listener.ora configuration file.  For example, if the listener name is 'LISTENER', the parameter would read:

DIAG_ADR_ENABLED_LISTENER = OFF

-Reload or restart the TNS Listener for the parameter change to take effe

Oracle日志中alert_orcl.log出现Fatal NI connect error 12170,如何破?

08-08

Fatal NI connect error 12170.rnrn VERSION INFORMATION:rn TNS for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Time: 08-8月 -2017 08:36:50rn Tracing not turned on.rn Tns error struct:rn ns main err code: 12535rn rnTNS-12535: TNS: 操作超时rn ns secondary err code: 12560rn nt main err code: 505rn rnTNS-00505: 操作超时rn nt secondary err code: 60rn nt OS err code: 0rn Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=124.236.237.17)(PORT=49358))rnTue Aug 08 08:37:21 2017rnThread 1 cannot allocate new log, sequence 340646rnPrivate strand flush not completern Current log# 4 seq# 340645 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOGrnThread 1 advanced to log sequence 340646 (LGWR switch)rn Current log# 5 seq# 340646 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOGrnTue Aug 08 08:42:40 2017rnThread 1 cannot allocate new log, sequence 340647rnPrivate strand flush not completern Current log# 5 seq# 340646 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOGrnThread 1 advanced to log sequence 340647 (LGWR switch)rn Current log# 6 seq# 340647 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOGrnTue Aug 08 08:45:22 2017rnThread 1 cannot allocate new log, sequence 340648rnPrivate strand flush not completern Current log# 6 seq# 340647 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOGrnThread 1 advanced to log sequence 340648 (LGWR switch)rn Current log# 1 seq# 340648 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOGrnTue Aug 08 08:45:52 2017rnThread 1 advanced to log sequence 340649 (LGWR switch)rn Current log# 2 seq# 340649 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOGrnTue Aug 08 08:46:25 2017rnThread 1 cannot allocate new log, sequence 340650rnPrivate strand flush not completern Current log# 2 seq# 340649 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOGrnThread 1 advanced to log sequence 340650 (LGWR switch)rn Current log# 3 seq# 340650 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOGrn

没有更多推荐了,返回首页

私密
私密原因:
请选择设置私密原因
  • 广告
  • 抄袭
  • 版权
  • 政治
  • 色情
  • 无意义
  • 其他
其他原因:
120
出错啦
系统繁忙,请稍后再试

关闭