I can connect successfully to my Oracle 11gR2 database (running on Windows Server 2008 R2) from SQL Developer 3.2.2, 64-bit just downloaded on Windows 7. However, when I try to execute a script to create or replace package body (the package body is a little over 500 lines), I get the message:
IO Error: Socket Read Timed Out
I modified the SQLNET.ORA on the server and added the line
SQLNET.INBOUND_CONNECT_TIMEOUT = 180
and reloaded the listener. None of this changed anything. I also looked at the alert log and so no related messages. I don't know if it's related, but if I do a simple SELECT table_name FROM user_tables for the login, SQL Developer hangs (the user owns 575 tables). Any ideas?
I found this link:
Apparently, you can't use a simple hostname in the connection string -- you have to put a fully-qualified one. As soon as I did that, it ran fine. Go figure.