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))
在重启下监听器就可以了