ORA-12514: TNS:listener does not currently know of service requested in connect
来源:互联网 发布:dnf钓鱼网站源码 编辑:程序博客网 时间:2024/06/04 19:19
这个错误是因为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
- linux Mplayer安装全过程(x386)(转)
- jsp重复提交问题
- C#实现一个用于开机启动其他程序的Windows服务(2009-07-01)
- java基于TCP的socket编程简单实现[代码实践过]
- 2009应用基础设施/中间件发展趋势
- ORA-12514: TNS:listener does not currently know of service requested in connect
- 微软全球副总裁李开复给中国青年的一封信
- 用jsp直接导出内存中生成excel文件
- 锁定老贴子 主题:介绍CJDBC
- 创业中我学会了比上学和打工还珍贵的经验,虽然一直在碰撞
- SQL Server中临时表与表变量的区别
- 进程之间通讯的几种方法:
- 如何使button中绘制图标
- Access到SQL的数据同步