Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle SQL Developer Socket Read Timed Out

toddrOct 2 2013 — edited Oct 2 2013

Hi,

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?

Thanks,

Todd Reilly

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2013
Added on Oct 2 2013
1 comment
5,709 views