?
Solved

SQL Developer database connection keeps closing

Posted on 2014-03-18
9
Medium Priority
?
3,993 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
[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
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
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 38

Expert Comment

by:Geert Gruwez
ID: 39939141
check if the firewall disconnects idle connections after 30 minutes
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 12

Expert Comment

by:Praveen Kumar Chandrashekatr
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
 

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:Praveen Kumar Chandrashekatr
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 38

Accepted Solution

by:
Gerwin Jansen, EE MVE earned 1500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
Suggested Courses

741 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