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

今天启动连接Oracle的PLSQL时突然报错ORA-12514: TNS:listener does not currently know of service requested in connect

这是因为listener.ora文件出现了问题，打开你安装
oracle目录下的的listener.ora文件，我是安装在虚拟机上的

找到这样一段配置：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:/oracle/product/10.2.0/db_2)
(PROGRAM = extproc)
)
)
改写成
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:/oracle/product/10.2.0/db_2)
(PROGRAM = extproc)
) (SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:/oracle/product/10.2.0/db_2)
(SID_NAME = ORCL)
)
)
注意其中的文件路径填你自己所安装的目录
然后键盘同时按下window+R输入services.msc回车打开服务，找到OracleOraDb10g_home1TNSListener和OracleServiceORCL两个服务先关闭

然后再顺序启动OracleServiceORCL和OracleOraDb10g_home1TNSListener，
一定要按顺序启动
然后重启一下PLSQL就行了。