title: Cannot connect to oracle database with SID
body: <p>I am completely new with oracle db set up. That's why I've downloaded and run following oracle <a href="https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html" rel="nofollow noreferrer">VM</a>. For my project specific purposes I did few steps to have table space and user/scheme with appropriate permissions like this: </p>
  
  <ol>
  <li>create tablespace MYTABLESPACE datafile 'linux/path/MYTABLESPACE.DBF' size 4096m autoextend on next 512m maxsize 8192m;</li>
  <li>create user MYUSER identified by MYUSER default tablespace MYTABLESPACE;</li>
  <li>grant connect, resource, unlimited tablespace, select any dictionary to MYUSER;</li>
  </ol>
  
  <p>There are default configurations files which are stored within ${ORACLE_HOME}/network/admin</p>
  
  <p><strong>listener.ora</strong></p>
  
  <pre><code>SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (GLOBAL_DBNAME = orclcdb)
        (SID_NAME = orclcdb)
        (ORACLE_HOME = /u01/app/oracle/product/version/db_1)
      )
    )
  
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
      )
    )
  
  #HOSTNAME by pluggable not working rstriction or configuration error.
  DEFAULT_SERVICE_LISTENER = (orclcdb)
  </code></pre>
  
  <p><strong>tnsnames.ora</strong></p>
  
  <pre><code>ORCLCDB=localhost:1521/orclcdb ORCL=  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = orcl)
      )   )
  </code></pre>
  
  <p>With configurations mentioned above I am unable to connect with newly created user using SID, please see table below</p>
  
  <p><a href="https://i.stack.imgur.com/KNeRK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KNeRK.png" alt="password"></a> </p>
  
  <p>Following error is received in such case:</p>
  
  <p><strong>[72000][1017] ORA-01017: invalid username/password; logon denied</strong></p>
  
  <p>Can someone please clarify what is missed in configuration because SID connection is requirement for legacy application? </p>