oracle12c dql developer连接报错：IO 错误: The Network Adapter...供应商代码 17002

[weixin_41258637]

这是报错框


这是listener.ora的全部内容{
# listener.ora Network Configuration File: E:\app\orcl\product\12.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\app\orcl\product\12.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\orcl\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

}
这是tnsnames.ora的全部内容{
# tnsnames.ora Network Configuration File: E:\app\orcl\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 194.168.124.2)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
}


别的东西我都没动过 ,这两个文件的host值原来是localhost我改成了我的主机名。我是java初学者 今天刚学到oracle， 本来好好的可以用 ， 到了要用DESC读取表格的时候就怎么也读不出来（写出来的表格是正常的）。后来DQL Developer程序就卡住了 。我强退了一下再进就这样了，求指教， 谢谢。

[碧水幽幽泉]

LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = 194.168.124.2)(PORT = 1521)) 这个配置是错误的，缺少DESCRIPTION = 。。。。很多信息。 你把它删除后，看下能不能登录。

[weixin_41258637]

引用 1 楼 qq646748739 的回复:

LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = 194.168.124.2)(PORT = 1521)) 这个配置是错误的，缺少DESCRIPTION = 。。。。很多信息。 你把它删除后，看下能不能登录。

我试了，还是不行，报一样的错。DESCRIPTION = 。。。。下面不是都有吗？

[hello_world_Q]

主机名改成 localhost或者127.0.0.1