title: SQL Developer does not connect with SID as defined in tnsnames.ora
body: <p>My tnsnames.ora looks like this:</p>
  
  <pre><code>ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
        (SID = CLRExtProc)
        (PRESENTATION = RO)
      )
    )
  ORCL =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = orcl)
      )
    )**
  </code></pre>
  
  <p>But when I try connecting using SQL Developer as follows I get the error: No more data to read from socket.</p>
  
  <p>Role: SYSDBA
  ConnectionType: Basic</p>
  
  <p>HostName: localhost
  Port: 1521
  SID: CLRExtProc</p>
  
  <p>Can you please let me know what I am doing wrong? I can connect using the service_name, or when using service name in SID, but why does it not work when I use the SID defined in tnsnames.ora.</p>
  
  <p>As per my understanding, the SID corresponds to the instance name for the database. Is it not possible to connect using it?</p>
  
  <p>Best Regards,
  Harshit</p>