连接Oracle数据库报错：The Network Adapter could not establish the connection

原创

于 2019-11-04 14:01:51 发布 · 7.1k 阅读

连接Oracle数据库报错：

IO Error: The Network Adapter could not establish the connection
  The Network Adapter could not establish the connection
  The Network Adapter could not establish the connection
    Connection refused: connect, socket connect lapse 1003 ms. /192.168.1.104 1521 0 1 true
    Connection refused: connect, socket connect lapse 1003 ms. /192.168.1.104 1521 0 1 true
      Connection refused: connect
      Connection refused: connect

在这里插入图片描述
在cmd输入lsnrctl查看监听

C:\Windows\System32>lsnrctl

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 04-11月-2019 13:56:32

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

欢迎来到LSNRCTL, 请键入"help"以获得信息。

LSNRCTL> status
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DESKTOP-210GC98)(PORT=1521)))
TNS-12541: TNS: 无监听程序
 TNS-12560: TNS: 协议适配器错误
  TNS-00511: 无监听程序
   64-bit Windows Error: 61: Unknown error
正在连接到 <