主頁(yè) > 知識(shí)庫(kù) > 解決ORA-12170:TNS connect timeout occurred問(wèn)題

解決ORA-12170:TNS connect timeout occurred問(wèn)題

熱門標(biāo)簽:地圖標(biāo)注坐標(biāo)圖標(biāo) 手機(jī)地圖標(biāo)注門店 地圖標(biāo)注效果的制作 安陽(yáng)企業(yè)電銷機(jī)器人供應(yīng)商 汽車4s店百度地圖標(biāo)注店 鶴壁電話機(jī)器人價(jià)格 杭州網(wǎng)絡(luò)外呼系統(tǒng)運(yùn)營(yíng)商 電銷套路機(jī)器人 網(wǎng)貸外呼系統(tǒng)合法嗎

公司服務(wù)器周末要加硬盤,周一來(lái)后應(yīng)用連不上了。報(bào)錯(cuò)如下 報(bào)錯(cuò): ORA-12170:TNS connect timeout occurred 

第一反應(yīng)是監(jiān)聽(tīng)沒(méi)開(kāi):

1. 測(cè)試了一下, 連接超時(shí)沒(méi)用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 適配器來(lái)解析別名

嘗試連接 (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īng)的狀態(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)聽(tīng)也正常,本地連接進(jìn)去也很正常。

3.  我想了一下本地能訪問(wèn)遠(yuǎn)程連接不上是不是防火墻問(wèn)題,于是我關(guān)閉了windows防火墻,果然在遠(yuǎn)程tnsping 能ping通了;

4. 結(jié)果:應(yīng)該是防火墻有改動(dòng)了,最后把 服務(wù)器防火墻的 ip和端口添加為例外,應(yīng)用恢復(fù)正常了。

總結(jié):

一般遇到tns 的問(wèn)題通常都是監(jiān)聽(tīng)或者是網(wǎng)絡(luò)問(wèn)題

          1. 查看監(jiān)聽(tīng)是否正常
          2. 查看 ip 或端口有沒(méi)有改動(dòng)
          3. 查看防火墻

以上所述是小編給大家介紹的解決ORA-12170:TNS connect timeout occurred問(wèn)題,希望對(duì)大家有所幫助!

您可能感興趣的文章:
  • python使用pip安裝模塊出現(xiàn)ReadTimeoutError: HTTPSConnectionPool的解決方法
  • linux上TCP connection timeout問(wèn)題解決辦法
  • Jedis出現(xiàn)connection timeout問(wèn)題解決方法(JedisPool連接池使用實(shí)例)

標(biāo)簽:銀川 南陽(yáng) 河源 泰安 焦作 柳州 酒泉 梧州

巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《解決ORA-12170:TNS connect timeout occurred問(wèn)題》,本文關(guān)鍵詞  解決,ORA-12170,TNS,connect,timeout,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題,煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們,我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無(wú)關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《解決ORA-12170:TNS connect timeout occurred問(wèn)題》相關(guān)的同類信息!
  • 本頁(yè)收集關(guān)于解決ORA-12170:TNS connect timeout occurred問(wèn)題的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章