ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

原文来自于：http://blog.sina.com.cn/s/blog_7c0e26230100t0ci.html

这个错误是因为Listener出了问题，请检查一下你的listener.ora文件，看下是否存在如下配置：
位置：C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN

1.listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
如果说是这样，那么请将一段改成
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
) (SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)

2.tnsnames.ora
打开后添加
“你的IP” =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = “你的IP”)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = “你要连接的数据库名”)
)
)
以上两部操作完成后，重启所有的Oracle服务。