linux oracle 12514错误解决办法

解决方法：

1. 打开<OracleHome>/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)

     )

   )

  2. 查看ORACLE_SID名称为：orcl；添加：

            (SID_DESC =

       (GLOBAL_DBNAME = orcl)

       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) 

       (SID_NAME = orcl)

      )

  3. 最后变成：

 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)

      )

   )

  4. 保存文件，重启服务中的TNSListener，OK！