TNS-12170 連線超時
在 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
------>>http://blog.csdn.net/roland_wg/article/details/3446204
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
------>>http://blog.csdn.net/roland_wg/article/details/3446204
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29119536/viewspace-1338512/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- PostgreSQL 連線 超時異常SQL
- python 連線 mongo 資料庫連線超時PythonGo資料庫
- ssh連線超時的解決
- Redis連線超時排查實錄Redis
- 應用連線超時排查DB MySQLMySql
- 解決代理連線超時問題
- boost::asio設定同步連線超時
- ORA-12170:TNS:連線超時
- ORA-12170: TNS: 連線超時
- ORA-12170 TNS 連線超時
- 關於在執行java連線MongoDB時遇到的連線超時問題JavaMongoDB
- FileZilla 連結伺服器提示 20 秒連線超時伺服器
- socket測試遠端地址能否連線併為連線設定超時
- 今天,你遇到redis線上連線超時了嗎?Redis
- (轉)hbase master掛掉-zookeeper連線超時原因AST
- .net 資料庫連線池超時問題資料庫
- pymysql 處理 連線超時最好的解決方案MySql
- 使用secureCRT連線伺服器,防超時斷開Securecrt伺服器
- CSS如何去除超連結點選時的虛線CSS
- oracle連線超時自動斷開問題[轉]Oracle
- win10系統下ftp連線失敗提示“連線已超時”怎麼辦Win10FTP
- 公司內網使用git clone報錯ssh連線超時內網Git
- tomcat連線池配置,解決資料庫超時Tomcat資料庫
- Oracle資料庫出現連線超時案例之一Oracle資料庫
- 對於tnsping的連線超時的功能補充
- 網路連線總超時?從四層模型上解析網路是怎麼連線的模型
- QPS過萬,redis大量連線超時怎麼解決?Redis
- 電腦連線使用代理ip顯示超時怎麼辦
- CentOS 7 SSH 連線超時自動斷開解決方案CentOS
- SecureCRT使用SSH連線linux超時後自動斷開SecurecrtLinux
- 對於tnsping的連線超時的功能補充(二)
- SecureCRT 超時自動斷開連線問題解決方法Securecrt
- 以太坊公鏈節點連線節點超時問題排查
- MYSQL++ 資料庫連線超時的解決辦法LTMySql資料庫
- Springboot 連線池wait_timeout超時設定Spring BootAI
- PHPSOAPphp調取soap的webservice連線超時的問題PHPAPPWeb
- Curator 重連策略與超時
- *(轉)超時時間已到。超時時間已到 但是尚未從池中獲取連線。出現這種情況可能是因為所有池連線均在使用 並且達到了最大池大小。