RAC and debug mode

[Isaac Blank]

Hi,

we are switching to Oracle RAC, and we can no longer use debug mode as it requires DBMS_PIPE. Are there any workarounds/enhancements?

Thanks,

Isaac Blank

 

[Marco Kalter]

This is indeed a known issue. We do not yet have a solution.

 

[Grisa]

Hi Marco,

Any update on this? I'm eagerly waiting for a patch to repair debug on rac in plsqldev.

Br,
Grisa

 

[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.