在 sqlnet.log 中錯誤如下：

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

總結

以上是生活随笔為你收集整理的关于 Fatal NI connect error 12170的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。