Oracle 11g RAC and Test/Debug window in PL/SQL Developer

[Jeremy]

Hi,

I have been having EMails discussions over the last couple of weeks with All round automations but have had no resolution. Thought I'd post the relevant details on the forum so you're all aware (read chronologically from top down):

INITIAL EMAIL
=============
We are moving to an Oracle 11g RAC configuration at the moment. I seem to have a bug with PL/SQL Developer in that when I run a Test window and try to complete the Test the window appears to hang

 

[Worker]

It seems you're not alone. I found three other threads discussing problems debugging on Oracle RAC. Maybe they will provide some answers.

 

[Stew Stryker]

I've experienced this too, even though I tried the workaround that Simon Bridgnell mentioned.

RAC has its advantages, but we've definitely seen problems with it, and it's caused our DBAs some sleepless nights (and weekends).

[sigh]

- Stew

 

[ucdba]

If you log on to only one instance of the RAC database the debug session will not hang. I think the problem is that the debug session logs on to a different instance.