ora-12514:TNS:listener does not currently know of service requested in connect descriptor
来源:互联网 发布:网络机柜几u啥意思 编辑:程序博客网 时间:2024/05/05 12:26
监听目前不知道要求服务连接描述符
这个错误是因为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 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 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
- centos: 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
- 位移传感器MPU6050的使用
- JQUERY剪裁图片插件
- MATLAB之插值
- android 系统资源文件
- vijos 1028 最长上升序列。
- ora-12514:TNS:listener does not currently know of service requested in connect descriptor
- opencv视频获取显示代码问题和调试
- 学习Scala:伴生对象的实现原理
- js实现网页图片延时加载的原理和代码 提高网站打开速度
- 计算机经典书籍电子书合集(适合计算机学生学习以及程序员笔试、面试)
- 多线程的那点儿事(之无锁队列)
- java之内部类
- Guzz DatabaseSharding
- 编程之美----相似字符串匹配(解答记录)