oracle no listener issues ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

最新推荐文章于 2021-12-23 15:08:51 发布

rib-pet

最新推荐文章于 2021-12-23 15:08:51 发布

阅读量149

点赞数

分类专栏： Java 文章标签： db

tony-nf.peng

本文链接：https://blog.youkuaiyun.com/ningfeng8899/article/details/116706863

版权

Java 专栏收录该内容

21 篇文章

订阅专栏

本文详细介绍了Oracle数据库中Listener配置文件listener.ora的具体设置方法。包括如何正确配置监听器的地址和端口信息，以及解决常见错误的方法。对于需要在特定主机名上运行Oracle服务的情况，提供了具体的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-DVQ3QKG)(PORT = 1521))
      )
    )
  )

solution : replace Host = your manchine name, it can fix the oracle issue

# listener.ora Network Configuration File: D:\app\PC\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\PC\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\PC\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-DVQ3QKG)(PORT = 1521))
)
)
)

ADR_BASE_LISTENER = D:\app\PC