|
在客户的11gR2数据库的ALERT文件频繁出现Fatal NI connect error 12170错误
Tue Oct 18 19:57:17 2011
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 18-OCT-2011 19:57:17
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=116.236.169.137)(PORT=44548))
Tue Oct 18 19:58:47 2011
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 18-OCT-2011 19:58:47
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=116.236.169.137)(PORT=44567))
Tue Oct 18 19:58:49 2011
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 18-OCT-2011 19:58:49
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=116.236.169.137)(PORT=44539))
Tue Oct 18 20:02:56 2011
Thread 1 advanced to log sequence 359 (LGWR switch)
Current log# 4 seq# 359 mem# 0: /appsdata/oracle/oradata/dbserver/redo04A.rdo
Current log# 4 seq# 359 mem# 1: /appsdata/oracle/oradata/dbserver/redo04B.rdo
Tue Oct 18 20:03:05 2011
Archived Log entry 340 added for thread 1 sequence 358 ID 0xff6d4551 dest 1:
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.
可以通过在SQLNET.ORA文件中设置参数 DIAG_ADR_ENABLED_监听器名称 = OFF 来屏蔽ADR向ALERT写入错误信息。
具体可以参考metalink DOC [ID 1286376.1] | 
免费注册
发表于 2011-12-23 03:31
