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 keeps disconnecting from database on no activity

user10212457Aug 10 2018 — edited Aug 10 2018

Version 18.2.0.183

Keeps disconnecting from database. I am running SQL Developer from my desktop. Oracle client version 18c. I start SQL Developer and SQL*Plus session from my desktop. Use the same TNS entry and same Oracle client to connect to the same database as same user. I run a query: select sysdate from dual in both SQL Developer and SQL*Plus session. After half hour, I run the same query again in both SQL Developer and SQL*Plus, the SQL Developer throws a message that my session has been disconnected and all changes will be lost blah blah. The SQL*Plus session runs the query, no issues. So, everything being equal, I can easily assume that problem lies with SQL Developer. It has started happening with version 18. With previous version, 17.4, my session would stay connected for several days. The database has keep alive setup so firewall can be easily ruled out. If firewall was the issue, then why SQL*Plus session from my desktop stays connected?

Anyone else having same issue?

Thanks,

Arun

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2018
Added on Aug 10 2018
9 comments
5,229 views