ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Fatal NI connect error 12170

Fatal NI connect error 12170

原创 Linux操作系统 作者:lhb_immortal 时间:2011-06-27 14:02:56 0 删除 编辑

以下内容来源网络。

因此问题一直在困扰我。将网上的解决方法找来做下记录。但是是否真的有用,有待确认。

特此声明。此方法尚未进行测试。


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Linux: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 29-NOV-2006 19:13:40
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=219.239.13.3)(PORT=19948))


# oerr tns 12170
12170, 00000, "TNS:Connect timeout occurred"
// *Cause: The server shut down because connection establishment or
// communication with a client failed to complete within the allotted time
// interval. This may be a result of network or system delays; or this may
// indicate that a malicious client is trying to cause a Denial of Service
// attack on the server.
// *Action: If the error occurred because of a slow network or system,
// reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT,
// SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values.
// If a malicious client is suspected, use the address in sqlnet.log to
// identify the source and restrict access. Note that logged addresses may
// not be reliable as they can be forged (e.g. in TCP/IP).

于是增大 sqlnet.ora 中的参数:
SQLNET.INBOUND_CONNECT_TIMEOUT = 30
SQLNET.RECV_TIMEOUT = 30
SQLNET.SEND_TIMEOUT = 30

在 listener.ora 增加:
INBOUND_CONNECT_TIMEOUT_LISTENER = 30

重启监听器:
lsnrctl reload

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25313300/viewspace-700800/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: ORA-00257
请登录后发表评论 登录
全部评论

注册时间:2011-01-29

  • 博文量
    7
  • 访问量
    423936