New RAC Configuration - test/debug lockup

[Dave Sharpe]

We ( multiple client PCs ) are experiencing hard lockups (at least usually "Task Manager" needs to be called to terminate developer) when testing Procedures. It happens only on our new soon to go into production RAC configuration. Our DBA speculates that the main session and test session might be going to different boxes causing this "reaction" by developer.

I noted no discussion on this in the forum. Is this something that you've heard of elseware ?
Any more info I can provide (I've included "Oracle information" available via the help button) ? Can you provide any guidance ?

Thanks

Dave

=====================================

We are somewhat up to date in the Oracle side

PL/SQL Developer
Version 7.0.3.1123 (MBCS)
01.0893 - Unlimited user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 1,038,404 kB (452,500 available)
Paging file : 2,496,132 kB (2,045,004 available)
Virtual memory : 2,097,024 kB (2,010,912 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
userid=vista/xxxxxx@888888 - actual data removed

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\pd6s6k2\default.ini

Plug-Ins
*Favorites v1.3 (C:\Program Files\PLSQL Developer\PlugIns\Favorites.dll)
(* is Active)

Homes
OraClient10g_home1 (D:\oracle\product\10.2.0\client_1)

DLLs
D:\oracle\product\10.2.0\client_1\bin\oci.dll

TNS File
D:\oracle\product\10.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: D:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.7.0
Character size: 1 byte(s)

 

[Marco Kalter]

Can you go to Tools > Preferences > Debugger, disable the "Update call stack after each step" option, and try again?

 

[Dave Sharpe]

Marco

In initial tests it sure "Seems to have done it" for me.

I'll follow up after more testing.

Thanks for the prompt reply.

Dave

 

[Dave Sharpe]

Marco

I was incorrect, we still have a problem.

We can start a test and "Run" it no problem.

But if we can start a test and click on
the "Start Debugger" icon, it (The "Start
Debugger" icon) grays out but the other
icons there ("Run" etc) don't become available.
The bottom of the screen switches in to show
Variable, Value and Call Stack mode.

It seems to act the same regardless of the
"Session Mode" (dual or multiple) selected.

If we try to close and click on the "Terminate"
button it usually does nothing. If it does
"appear to work" trying to procede in developer
gets us the MSWindow message "Program is not responding".

I hope that this helps.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Dave Sharpe]

Marco

Mt DBA swears he did nothing, but I can't get it to fail now.

I'll keep the reply handy should it reappear.

Thanks as always

Dave

 

[Dave Sharpe]

Marco

the problem has returned ( or maybe I just found it again ).

I have emailed the debug.txt to you. The subject should be "New RAC Configuration - test/debug lockup (debug.txt)"

Thanks as always
Dave

 

[Dave Sharpe]

marco

I've upgraded to 7.1 and experience the problem with it also. Do you need a the debug log for it also or is the one that I sent okay ?

thanks
Dave

 

[Dave Sharpe]

Marco

May I please have a status update.

Currently this does not effect our production environment; but rac-ing it is scheduled to occur soon. Without resolution may require us rescheduling it ( big pain ).

 

[Dave Sharpe]

Marco

While GOOGLING this problem I found an internet posting that states "because Oracle does not support Debugging across RAC instances." (on http://asktoad.com/DWiki/doku.php/faq/answers/procedure_editor)

As anyone can say anything on the net can you confirm or deny the correctness of the statement.

Thanks

Dave

 

[Dave Sharpe]

Marco

We were able create TnsNames entries that "bypass" the Rac (simular to the methodolgy shown in the previous post) and it seems to have given us a viable work around.

If interested I can send the actual TnsNames entries we used.

Dave

 

[Gustavo]

Dave,

I still have this issue and the debugger has been rendered almost useless thanks to it, so I'm pretty interested in whatever sort of change you made.

Best regards,
Gustavo