PL/SQL Developer Crashes on ORA-02396

[Greg Puckett]

I come across this multiple times a day with my database and PL/SQL Developer. I have several oracle linked servers configured without the option for streaming. I am also unable to change the maximum idle time setting on the culprit linked database.

The issue arises when I run a query that references a DB link. If I have not pegged this linked oracle server frequently enough the remote server will log my account out. Then when I execute the query it attempts to query from the db link and throws this error:
ORA-02396: exceeded maximum idle time, please connect again
ORA-02063: preceding line from [db link name]

PL/SQL Developer then becomes unresponsive. I have tried waiting this out for several hours (while I went to lunch) and the program never recovers. I am forced to manually kill the process for PL/SQL Developer and relaunch the program.

Any help is greatly appreciated!!

PL/SQL Developer Version 9.0.5.1652
Oracle Client 11.2.0.2.0 32bit
Oracle Server 11.2.0.2
DB Linked Oracle Server 10.2.0.4.0

 

[Marco Kalter]

It is odd that PL/SQL Developer becomes unresponsive. It is after all a runtime error like any other. 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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).