My Oracle Support Banner

在 11g 12c已经更高版本的数据库中 alert 日志中报 Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out' (Doc ID 2226594.1)

Last updated on AUGUST 16, 2018

适用于:

Oracle Net Services - 版本 11.1.0.6 到 12.2.0.1 [发行版 11.1 到 12.2]
本文档所含信息适用于所有平台
TNS-12170, ORA-12170, TNS-12535, TNS-00505 alert.log


症状

 

nt secondary err code: 110 检测 11g 数据库的 alert 日志能看到下面大量的超时相关的信息,如:

- 在 Oracle Solaris 上:

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

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Solaris: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.1.0 - Production
Time: 22-JAN-2011 21:48:23
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: 145
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.xxx.yy.117)(PORT=1092))

---------
信息"nt secondary err code"在不同的 OS系 统上显示不同:

Linux x86 or Linux x86-64: "nt secondary err code: 110"
HP-UX Server: "nt secondary err code: 238"
AIX: "nt secondary err code: 78"



更改

没有必须的变更,但是近期可能升级数据库到 11g 版本1或者更高版本,或者是新安装的 Oracle 11g 数据库。

注意:11gR1 版本之前同样的信息'Fatal NI connect error 12170'是写入 sqlnet.log 中的。

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.