爱华网ORA-12514错误：Listener refused theconnection with the following error
Orcale学习——无法监听（Listener refused the connection with the follo...最近学习Orcale遇到下面的问题：
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of servicerequested 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:oracleproduct10.2.0db_1networkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracleproduct10.2.0db_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))
在重启下监听器就可以了
