Solved

SQL Developer database connection keeps closing

Posted on 2014-03-18
9
2,887 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 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 37

Expert Comment

by:Geert Gruwez
ID: 39939141
check if the firewall disconnects idle connections after 30 minutes
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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
 

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 38

Accepted Solution

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying 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

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

820 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