Solved

SQL Developer database connection keeps closing

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

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

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.

Question has a verified solution.

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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

773 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