debugging in ASM configured DB

[stef]

Hi,

I have problems debugging a package on our production server.
This is a ASM server, on the normal server I don't get the same problem,

Can someone explain what could be the problem.
The debugger session is hanging after a second time of debugging, and this is now happening all the time. I already created a debug package which I use to compile.

Insert debug information solve the problem.
But why I have to do this every time after one debugging proces.

Using PLSQL 8.0.4.1514
Oracle 11,2,0,1,0
Client 11,1

Also happening on Ora 10

 

[Marco Kalter]

I don't think ASM has any effect on the debugger. Are there any other differences between the normal server and the production server?

 

[stef]

Hello,

the difference is that the ASM is a cluster..and the test not.
Can this cause any problem?

Else please tell me what you else need, I always have to kill the program by task manager.
It is even not be possible to cancel.

 

[stef]

Marco,

Any news for me?

thx

 

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

 

[stef]

Thx Marco I will try this