ORA-3136
alert 日志报错: WARNING: inbound connection timed out (ORA-3136)
Thu Jan 20 19:01:06 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 20 19:49:04 2011
Thread 1 advanced to log sequence 16433 (LGWR switch)
Current log# 2 seq# 19886mem# 0: /home/dbabc.net/oradata/redo02.log
同时sqlnet.log出现:
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 10.2.0.4.0 – Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.4.0 – Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0 – Production
Time: 20-JAN-2011 19:01:06
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=192.168.0.5)(PORT=10233))
经查可以通过 metalink id 465043.1解决。网上的信息也一大堆,不详细记录了。