oracle会话连接超时,案例:Fatal NI error 12170 TNS-12535 00505会话超时导致应用异

天萃荷净

Oracle数据库日志Errors: 12170 TNS-12535 TNS-00505: Operation Timed Out

客户反馈系统经常报会话超时,导致应用测试无法正常进行,经检查alert日志发现

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for HPUX: Version 11.2.0.4.0 - Production

Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.2.0.4.0 - Production

TCP/IP NT Protocol Adapter for HPUX: Version 11.2.0.4.0 - Production

Time: 29-SEP-2014 20:42:56

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: 238

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.78.199.47)(PORT=55447))

Mon Sep 29 20:42:56 2014