Debug crashs

[ianaz]

Hello,

we currently have two Oracle servers. When I debug on the main one everything's working fine. With the second the debug doesn't work and crashs always.
Does someone has any idea of what can be, some reason?

Thank you

(i am using PL/SQL 9.0.3.1641 trial version)

 

[Marco Kalter]

Can you let me know the symptoms of the crash? Any error messages?

 

[ianaz]

I don't get any error message though it stays on "Executing..." (after 5 minutes I shut the process down).
By killing the debug with SHIFT + ESC shortcut I don't solve the problem, the debug will still be in "Executing" status...

 

[Marco Kalter]

Is one of the servers an Oracle RAC server?

 

[ianaz]

Yes it is

 

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

 

[abenas]

The same thing is happening to me. I did the modifications you suggested but the aplicattion still crash after I try to break/interrupt some debug session.