Reconnect in objects window

[bbaldwin]

After a period of inactivity, I get ORA 03114 not connected to Oracle when attempting to expand a node (e.g. the list of tables) or refresh in the Objects window. (I assume the server is killing the session for inactivity.)

Is there a way to reconnect that doesn't ask for the password? (Same as when I initially start Developer: I can select a connection with a previously saved password so I don't have to type it.)

Session --> Log On asks for the pw
Session --> Set Main Connection does not resolve the issue - it still says ORA 03114 when expanding/refreshing in the Objects window.
Queries in a sql tab will execute fine, yet the Object window still has the error.

I have had this problem some time, I think it was ever since changing to Version 12, and haven't figured it out. Previously as I recall you could either execute a query in a sql tab or you could access the same login you get on application start that has the stored pw.

Version 12.0.5.1828 (32 bit)

Thanks.

 

[Marco Kalter]

Does it help if you enable the "Check Connection" option from Preferences > Oracle / Connection? In this case PL/SQL Developer will check the connection once per minute.

 

[bbaldwin]

I'll give that a try. Although if that keeps the connection alive, I suppose that's not in the spirit of what the DBA is trying to accomplish - I assume there is some max number of connections permitted and they are managing that by dropping idle connections.

Thanks.

 

[patch]

Maybe my Reconnect plugin will help? You can find it at my plugins page:https://plugins.bar-solutions.com or download directly athttp://bar-solutions.com/Reconnect-x86 orhttp://bar-solutions.com/Reconnect-x64

 

[bbaldwin]

"Check Connection" works, so I'll leave that enabled.

Thanks for the pointer on Reconnect plugin, but a 3rd-party tool isn't an option for me.