(SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = D:\oracle\prod

安装完oracle，用PL/sql登陆不进去，报ora-12514的错误。

解决办法：

1. 打开<OracleHome>/network/admin/listener.ora文件，找到：

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = C:\oracle\product\10.1.0\Db_2)

      (PROGRAM = extproc)

    )

 

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

      )

      (ADDRESS_LIST =

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

      )

    )

  )

 

加上 (SID_DESC =

       (GLOBAL_DBNAME = ORCL)

       (ORACLE_HOME = C:\oracle\product\10.1.0\Db_2)  

       (SID_NAME = ORCL)

      )

后完整文件内容：

 

# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_2\network\admin\listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = C:\oracle\product\10.1.0\Db_2)

      (PROGRAM = extproc)

    )

(SID_DESC =

       (GLOBAL_DBNAME = ORCL)

       (ORACLE_HOME = C:\oracle\product\10.1.0\Db_2)  

       (SID_NAME = ORCL)

      )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

      )

      (ADDRESS_LIST =

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

      )

    )

  )

 

保存，重启监听即可