时间戳

首页 > 解决方案 > TNS-12545：连接失败，因为目标主机或对象不存在

oracle - TNS-12545：连接失败，因为目标主机或对象不存在

问题描述

我正在尝试在 Azure 云 VM 上配置 Oracle 数据库 18C。我已经安装了 Oracle 数据库，现在我正在尝试配置侦听器 我已经为 VM 设置了一个公共静态 IPv4 地址当我尝试在侦听器和 tnsnames 文件中添加 IP 地址时，我收到了这个错误

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
   64-bit Windows Error: 49: Unknown error

这是我的 listener.ora 和 tsnnames.ora 文件配置。

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
     (SID_DESC =
             (SID_NAME = ORCL)
             )
                       
  )


LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IPaddress)(PORT = 1521))
  )

ADR_BASE_LISTENER = C:\Oracle\Oracle18C\log

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IPaddress)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

当我尝试使用本地计算机时，Ping 正在为 IP 地址工作当我尝试使用主机名“oraclevm”时，侦听器能够启动

标签： oraclelisteneroracle18c

解决方案

以下是 listener.ora 的工作示例

[oracle@ol7-19 ~]$ cd $ORACLE_HOME/network/admin
[oracle@ol7-19 admin]$ more listener.ora
# listener.ora Network Configuration File: /home/oracle/Downloads/19c/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ol7-19.localdomain)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )

推荐阅读