Oracle Express Edition software also popularly known as oracle XE is a popular free version of database from Oracle. With basic knowledge of Linux commands , one can easily install oracle-xe in maximum 10 minutes.Here we bring you a tested and verified procedure to quickly install oracle-xe , verify the installation , start-up , shutdown and uninstall procedure.
Download a copy of oracle-xe from their website. Click here to download . In our example we have downloaded the RPM package file oracle-xe-11.2.0-1.0.x86_64.rpm.zip for RHEL 6 64 bit.
- Step 1 : Unzip the RPM package
[root@shareolitelab ~]# unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
Archive: oracle-xe-11.2.0-1.0.x86_64.rpm.zip
creating: Disk1/
creating: Disk1/upgrade/
inflating: Disk1/upgrade/gen_inst.sql
creating: Disk1/response/
inflating: Disk1/response/xe.rsp
inflating: Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm
- Step 2 : Install the Oracle-XE RPM
You can edit the listener port , DB admin username , password in Disk1/response/xe.rsp file optionally
[root@shareolitelab ~]# rpm -ivh oracle-xe-11.2.0-1.0.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.
- Step 3 : Configure the Oracle-XE database parameters
[root@shareolitelab ~]# /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]:
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]:
Starting Oracle Net Listener...Done
Configuring database...
Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
That's it . Congratulations - your oracle XE setup is ready to accept DB connections.
- How to check for oracle XE process instance
Using ps command check the status of oracle instance and listener status which should display as below
[root@shareolitelab ~]# ps -ef|grep ora
oracle 1767 1 0 Feb27 ? 00:01:15 /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr LISTENER -inherit
oracle 1822 1 0 Feb27 ? 00:03:21 xe_pmon_XE
oracle 1824 1 0 Feb27 ? 00:05:37 xe_psp0_XE
oracle 1826 1 0 Feb27 ? 00:08:36 xe_vktm_XE
oracle 1830 1 0 Feb27 ? 00:00:41 xe_gen0_XE
oracle 1832 1 0 Feb27 ? 00:01:06 xe_diag_XE
oracle 1834 1 0 Feb27 ? 00:00:40 xe_dbrm_XE
oracle 1836 1 0 Feb27 ? 00:09:08 xe_dia0_XE
oracle 1838 1 0 Feb27 ? 00:00:42 xe_mman_XE
oracle 1840 1 0 Feb27 ? 00:01:13 xe_dbw0_XE
oracle 1842 1 0 Feb27 ? 00:01:13 xe_lgwr_XE
oracle 1844 1 0 Feb27 ? 00:04:45 xe_ckpt_XE
oracle 1846 1 0 Feb27 ? 00:01:05 xe_smon_XE
oracle 1848 1 0 Feb27 ? 00:00:18 xe_reco_XE
oracle 1850 1 0 Feb27 ? 00:04:25 xe_mmon_XE
oracle 1852 1 0 Feb27 ? 00:02:19 xe_mmnl_XE
oracle 1854 1 0 Feb27 ? 00:00:26 xe_d000_XE
oracle 1856 1 0 Feb27 ? 00:00:23 xe_s000_XE
oracle 1858 1 0 Feb27 ? 00:00:23 xe_s001_XE
oracle 1860 1 0 Feb27 ? 00:00:22 xe_s002_XE
oracle 1862 1 0 Feb27 ? 00:00:22 xe_s003_XE
oracle 1892 1 0 Feb27 ? 01:18:02 xe_vkrm_XE
oracle 1894 1 0 Feb27 ? 00:00:14 xe_qmnc_XE
oracle 2084 1 0 Feb27 ? 00:03:54 xe_cjq0_XE
oracle 2114 1 0 Feb27 ? 00:00:23 xe_q000_XE
oracle 2116 1 0 Feb27 ? 00:00:16 xe_q001_XE
oracle 2559 1 0 Feb27 ? 00:00:54 xe_smco_XE
oracle 29914 1 0 20:52 ? 00:00:00 xe_w000_XE
root 29937 29917 0 20:52 pts/2 00:00:00 grep ora
- How to connect to oracle XE as sysdba user
Use sqlplus command and provide the credentials as below. Remember to give the password used during installation for sysdba user.
[root@shareolitelab ~]# sqlplus sys/oracle@xe as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 27 20:54:13 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL>
- How to stop oracle XE using Linux service
Oracle provides an option to install XE as a linux service . Hence login as root user and execute below command .
[root@shareolitelab ~]# service oracle-xe stop
Shutting down Oracle Database 11g Express Edition instance.
Stopping Oracle Net Listener.
- How to start oracle XE using Linux service
[root@shareolitelab ~]# service oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.
- How to uninstall oracle XE
Check for the RPM name to remove by executing below command.
[root@shareolitelab ~]# rpm -qa |grep oracle-xe
oracle-xe-11.2.0-1.0.x86_64
Uninstall the RPM using below command.
[root@shareolitelab ~]# rpm -e oracle-xe-11.2.0-1.0.x86_64
Hope this is useful to some beginners.