Ora-12514和Ora-12514解决方法

陈晓龙 · 发表于 2020-5-7 17:19:18

打开：D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora文件
在
  SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
   (PROGRAM = extproc)
)
后面添加：
(SID_DESC =
   (GLOBAL_DBNAME = ORCL)
   (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
   (SID_NAME = ORCL)
   )

  最后变成：
SID_LIST_LISTENER =
(SID_LIST =
   (SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
   (PROGRAM = extproc)
   ) (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (SID_NAME = ORCL)
   )
)