11g issues.

[jrow]

While trying to edit a procedure or package that uses any sys packages, e.g. dbms_output, dbms_application_info, using autocomplete locks the process. The only way out is to kill plsql developer.

PLSQL Dev will also seemingly randomly lock up while browsing sessions. I haven't been able to determine a pattern on this one, yet.

 

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

 

[jrow]

I sent the debug files, where you able to get anything from them?

Thanks

 

[Marco Kalter]

I don't think I have them. Can you send them again?

 

[jrow]

I sent 2 e-mails with accompanying debug files.

 

[jrow]

More information:

Our database is an 11g RAC running on Red Hat 5.1. Over a Cisco (v5.0.01.xxx) VPN connection. Yeah, the bleeding edge!

What appears to be happening is the window that tries to run the query (and this can be a simple SQL window or CMD window) loses or never makes the connection to the database. The remaining windows are unaffected.

SQLPLUS running over the same VPN connection does not have a problem running the same queries or remaining connected.

JR

 

[jrow]

FYI:

Our problem turned out to be an issue with Cisco VPN ver 5.0.01. Our network admin disabled the 'sql inspection' option and the issues went away. Interestingly, we access another 11g database using the same version of VPN with 'sql inspection' enabled without any problems.

This issue also affected TOAD and SQL Developer.

JR