Solved

SQL Developer frequently disconnecting

Posted on 2014-10-21
13
1,036 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
  • 6
  • 4
  • 3
13 Comments
 
LVL 37

Expert Comment

by:Gerwin Jansen
Comment Utility
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
Comment Utility
Yes my CentOS is virtual
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
Comment Utility
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
 

Author Comment

by:sysautomation
Comment Utility
Ssh doesn't disconnect. I am using Xen
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
Comment Utility
Try the plugin or enable DBMS output and set polling frequency to one minute.
0
 
LVL 34

Accepted Solution

by:
johnsone earned 500 total points
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 37

Expert Comment

by:Gerwin Jansen
Comment Utility
@johnsone - Interesting, I never set that parameter, no disconnects for me. Think it's a server-only parameter btw
0
 
LVL 34

Expert Comment

by:johnsone
Comment Utility
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
Comment Utility
There's no file sqlnet.ora in $ ORACLE_HOME/network/admin in XE.
I checked several XE servers.
0
 
LVL 34

Expert Comment

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

Expert Comment

by:Gerwin Jansen
Comment Utility
No closing  comment, means that the expire_time setting works?
0
 

Author Comment

by:sysautomation
Comment Utility
I did it on the server and informed the developer. I haven't received his feedback yet.
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
Comment Utility
>> 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now