debug procedure hangs in pl-sql developer

[Crisil]

Problem Description
---------------------------------------------------
debugging procedure gets hanged in pl-sql developer tool connecting to Oracle 11.2.0.2.0 G rac 2-Nodes configuration database.

Version of pl/sql is 7.1

 

[sagizvi]

We had this issue too.
Try connecting to the sid itself, and not through service.

 

[Crisil]

Hi sagizvi,

We even tried with the individual Node entries to conect to particular node , but still hanging occurs while debugging.

 

[Marco Kalter]

The Oracle Debug API (sys.dbms_debug) internally uses dbms_pipe messages to communicate between the controlling session and the debug session, which apparently can fail on RAC systems. The only workaround is to modify the tnsnames.ora file to connect to only 1 node of the cluster without load balancing and failover.