Sunday, May 4, 2014

Step by Step: Installing Oracle Database 11g R2 Express Edition on Oracle Enterprise Linux x86-64

Oracle Database 11g R2 Express Edition has some limitation compared to Standard and Enterprise Edition:
  1. Express Edition is limited to a single instance on any server
  2. Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server
  3. Express Edition may only be used to support up to 11GB of user data (not including Express Edition system data)
  4. Express Edition may use up to 1 GB RAM of available memory
  5. Express Edition can work only in Windows x32 and Linux x64 
Oracle Express Edition can be distributed and can be used to provide third party demonstration and training. (all the above information is taken from

Prerequisites Software:
  1. VMware Workstation (VMware Workstation Link)
  2. Oracle Enterprise Linux (Oracle Enterprise Linux Link)
  3. Oracle Database (Oracle Database Link)
In this guide the below software versions are used:
  1. VMware Workstation v10.0.0
  2. Oracle Enterprise Linux v5.7 x86-64
  3. Oracle Database Express Edition 11g R2 for Linux x86-64
Installation of VMware Workstation and OEL is not covered in this guide because it is straightforward. Just install them, start them. (Notice that during the installation of OEL you must check oracle-validated-1.1.* package in system tools)

To install Oracle Database Express Edition:
  • Log in as root user and run the executable 'oracle-xe-11.2.0-1.0.x86_64.rpm'
  • You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
  • Enter the following information:
    • Specify the HTTP port that will be used for Oracle Application Express [8080]:
    • 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:
      Confirm the password:
    • Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:
  • Installation will complete successfully and will start automatically in next reboot.
  •  This completes configuration. You can use any Oracle client to connect to Oracle instance.