ora 12514 tns监听程序当前无法识别

E:\oracle\NETWORK\ADMIN\listener.ora 还一个在同路径下的tnsnames.ora文件（这是我自己的安装路径）

打开listener.ora：

# listener.ora Network Configuration File: E:\oracle\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle)
      (PROGRAM = extproc)
    )
      (SID_DESC = 
      (GLOBAL_DBNAME = orcl) 
      (ORACLE_HOME = E:\oracle) 
      (SID_NAME = orcl) 
    ) 
  )

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

标红的是我新加的，然后重启oracle服务就行了。

ora 12514 tns监听程序当前无法识别

原文：http://blog.csdn.net/m_123hj_520/article/details/44647919