您好,登錄后才能下訂單哦!
這篇文章主要介紹數(shù)據(jù)庫中如何解決ORA-12170:TNS connect timeout occurred問題,文中介紹的非常詳細(xì),具有一定的參考價(jià)值,感興趣的小伙伴們一定要看完!
公司服務(wù)器周末要加硬盤,周一來后應(yīng)用連不上了。報(bào)錯(cuò)如下 報(bào)錯(cuò): ORA-12170:TNS connect timeout occurred
第一反應(yīng)是監(jiān)聽沒開:
1. 測(cè)試了一下, 連接超時(shí)沒用ping 通
C:\Users\Administrator>tnsping brorcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-6月 -2015 09:45:43
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的參數(shù)文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 適配器來解析別名
嘗試連接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.14.147.112)(PORT = 42525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = brorcl)))
TNS-12535: TNS: 操作超時(shí)
2. 我登陸到遠(yuǎn)程服務(wù)器上,查看了一下監(jiān)聽的狀態(tài)
C:\Documents and Settings\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-6月 -2015 09:52:54
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 15-6月 -2015 09:36:02
Uptime 0 days 0 hr. 16 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File F:\app\Administrator\product\11.2.0\dbhome_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x3650m3)(PORT=47512)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=47512)))
Services Summary...
Service "BANKASSIST" has 1 instance(s).
Instance "brorcl", status READY, has 1 handler(s) for this service...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "brorcl" has 2 instance(s).
Instance "brorcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "brorcl", status READY, has 1 handler(s) for this service...
Service "brorclXDB" has 1 instance(s).
Instance "brorcl", status READY, has 1 handler(s) for this service...
The command completed successfully
看到監(jiān)聽也正常,本地連接進(jìn)去也很正常。
3. 我想了一下本地能訪問遠(yuǎn)程連接不上是不是防火墻問題,于是我關(guān)閉了windows防火墻,果然在遠(yuǎn)程tnsping 能ping通了;
4. 結(jié)果:應(yīng)該是防火墻有改動(dòng)了,最后把 服務(wù)器防火墻的 ip和端口添加為例外,應(yīng)用恢復(fù)正常了。
以上是“數(shù)據(jù)庫中如何解決ORA-12170:TNS connect timeout occurred問題”這篇文章的所有內(nèi)容,感謝各位的閱讀!希望分享的內(nèi)容對(duì)大家有幫助,更多相關(guān)知識(shí),歡迎關(guān)注億速云行業(yè)資訊頻道!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。