Once you satisfy the login requirements for Oracle’s site, you can download their “Express” Database, which from their License Agreement for that DB sofware, 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.
We offer a number of 1GB+ RAM VPS Plans and once you’ve downloaded the Oracle Express DB distriubtion .zip file, the following describes getting it installed and running on a CentOS 5.9 64-bit VPS.
1) Install and ensure Prerequisites
yum install libaio bc flex
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.
A quick way to add Swap space is to use a “swap file” in the filesystem, commands like:
dd if=/dev/zero of=/var/swap.file count=2000000 bs=1024
chmod go= /var/swap.file
echo "/var/swap.file swap swap defaults 0 0" >> /etc/fstab
2) Download oracle-xe-11.2.0-1.0.x86_64.rpm.zip and unzip to /usr/local/src
3) Install the .rpm
rpm -ivh oracle-xe-11.2.0-1.0.x86_64.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
Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express :
Specify a port that will be used for the database listener :
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
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 /u01/app/oracle/product/11.2.0/xe/bin
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:
SQL*Plus: Release 188.8.131.52.0 Production on ....
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect sys/your-SYS-Password as sysdba
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:
SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
PL/SQL procedure successfully completed.
You should now be able to access the Oracle 11g XE Home Page GUI at:
your-VPS-IP-Address above with your IP or hostname as required.
Log in as SYSTEM using the password you supplied in the above ‘configure’ step.
You now have a running Oracle XE database installed and usable from the command-line (sqlplus) and the Web.
Any customers who’d like us to install this Database software are welcome to contact us to do that for them.