title: Oracle XE 11g the XE database was not found
body: <p>I am a new one who started to use Oracle Database and faced the problem during installation the last verstion of <code>Oracle XE 11g</code> x64 to the Microsoft Windows 7 x64 Enterprise. </p>
  
  <p>During installation were not any errors and Windows Services (<code>OracleXETNSListener</code> and <code>OracleServiceXE</code>) were successfully created and started. 
  <a href="https://i.stack.imgur.com/QjReN.png" rel="noreferrer"><img src="https://i.stack.imgur.com/QjReN.png" alt="Winservices screen"></a></p>
  
  <p>However, when I try to get the list of available databases I receive an error </p>
  
  <blockquote>
    <p>ORA-01034: ORACLE not available</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/GDHz3.png" rel="noreferrer"><img src="https://i.stack.imgur.com/GDHz3.png" alt="ORA-01034: ORACLE not available"></a></p>
  
  <p>For some reason the <strong>XE database was not created</strong> into <code>%ORACLE_BASE%\oradata\XE</code>. 
  <a href="https://i.stack.imgur.com/Otqds.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Otqds.png" alt="enter image description here"></a></p>
  
  <p>The content of my listener.ora with localhost:</p>
  
  <pre><code>SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (SID_NAME = PLSExtProc)
        (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
        (PROGRAM = extproc)
      )
      (SID_DESC =
        (SID_NAME = CLRExtProc)
        (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
        (PROGRAM = extproc)
      )
    )
  
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      )
    )
  
  DEFAULT_SERVICE_LISTENER = (XE)
  </code></pre>
  
  <p>I fixed tnsnames.ora by setting localhost IP address:</p>
  
  <pre><code>XE =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = XE)
      )
    )
  
  EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
        (SID = PLSExtProc)
        (PRESENTATION = RO)
      )
    )
  
  ORACLR_CONNECTION_DATA = 
    (DESCRIPTION = 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      ) 
      (CONNECT_DATA = 
        (SID = CLRExtProc) 
        (PRESENTATION = RO) 
      ) 
    ) 
  </code></pre>
  
  <p>sqlnet.ora contains both services:</p>
  
  <pre><code>SQLNET.AUTHENTICATION_SERVICES = (NONE;NTS)
  </code></pre>
  
  <p>The log file from '%ORACLE_HOME%\server\log\myhost\client' contains this error:</p>
  
  <blockquote>
    <p>Oracle Database 11g Clusterware Release 11.2.0.2.0 - Production
    Copyright 1996, 2010 Oracle. All rights reserved. 2016-01-20
    19:51:43.920: [ default][5096]ut_read_reg:2:ocr registry key
    SOFTWARE\Oracle\olr cannot be opened. error 2 [<br>
    CLSE][5096]clse_get_crs_home: Error retrieving OLR configuration [0]
    [Error opening olr registry key. Не удается найти указанный файл. ]</p>
  </blockquote>
  
  <p>How can I find what goes wrong and fix the problem?</p>