听众拒绝使用以下错误的连接:ORA-12514，TNS:侦听器当前不知道连接描述符中要求的服务

Question

在尝试连接到远程数据库时会遇到错误

这是我的tnsnames.ora文件

       XE =
   (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = XE)
)
)
    EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
 (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
  )
   (CONNECT_DATA =
  (SID = PLSExtProc)
  (PRESENTATION = RO)
  )
 )
 ORACLR_CONNECTION_DATA = 
 (DESCRIPTION = 
  (ADDRESS_LIST = 
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
  ) 
  (CONNECT_DATA = 
  (SID = CLRExtProc) 
  (PRESENTATION = RO) 
 ) 
) 
[Sql Developer][1]

Answer 1

据我所知，您发布的TNSNAMES.ORA文件中没有"远程"数据库别名。我相信您应该包括它，然后重试。