Patrick-Dussault

Fast Tracks to install Oracle Express Database 11.2 64bit on Linux

Blog Post created by Patrick-Dussault Employee on Mar 24, 2017

# unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
# rpm -Uvh Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm
#

 

oracle install

 

# /etc/init.d/oracle-xe configure
# Specify the HTTP port that will be used for Oracle Application Express [8080]: 8181
# Specify a port that will be used for the database listener [1521]:
# Specify a password to be used for database accounts.  Note that the same
  password will be used for SYS and SYSTEM.  Oracle recommends the use of
  different passwords for each database account.  This can be done after
  initial configuration:password
  Confirm the password:password
# Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y

 

  Starting Oracle Net Listener...Done
  Configuring database...Done
  Starting Oracle Database 11g Express Edition instance...Done
  Installation completed successfully.

 

# source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
# sqlplus system

 

  SQL*Plus: Release 11.2.0.2.0 Production on Wed Mar 15 04:42:55 2017

 

  Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

  Enter password: password

 

  Connected to:
  Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

 

  SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

 

  PL/SQL procedure successfully completed.

 

  SQL>

 

NOTES to create tablespace :
-----

 

SELECT TABLESPACE_NAME, FILE_NAME FROM DBA_DATA_FILES ORDER BY TABLESPACE_NAME;
CREATE SMALLFILE TABLESPACE "PSTORE" DATAFILE 'C:\APP\ORACLE\ORADATA\PSTORE\DATAFILE\my_data01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 8G LOGGING DEFAULT NOCOMPRESS ONLINE EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
alter user SMUSER  default tablespace PSTORE temporary tablespace temp;
grant connect, resource to SMUSER;

Outcomes