ORA-12514

最新推荐文章于 2023-10-30 17:16:20 发布

野火少年

最新推荐文章于 2023-10-30 17:16:20 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： orcl错误笔记 orcl

本文链接：https://blog.youkuaiyun.com/ItJavawfc/article/details/37651987

数据库专栏收录该内容

36 篇文章

订阅专栏

1.oracle11g部署问题（3）之ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务

找到listener.ora监听文件，具体位置：D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

# listener.ora Network Configuration File: D:\app\Administrator\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\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )


<span style="color:#FF6666;">
#-----------------------------------------
   (SID_DESC =

     (GLOBAL_DBNAME = orcl)

     (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)

     (SID_NAME = orcl)

   )

 #-----------------------------------------</span>







  )

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

ADR_BASE_LISTENER = D:\app\Administrator

添上以上的红色部分即可：

然后再通过客户端Net configuration Assistant去配置本地网络服务名配置即可，会看到测试通过

2.如果是无监听程序：可以参考如下，

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

今天上班遇到一个问题，也报这个错误：最后发现是自己的服务关了之后没有开，也报这样的错误。