ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How do I debug PL/SQL when connected to a RAC?

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

原创 Linux操作系统 作者:sanxiagirl 时间:2011-02-17 15:52:29 0 删除 编辑

问题现象描述: 
将存储过程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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-02

  • 博文量
    142
  • 访问量
    517437