Oracle10g 中配置连接ora-12514的错误处理

最新推荐文章于 2022-08-24 17:48:51 发布

rink010

最新推荐文章于 2022-08-24 17:48:51 发布

阅读量787

点赞数

分类专栏： DataBase 文章标签： oracle10g oracle list 数据库

本文链接：https://blog.csdn.net/rink010/article/details/2511575

版权

DataBase 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

在oracle10g中通过sqlplus链接数据库时报ora-12514错误，记录一下处理过程：

在监听器的listener.ora中
SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10gR1)
      (PROGRAM = extproc)
    )
)
添加
(SID_DESC =
       (GLOBAL_DBNAME = ora10g)
       (ORACLE_HOME = /opt/oracle/product/10gR1)
       (SID_NAME = ora10g)
      )

最终成为
SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10gR1)
      (PROGRAM = extproc)
    )
(SID_DESC =
       (GLOBAL_DBNAME = ora10g)
       (ORACLE_HOME = /opt/oracle/product/10gR1)
       (SID_NAME = ora10g)
      )