How to Install Oracle XE Database on CentOS

Once you satisfy the login requirements for Oracle’s site, you can download their “Express” Database, which from their License Agreement for that DB software, can only be run/used in the following manner:

Any use of the Oracle Database Express Edition is subject to the following limitations;
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.

1) Install and ensure Prerequisites

You also need to have twice as much RAM configured as Swap space to the CentOS system. So if you have a 1GB RAM VPS, then Oracle XE’s installer requires that you need (at least) 2GB of Swap configured to the system.

2) Download oracle-xe-11.2.0-1.0.x86_64.rpm.zip and unzip to /usr/local/src cd /usr/local/src

3) Install the .rpm

4) After the RPM is installed, you need to run /etc/init.d/oracle-xe configure, during which you need to supply the inital SYS DB User’s password.

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 to accept the defaults. Ctrl-C will abort.

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: TYPE your Passwd Confirm the password: TYPE your Passwd Again Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:
Starting Oracle Net Listener…Done
Configuring database…
Done
Starting Oracle Database 11g Express Edition instance…Done
Installation completed successfully.

5) After install, configure the Oracle environment for your relevant users on the CentOS system
First, set the required Oracle environment variables, use the oracle_env.sh the script that’s installed by the RPM to

To set these environment variables permanently for users, add the following to the .bashrc or .bash_profile of the users you want to access the environment:

6) You can use the Oracle s/ware (SQL*Plus) from the Linux command line with:

7) Enable remote access for the DB
To enable and allow remote access to the Oracle XE GUI, run the following command from SQL*Plus, connected as the SYS user:

Any customers who’d like us to install this Database software are welcome to contact us to do that for the

Post Author: Rohit

Leave a Reply

Your email address will not be published. Required fields are marked *