title: SQL Developer connection issue
body: <p>Can anyone to help me resolve the issue with Oracle connection from <strong><em>SQL Oracle Developer</em></strong>. I've installed <strong><em>jdk 1.6.0_45</em></strong>, <strong><em>Oracle 11g</em></strong>, and can correct connect to The Oracle db using <strong><em>sqlplus</em></strong> with sqldba credentials, but when I am trying to connect to this db using sql developer I get an error "Listener doe not currently know of SID given in connect descriptor". I try to change  "<code>SERVICE_NAME</code>" to "<code>SERVICE_NAME as SYSDBA</code>" and some anather stuff  but it does not help. How to make <strong><em>sql developer</em></strong> connect to theserver?? Here is tnsname.ora file, img with connection setting and init.ora file and <strong><em>cmd</em></strong> prompt for connectiong from <strong><em>sqlplus</em></strong></p>
  
  <p><strong><em>Mary Christmas to everyone ;-)</em></strong></p>
  
  <pre><code># tnsnames.ora Network Configuration File: C:\app\Andriy\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
  # Generated by Oracle configuration tools.
  
  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 as SYSDBA = orcl.adobe.com)
      )
    )
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/khBrT.png" alt="enter image description here"></p>
  
  <pre><code># 
  # $Header: rdbms/admin/init.ora /main/23 2009/05/15 13:35:38 ysarig Exp $ 
  # 
  # Copyright (c) 1991, 1997, 1998 by Oracle Corporation
  # NAME
  #   init.ora
  # FUNCTION
  # NOTES
  # MODIFIED
  #     ysarig     05/14/09  - Updating compatible to 11.2
  #     ysarig     08/13/07  - Fixing the sample for 11g
  #     atsukerm   08/06/98 -  fix for 8.1.
  #     hpiao      06/05/97 -  fix for 803
  #     glavash    05/12/97 -  add oracle_trace_enable comment
  #     hpiao      04/22/97 -  remove ifile=, events=, etc.
  #     alingelb   09/19/94 -  remove vms-specific stuff
  #     dpawson    07/07/93 -  add more comments regarded archive start
  #     maporter   10/29/92 -  Add vms_sga_use_gblpagfile=TRUE 
  #     jloaiza    03/07/92 -  change ALPHA to BETA 
  #     danderso   02/26/92 -  change db_block_cache_protect to _db_block_cache_p
  #     ghallmar   02/03/92 -  db_directory -&gt; db_domain 
  #     maporter   01/12/92 -  merge changes from branch 1.8.308.1 
  #     maporter   12/21/91 -  bug 76493: Add control_files parameter 
  #     wbridge    12/03/91 -  use of %c in archive format is discouraged 
  #     ghallmar   12/02/91 -  add global_names=true, db_directory=us.acme.com 
  #     thayes     11/27/91 -  Change default for cache_clone 
  #     jloaiza    08/13/91 -         merge changes from branch 1.7.100.1 
  #     jloaiza    07/31/91 -         add debug stuff 
  #     rlim       04/29/91 -         removal of char_is_varchar2 
  #   Bridge     03/12/91 - log_allocation no longer exists
  #   Wijaya     02/05/91 - remove obsolete parameters
  #
  ##############################################################################
  # Example INIT.ORA file
  #
  # This file is provided by Oracle Corporation to help you start by providing
  # a starting point to customize your RDBMS installation for your site. 
  # 
  # NOTE: The values that are used in this file are only intended to be used
  # as a starting point. You may want to adjust/tune those values to your
  # specific hardware and needs. You may also consider using Database
  # Configuration Assistant tool (DBCA) to create INIT file and to size your
  # initial set of tablespaces based on the user input.
  ###############################################################################
  
  # Change '&lt;ORACLE_BASE&gt;' to point to the oracle base (the one you specify at
  # install time)
  
  db_name='ORCL'
  memory_target=1G
  processes = 150
  audit_file_dest='&lt;ORACLE_BASE&gt;/admin/orcl/adump'
  audit_trail ='db'
  db_block_size=8192
  db_domain=''
  db_recovery_file_dest='&lt;ORACLE_BASE&gt;/flash_recovery_area'
  db_recovery_file_dest_size=2G
  diagnostic_dest='&lt;ORACLE_BASE&gt;'
  dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
  open_cursors=300 
  remote_login_passwordfile='EXCLUSIVE'
  undo_tablespace='UNDOTBS1'
  # You may want to ensure that control files are created on separate physical
  # devices
  control_files = (ora_control1, ora_control2)
  compatible ='11.2.0'
  </code></pre>
  
  <hr>
  
  <pre><code>C:\&gt;sqlplus
  
  SQL*Plus: Release 11.2.0.1.0 Production on ┬Є. ├Ёє 24 16:26:28 2013
  
  Copyright (c) 1982, 2010, Oracle.  All rights reserved.
  
  Enter user-name: sys as sysdba
  Enter password:
  
  Connected to:
  Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
  With the Partitioning, OLAP, Data Mining and Real Application Testing options
  
  SQL&gt;
  </code></pre>
  
  <hr>
  
  <pre><code>C:\&gt;lsnrctl status
  
  LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-├╨╙-2013 17:00:25
  
  Copyright (c) 1991, 2010, Oracle.  All rights reserved.
  
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  STATUS of the LISTENER
  ------------------------
  Alias                     LISTENER
  Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
  Start Date                24-├╨╙-2013 09:24:44
  Uptime                    0 days 7 hr. 35 min. 43 sec
  Trace Level               off
  Security                  ON: Local OS Authentication
  SNMP                      OFF
  Listener Parameter File   C:\app\Andriy\product\11.2.0\dbhome_1\network\admin\listener.ora
  Listener Log File         c:\app\andriy\diag\tnslsnr\andriypc\listener\alert\log.xml
  Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  Services Summary...
  Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
  The command completed successfully
  </code></pre>