ORA-12514: TNS:listener does not currently know of service requested in connect

最新推荐文章于 2023-08-31 14:56:00 发布

杨咩咩yang

最新推荐文章于 2023-08-31 14:56:00 发布

阅读量453

点赞数 1

分类专栏：数据库文章标签： oracle 12514

本文链接：https://blog.csdn.net/yang1393214887/article/details/115325269

版权

数据库专栏收录该内容

27 篇文章 0 订阅

订阅专栏

plsql远程连接失败：

修改Oracle的配置文件：

listener.ora

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

SID_LIST_LISTENER =
(SID_LIST =
   (SID_DESC =
   (GLOBAL_DBNAME = ORCL)
   (ORACLE_HOME = C:\app\adcc\product\11.2.0\dbhome_1)
   (SID_NAME = ORCL)
   )
  (SID_DESC =
  (PROGRAM = extproc)
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = C:\app\adcc\product\11.2.0\dbhome_1)
  )
)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-2EMFS43VSLP)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = C:\app\adcc

tnsnames.ora

# tnsnames.ora Network Configuration File: C:\app\adcc\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

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

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


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

注意：oracle检查严格，有多余的空格或者括号没对齐，将不能识别，需要严格仔细检查空格和括号的对其