1 Reply Latest reply on Oct 2, 2013 9:14 PM by toddr

    Oracle SQL Developer Socket Read Timed Out

    toddr

      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