ORA-12514错误：Listener refused the connection with the following

本文主要是介绍ORA-12514错误：Listener refused the connection with the following，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

ORA-12514错误：Listener refused the connection 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 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))

在重启下监听器就可以了

这篇关于ORA-12514错误：Listener refused the connection with the following的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！