Orcale学习——无法监听（Listener refused the connection with the following error

最近学习Orcale遇到下面的问题：

<ERROR> Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
//localhost:1521/ecmis

昨天还正常呢，今天就报错误了；

在网上查了很多资料，虽然浪费了很多时间，不过还是解决了

原来是由于ip地址改变引起的“ORA-12541:TNS:无监听程序”错误

解决方法：

查看listener.ora的内容：
# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
)
LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
)

 

原来本机的ip发生改变后，就出现了上述问题，改变数据库的监听ip地址:
把(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
改成
(ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))

在重启下监听器就可以了