Oracle XE 11g XE Database Not Found

Question

I am a new one who started using Oracle Database and encountered a problem while installing the latest Oracle XE 11gx64 on Microsoft Windows 7 x64 Enterprise.

There were no errors during the installation, and Windows services ( OracleXETNSListenerand OracleServiceXE) were successfully created and started .

However, when I try to get a list of available databases, I get an error

ORA-01034: ORACLE not available

For some reason, the XE base was not created in %ORACLE_BASE%\oradata\XE.

The contents of my listener.ora with localhost:

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)

I installed tnsnames.ora by setting the localhost IP:

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) 
    ) 
  ) 

sqlnet.ora contains both services:

SQLNET.AUTHENTICATION_SERVICES = (NONE;NTS)

The log file from "% ORACLE_HOME% \ server \ log \ myhost \ client" contains this error:

Oracle Database 11g Clusterware Release 11.2.0.2.0 - Copyright 1996, 2010 Oracle. . 2016-01-20 19: 51: 43.920: [default] [5096] ut_read_reg: 2: ocr \Oracle\olr . 2 [
CLSE] [5096] clse_get_crs_home: OLR [0] olr. . ]

, , ?

Answer 1

, XE source. , , .

• Oracle XE 11gR2 Oracle c:\oraclexe admin. , ( pwd) .

• cmd . , :

  set ORACLE_SID=XE
  set ORACLE_BASE=c:\oraclexe\app\oracle 
  set ORACLE_HOME=c:\oraclexe\app\oracle\product\11.2.0\server
  

• XE :

  oradim -delete -sid XE
  

• PWDXE.ORA file:

  del %ORACLE_HOME%\database\PWDXE.ORA
  

• init.ora %ORACLE_HOME%\config\scripts %ORACLE_HOME%\database , initXE.ora :

  open_cursors=300
  db_name=XE
  control_files=("C:\oraclexe\app\oracle\oradata\XE\control.dbf")
  job_queue_processes=4
  compatible=11.2.0.0.0
  diagnostic_dest=C:\oraclexe\app\oracle\.
  memory_target=1G
  sessions=100
  audit_file_dest=C:\oraclexe\app\oracle\admin\XE\adump
  remote_login_passwordfile=EXCLUSIVE
  dispatchers="(PROTOCOL=TCP) (SERVICE=XEXDB)"
  shared_servers=4
  undo_management=AUTO
  undo_tablespace=UNDOTBS1
  DB_RECOVERY_FILE_DEST_SIZE = 10G
  DB_RECOVERY_FILE_DEST=C:\oraclexe\app\oracle\fast_recovery_area
  #optional
  nls_language="RUSSIAN"
  nls_territory="RUSSIA"
  

• cmd Oracle %ORACLE_HOME%\database\PWDXE.ORA:

  oradim -new -sid %ORACLE_SID% -intpwd admin -startmode auto -srvcstart system
  

• , Windows Oracle XE, XE:

  sqlplus /nolog
  connect sys/admin as sysdba;
  shutdown immediate;
  exit;
  del %ORACLE_BASE%\oradata\XE\CONTROL.DBF
  del %ORACLE_BASE%\fast_recovery_area\XE\ONLINELOG\*.LOG
  

• :

createXE.cmd

set ORACLE_SID=XE
set NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251
set ORACLE_BASE=C:\oraclexe\app\oracle
sqlplus /nolog @createXE.sql

createXE.sql

spool %ORACLE_BASE%\admin\XE\CreateXE.log;
connect sys/admin as sysdba;
startup nomount;
CREATE DATABASE XE
LOGFILE GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
CHARACTER SET CL8MSWIN1251
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'c:\oraclexe\app\oracle\oradata\XE\system.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'c:\oraclexe\app\oracle\oradata\XE\sysaux.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'c:\oraclexe\app\oracle\oradata\XE\temp.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE 'c:\oraclexe\app\oracle\oradata\XE\undotbs1.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
CREATE SMALLFILE TABLESPACE USERS DATAFILE 'c:\oraclexe\app\oracle\oradata\XE\users.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;
-- catalog
@%ORACLE_HOME%\rdbms\admin\catalog.sql;
@%ORACLE_HOME%\rdbms\admin\catblock.sql;
@%ORACLE_HOME%\rdbms\admin\catproc.sql;
@%ORACLE_HOME%\rdbms\admin\catoctk.sql;
connect system/manager
-- sqlplus profile
@%ORACLE_HOME%\sqlplus\admin\pupbld.sql;
@%ORACLE_HOME%\sqlplus\admin\help\hlpbld.sql helpus.sql;
connect sys/admin as sysdba;
-- xdb protocol
@%ORACLE_HOME%\rdbms\admin\catqm.sql change_on_install SYSAUX TEMP NO;
@%ORACLE_HOME%\rdbms\admin\catxdbj.sql;
@%ORACLE_HOME%\rdbms\admin\catrul.sql;
-- compiling invalid objects
@%ORACLE_HOME%\rdbms\admin\utlrp.sql;
spool off;
exit;

9. createdXE.cmd .

10. .