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?
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.
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?
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.
Typical causes for that error:
Source: https://community.oracle.com/thread/3519434
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 :)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With