ORA-12514: TNS:listener does not currently know of service requested in connect
来源:互联网 发布:使命召唤7mac版下载 编辑:程序博客网 时间:2024/06/05 03:56
这个错误是因为Listener出了问题,请检查一下你的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)
)
)
这样以后,关掉Service和LISTENER。再启动Service和LISTENER,这样应该就可以了,注意顺序。
查了一下,网上是说,加上了面一段东西,意思是把LISTENER服务主动注册到进程监视器(pmon)中去。所以,但你启动了Serivce后,启动LISTENER的时候,会主动去注册到进程监视器(pmon)中去。所以不会有什么问题。但是反过却不行。
如果说没有添加那一段,情况正好相反,是由实例的pmon进程在LISTENER中注册服务,LISTENER为被动注册。所以需要先起LISTENER才可以。
总结一下,如果说你不加那段东西,那么就应该先起LISTENER,如果说你加了那段东西,就应该先起Serivce。
我试了一下,的确是这样。不过在windows上,有时候会报错,重启一下再试就可以了。
- ERROR - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect 错误
- ORA-12514: TNS:listener does not currently know of service requested in connect
- 遭遇ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ora-12514:TNS:listener does not currently know of service requested in connect
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect
- ORA-12514: TNS:listener does not currently know of service requested in connect
- ORA-12514: TNS:listener does not currently know of service requested in connect
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS: listener does not currently know of service requested in connect descriptor
- ora-12514:TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ora-12514:TNS:listener does not currently know of service requested in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descript
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ora-12514:TNS:listener does not currently know of service requested in connect descriptor
- 自定义收藏夹
- 新浪地产打卡程序新版出炉
- BlackBerry平台图片缩放功能-Bitmap
- 在c#中怎么调用ExitWindowsEx函数实现XP的关机、注销、重启操作?
- MvcContrib Grid SlickUpload
- ORA-12514: TNS:listener does not currently know of service requested in connect
- C#三种模拟自动登录和提交POST信息的实现方法
- perl学习笔记
- STL容器map的一段代码
- 教授发的
- http://acm.hdu.edu.cn/showproblem.php?pid=2710
- MTK中MMI_Task的消息机制
- MOTO工作的日子
- 100首英文歌曲