title: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
body: <p>I am getting the above error when trying to connect to a server database from a client using service name <code>orcl</code>. It is getting connected when I am using the other service name i.e. <code>dms</code></p>
  
  <p>Below is my <code>listener.ora</code></p>
  
  <pre><code>SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (SID_NAME = dms)
        (SERVICE_NAME = dms)
        (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
  #      (PROGRAM = extproc)
      )
    (SID_DESC =
       (SID_NAME = orcl)
       (SERVICE_NAME = dms)
      # (GLOBAL_DBANME = orcl)
        (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
     #  (PROGRAM = extproc)
    )
    )
  
  
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.53)(PORT = 1521))
  
      )
    )
  
  ADR_BASE_LISTENER = /home/oracle/app/oracle
  and tnsnames.ora
  ORCL =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.53)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
       #(SERVICE_NAME = orcl.localdomain)
        (ORACLE_SID = dms)
        (SERVICE_NAME = orcl)
      )
    )
  
  DMS =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.53)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = dms)
        (ORACLE_SID = dms)
      )
    )
  </code></pre>
  
  <p>Please tell me what to do?</p>