當前位置 主頁 > 網站技術 > 代碼類 > 最大化 縮小

    解決ORA-12170:TNS connect timeout occurred問題

    欄目:代碼類 時間:2019-12-31 06:11

    公司服務器周末要加硬盤,周一來后應用連不上了。報錯如下 報錯: ORA-12170:TNS connect timeout occurred 

    第一反應是監聽沒開:

    1. 測試了一下, 連接超時沒用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.

    已使用的參數文件:

    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: 操作超時

    2. 我登陸到遠程服務器上,查看了一下監聽的狀態

    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...

    下一篇:沒有了
青海十一选五开奖数据 趋势为王结构修边详解 股票配资公司保障客户资金安全的方法 深圳福利彩票深圳风采 湖南幸运赛车开奖结果爱彩人 百家乐官网 下载吉祥棋牌? 51配资 江西快3开奖最新预测 海王捕鱼2无限金币版 辽宁十一选五一定午