数据库“Fatal NI connect error 12170”问题,从本质上是由于长连接数据库交互方式造成的,严格意义上不应算什么错误问题。如果是一些三层架构体系应用,可以考虑使用连接池进行动态资源调配的方式,对问题进行缓解。
客户数据库版本为oracle 11.2.0.4,在给客户巡检数据库过程中,进行DB Alert Log分析,发现alertSID.log特别大,使用vi进行编辑查看发现,日志文件中出现大量Fatal NI connect error 12170/TNS-12535: TNS:operation timed out/TNS-00505: Operation timed out告警信息,如下图所示: 大量的12710/12535/00505告警日志使alert...
Fatal NI connect error 12170.VERSION INFORMATION:TNS for Linux: Version 18.0.0.0.0 - ProductionOracle Bequeath NT Protocol Adapter for Linux: Version 18.0.0.0.0 - ProductionTCP/IP NT Protocol Adapter for Linux: Version 18.0.0.0.0 - ProductionVersion 18.13.0.0.0Time: 18-APR-2022 18:55:24Tra...
Fatal NI connect error 12170.VERSION INFORMATION:TNS for Linux: Version 18.0.0.0.0 - ProductionOracle Bequeath NT Protocol Adapter for Linux: Version 18.0.0.0.0 - ProductionTCP/IP NT Protocol Adapter for Linux: Version 18.0.0.0.0 - ProductionVersion 18.13.0.0.0Time: 18-APR-2022 18:55:24Tra...
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=172.xx.xx.xx)(PORT=50741)) ...
TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code: 0 原因是自动诊断仓库特性默认是将这些连接失败信息写入告警日志里的,故导致了告警日志里存在大量的类似错误信息 具体的原因和解决的办法参考: Fatal NI connect error 12170错误解决办法_lldustc的博客-CSDN博客 ...
TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code: 0 原因是自动诊断仓库特性默认是将这些连接失败信息写入告警日志里的,故导致了告警日志里存在大量的类似错误信息 具体的原因和解决的办法参考: Fatal NI connect error 12170错误解决办法_lldustc的博客-CSDN博客 ...
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=172.xx.xx.xx)(PORT=50741)) ...
TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code: 0 原因是自动诊断...
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=172.xx.xx.xx)(PORT=50741)) ...