Oracle Database 11g Express Edition (11.2) Beta

In this article we will learn how to install 11g Express edition 11.2 Beta on linux x86_64 bit.

Limitations:

1.If Oracle Database XE is installed on a computer with more than one CPU (including dual-core CPUs), then it will consume, at most, processing resources equivalent to one CPU

2.Only one installation of Oracle Database XE can be performed on a single computer

3.The maximum amount of user data in an Oracle Database XE database cannot exceed 11 gigabytes

4.The maximum amount of RAM that an Oracle Database XE database uses cannot exceed 1 gigabyte, even if more is available

Oracle Database XE is a great starter database for:

• Developers working on PHP, Java, .NET, XML, and Open Source applications
• DBAs who need a free, starter database for training and deployment
• Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
• Educational institutions and students who need a free database for their curriculum

Installing Oracle Database XE:

Log on to your computer with root permissions.

[root@oraexpress u01]# id
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm)

Run the Oracle Database XE executable oracle-xe-11.2.0-0.5.x86_64.rpm to install Oracle Database XE.

[root@oraexpress u01]# rpm -ivh oracle-xe-11.2.0-0.5.x86_64.rpm
Preparing...                ########################################### [100%]
   1:oracle-xe              ########################################### [100%]
Executing post-install steps...

You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
[root@oraexpress u01]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:8080

Specify a port that will be used for the database listener [1521]: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 can't be null. Enter password:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:n

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

$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
$ export ORACLE_SID=XE
$ cd /u01/app/oracle/product/11.2.0/xe/bin
$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Beta on Sun Apr 3 12:36:57 2011

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


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

SQL>