侦听器启动失败，TNS-01150和TNS-01153

Question

我已在windows 10中安装了oracle18c xe，我正在连接Oracle，但得到错误TNS-01150:指定侦听器名的地址不正确TNS-01153:未能处理字符串：(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost))(PORT=1521))。

侦听器启动失败。

这是我的TNSNAMES.ORA：

# tnsnames.ora Network Configuration File: C:\app\dkcal\product\18.0.0\dbhomeXE\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

LISTENER_XE =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost))(PORT = 1521))

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

XEPDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1000))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XEPDB1)
    )
  )

LISTENER_XEPDB1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost))(PORT = 1000))

我的LISTENER.ORA：

# listener.ora Network Configuration File: C:\app\dkcal\product\18.0.0\dbhomeXE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

DEFAULT_SERVICE_LISTENER = XE

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost))(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

LISTENER_1 =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost))(PORT = 1000))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\dkcal\product\18.0.0\dbhomeXE)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\dkcal\product\18.0.0\dbhomeXE\bin\oraclr18.dll")
    )
  )

SID_LIST_LISTENER_1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\dkcal\product\18.0.0\dbhomeXE)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\dkcal\product\18.0.0\dbhomeXE\bin\oraclr18.dll")
    )
  )

Answer 1

看起来您有一个乱七八糟的括号，这里：

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost) -> ) <- (PORT=1521)) 

试试这个：

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))