oracle的tns错误,oracle常见tns错误解决办法.doc

oracle常见tns错误解决办法.doc

还剩

7页未读，

继续阅读

下载文档到电脑，马上远离加班熬夜！

亲，喜欢就下载吧，价低环保！

内容要点：

ORA-12203,ORA-12560, NL-462 or NL-427.Solution:Recreate the listener.ora file.Explanation:Some corruption in the listener.ora may get unable to the tnslsnr to work adequatly.4.- Failed to start service, TNS-12560, TNS-00530 when create new listener servicesProblem:To recreate Oracle TNS listener service on Windows NT, you delete the service entry in registry. When using lsnrctl to start the listener, you get the following errors:LSNRCTL> startStarting tnslsnr: please wait...Failed to start service, error 3.TNS-00530: Protocol adapter errorThe Listener service is not recreated and the Listener would not start.You are using a valid listener.ora file and protocol adapters.Solution:After you delete the Listener service from registry, you have to reboot NT for it to take effect. Then you can use lsnrctl to start the Listener, which would re-create the listener service.Explanation:The Listener service is marked ''disabled'', but it still exists after you delete the service from registry.You try to start up the listener and receive the following error stack:TNS-12542: TNS:address already in useTNS-12560: TNS Protocol adapter errorTNS-00512: Address already in use32-bit Windows Error: 48: Unknown errorError: TNS 512Text: Address already in use--------------------------------------------Cause: Specified listener address is already being used.Action: Start your listener with an unused address.Generally this problem may ocurr for a incorrect setting in the listener.ora. Some causes of this problems may be:a.- Some defined address in the listeners.ora is been used. Make sure other l

发表评论

暂无评论，赶快抢占沙发吧。