Solved

SQL Developer frequently disconnecting

Posted on 2014-10-21
13
1,230 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
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 37

Expert Comment

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

Author Comment

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

Expert Comment

by:Gerwin Jansen
ID: 40395277
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
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 40395296
@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
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 34

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 37

Expert Comment

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

Expert Comment

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to connect SQL Server from my Oracle database? 11 73
Get the parent node - XMLTYPE 9 56
Centos 7 User to Start Apache, MariaDB, LDAP 5 30
Oracle SQL 6 48
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to recover a database from a user managed backup

867 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

21 Experts available now in Live!

Get 1:1 Help Now