title: ora-12505 error with sql developer connecting to oracle11g on windows 7
body: <p>I installed oracle 11g successfully and was able to login with SQL plus.
  When I tried making a connection with the same username and password via SQL developer however I'm getting the ora-12505 error </p>
  
  <p><img src="https://i.stack.imgur.com/04uPM.jpg" alt="error"></p>
  
  <p>Printout of my tnsname.ora:</p>
  
  <pre><code># tnsnames.ora Network Configuration File: C:\Oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
  # Generated by Oracle configuration tools.
  
  ORACLE11G =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = oracle11g)
      )
    )
  
  ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
        (SID = CLRExtProc)
        (PRESENTATION = RO)
      )
    )
  </code></pre>
  
  <p>When I execute the tnspint orcl; I get:</p>
  
  <pre><code>C:\Windows\system32&gt;tnsping ORCL;
  
  TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 22-JUL-2013 00:52:10
  
  Copyright (c) 1997, 2010, Oracle.  All rights reserved.
  
  Used parameter files:
  C:\Oracle11g\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
  
  TNS-03505: Failed to resolve name
  
  C:\Windows\system32&gt;
  </code></pre>
  
  <p>Could anyone assist in solving this problem and getting sql developer connected with my oracle database?</p>