title: ORA-12505. TNS: listener dos not currently know of SID given in connect descriptor
body: <p>I cannot connect to Oracle database from SQL plus. This is the error message that I get:</p>
  
  <pre><code>Status: Failure -Test failed: Listener refused the connection with the following error: ORA-12505. TNS: listener dos not currently know of SID given in connect descriptor
  </code></pre>
  
  <p>This is the configuration of <strong><em>listener.ora:</em></strong></p>
  
  <pre><code># listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
  # Generated by Oracle configuration tools.
  
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.104)(PORT = 1521))
      )
    )
  
  ADR_BASE_LISTENER = /u01/app/oracle
  </code></pre>
  
  <p><em><strong>sqlnet.ora:</em></strong></p>
  
  <pre><code># sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
  # Generated by Oracle configuration tools.
  
  NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
  
  ADR_BASE = /u01/app/oracle
  </code></pre>
  
  <p><em><strong>tnsnames.ora:</em></strong></p>
  
  <pre><code># tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
  # Generated by Oracle configuration tools.
  
  ORACLE =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.104)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = oracle)
      )
    )
  </code></pre>
  
  <p>How I can solve the problem?</p>
  
  <p><em><strong>P.S</em></strong>
  This is the output of the command lsnrctl status </p>
  
  <pre><code>[oracle@localhost bin]$ ./lsnrctl status
  
  LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-JAN-2013 14:38:00
  
  Copyright (c) 1991, 2009, Oracle.  All rights reserved.
  
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  STATUS of the LISTENER
  ------------------------
  Alias                     LISTENER
  Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  Start Date                08-JAN-2013 14:37:06
  Uptime                    0 days 0 hr. 0 min. 54 sec
  Trace Level               off
  Security                  ON: Local OS Authentication
  SNMP                      OFF
  Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
  Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
  Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=1521)))
  The listener supports no services
  The command completed successfully
  [oracle@localhost bin]$ 
  </code></pre>