Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer on Linux hangs when disconnecting after VPN reconnect

Irek SloninaFeb 17 2012 — edited Feb 17 2012
Hello,

I have a problem with using connections after general link failure (Cisco VPN disconnect in my case, lost of route to Oracle DB).
When I reconnect to a VPN and I'll try to disconnect from a previously opened (before general link failure) connection, I need
to wait more than 10 minutes to complete this process. SQL Developer is completely unusable during this time.

Steps to reproduce:
1. Connect to VPN
2. Open connection in SQL Developer to host accessible only by this VPN
3. Restart VPN
4. Try to do anything with this connection (disconnect, execute sql in opened SQL Worksheet, view tables, etc.)

This bug is not new in recent versions, I'm using SQL Developer from over 2 years and this bug was always with me. But if I remember correctly in earlier versions (<3.0) I couldn't reuse the connection to execute sql (hanging SQL Developer for more than 10 minutes) but disconnecting would succeed without a problem.
Maybe SQL Developer should move connection management to separate thread to resolve this issue... or is there another solution?

I'm using SQL Developer 3.1.07.42 @ Linux 3.0.4
For VPN connectivity I use vpnc
When I restart VPN connection I'm loosing TUN interface and all routes.

I have tested this issue on a few versions of SQL Developer on Windows XP, including 3.1.07. There is no problem with disconnecting after vpn failure on Windows.

Maybe I should fill some bug report? When I can do such thing? Metalink?

Best regards,
Irek Slonina
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2012
Added on Feb 17 2012
1 comment
1,131 views