Solved

SQL Developer frequently disconnecting

Posted on 2014-10-21
13
1,794 Views
Last Modified: 2014-10-23
I connect with SQL developer on my Windows 7 machine to my server Centos 6.5 running Oracle XE 11G.

I am having an issue where SQL Developer is frequently disconnecting if I don't run a query or do anything for about few minutes. I keep having to reconnect.

Is there anyway to fix this? Thanks.
0
Comment
Question by:sysautomation
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 3
13 Comments
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40395219
I don't experience this, is your CentOS virtual?

You could try this keep alive plugin: https://scristalli.github.io/SQL-Developer-4-keepalive/
0
 

Author Comment

by:sysautomation
ID: 40395226
Yes my CentOS is virtual
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40395254
The it's probably the virtual env that's causing this, do you have other connections to the same server that disconnect as well?
0
More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

 

Author Comment

by:sysautomation
ID: 40395265
Ssh doesn't disconnect. I am using Xen
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40395277
Try the plugin or enable DBMS output and set polling frequency to one minute.
0
 
LVL 35

Accepted Solution

by:
johnsone earned 500 total points
ID: 40395279
I would set the SQLNET.EXPIRE_TIME parameter in the sqlnet.ora file on the client and the server.

Documentation for the parameter is here -> http://docs.oracle.com/cd/E11882_01/network.112/e41945/profile.htm#sthref823

It can cause disconnects.
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40395296
@johnsone - Interesting, I never set that parameter, no disconnects for me. Think it's a server-only parameter btw
0
 
LVL 35

Expert Comment

by:johnsone
ID: 40395305
It has a default value which works most of the time, but it can be a cause for this.

I do believe it is a server only parameter, but it never hurts to set it on both sides.
0
 

Author Comment

by:sysautomation
ID: 40395715
There's no file sqlnet.ora in $ ORACLE_HOME/network/admin in XE.
I checked several XE servers.
0
 
LVL 35

Expert Comment

by:johnsone
ID: 40396570
No file just means you are taking all the defaults.  You can create the file and put the one line in it.
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40399357
No closing  comment, means that the expire_time setting works?
0
 

Author Comment

by:sysautomation
ID: 40399456
I did it on the server and informed the developer. I haven't received his feedback yet.
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40399748
>> I haven't received his feedback yet
Hmm, would have been nice if you closed after confirmation. If the setting doesn't work we may need to re-open this question for you ;)
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The purpose of this article is to demonstrate how we can use conditional statements using Python.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question