Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does the "IO Error: Socket read timed out" means (SQL developer)

When I try to open SQL developer then I am getting this error:

An error was encountered performing the requested operation:
IO Error: Socket read timed out
The Network Adapter could not establish the connection Vendor code 17002

What is the problem?

like image 446
Isaac Motaung Avatar asked Oct 13 '14 06:10

Isaac Motaung


People also ask

Why does socket read timed out?

From the client side, the “read timed out” error happens if the server is taking longer to respond and send information. This could be due to a slow internet connection, or the host could be offline. From the server side, it happens when the server takes a long time to read data compared to the preset timeout.

What is IO error in SQL Developer?

This error usually means that one of host, port, sid/service is wrong, or there is a network issue. What is the hostname or IP address of the server where the database is running?

How do I stop connection timeout in SQL Developer?

Oracle Net can be configured with Dead Connection Detection (SQLNET. EXPIRE_TIME) to workaround this problem. Set EXPIRE_TIME on the database server to a value less than the firewall connection timeout so that DCD keeps the connection to the database alive.


2 Answers

Typical causes for that error:

  1. Your database listener is not running
  2. It is running, but maybe there is a firewall intervening
  3. It is running, no firewall issue, but you have provided incorrect connection details.

Source: https://community.oracle.com/thread/3519434

like image 177
Juan Avatar answered Nov 02 '22 00:11

Juan


Make sure your installation is on a LOCAL drive!

If your SQL Developer is launched from a network location (specifically, a different location than your database network location), that could be the issue.

I was having the same problem and I moved my installation to my local drive and it connected right away :)

like image 24
elektrykalAJ Avatar answered Nov 02 '22 01:11

elektrykalAJ