Solved

SQL Developer database connection keeps closing

Posted on 2014-03-18
9
2,103 Views
Last Modified: 2014-05-04
I use SQL Developer connected to my companies database over vpn.  It seems like a database connection must be reconnected if there is no activity in 30 minutes, it drives me crazy!  I can leave Toad for SQL Server connections open for hours without having to reconnect.

Are there any settings I can change in SQL Developer to extent the connection time?

Also I use connection type 'Basic' and do not have the Oracle Client installed on my desktop.

Thanks!
0
Comment
Question by:gantone1
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 39938236
You could turning DBMS output on and setting the polling frequency to once every minute or so.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39938252
1) Check out if the database is using resource manager and "disconnecting" you.
2) Check out if listener is disconnecting you, check SQLNET.EXPIRE_TIME in the sqlnet.ora file at the server.
0
 
LVL 36

Expert Comment

by:Geert Gruwez
ID: 39939141
check if the firewall disconnects idle connections after 30 minutes
0
 
LVL 12

Expert Comment

by:praveencpk
ID: 39942331
As MikeOM mentioned check if you any resource manager configured in which ideal timeout as set which is logging you off or the Firewall is enabled.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:gantone1
ID: 39973558
Per our IT staff I have Windows Firewall turned off and we use Mcaffee VirusScan Enterprise + AntiSpyware Enterprise 8.8.

Is there a firewall within MCaffee and if so how is that configured?
0
 
LVL 12

Expert Comment

by:praveencpk
ID: 39974688
I think McAfee may be blocking the port which you are trying to access or it would have set some timeout , can you check with your IT team the same.  

Also you can crosscheck the same by disabling the McAfee software and connecting to database.
0
 

Author Comment

by:gantone1
ID: 39992358
I disabled MCaffee and am still getting database timeout.  Maybe this is within our VPN?
0
 
LVL 37

Accepted Solution

by:
Gerwin Jansen earned 500 total points
ID: 39992799
@gantone1 - You've only replied to the firewall comments give, not the other ones. Did you try the other suggestions as well?
0
 

Author Closing Comment

by:gantone1
ID: 40041189
Could not get it to work, switched to Toad and it does much better job re-connecting so I can live with disconnect.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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 explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

707 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

14 Experts available now in Live!

Get 1:1 Help Now