How do I debug PL/SQL when connected to a RAC?

最新推荐文章于 2026-01-08 18:49:09 发布

转载最新推荐文章于 2026-01-08 18:49:09 发布 · 158 阅读

文章标签：

#php

本文针对使用PL/SQL调试器时出现的ORA-12560:TNS:protocol adapter error问题进行了详细解析，并提供了有效的解决方案。主要讨论了在连接到RAC数据库进行调试时，如何正确配置TNSNames.ora文件或直接连接到集群实例。

问题现象描述：
将存储过程load in editor，设置断点，运行后依次发生下列错误提示：
ORA-12560: TNS:protocol adapter error
Cannot connect debug session. In order to debug when connected to a RAC instance you must have entries for the individual RAC instances in your tnsnames.ora file or connect directly to an individual RAC instance.
google后得知：
源文档 < http://asktoad.com/DWiki/doku.php/faq/answers/procedure_editorDokuWiki=e217ad0ed5bdf990bcc4b95bb9be96b9 >
When using the PL/SQL Debugger with a RAC database, you must either have an additional entry in your TNSNames.ora file for the connected instance, or you must connect directly to an instance of the cluster without letting the server assign an instance.
During debugging, Toad creates two background sessions for handling debugger calls, called the Target and Debug sessions. These two sessions must be created>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10640532/viewspace-687436/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10640532/viewspace-687436/