Main menu

Installing and configuring Oracle 11g XE in RHEL or CentOS

In this article we will installing and configuring Oracle 11g Express Edition (XE) on CentOS or RHEL.

Installation instrruction is straight forward.
1. installting prerequisite
2. Installing Oracle Express 11g
3. Configuring Oracle Express 11g

Installing essential packages for Oracle XE installation
[root@vps19 data]# yum install libaio bc flex unzip

Download your oracle XE from oracle website here.
 [root@vps19 data]# 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

Installing Oracle XE

[root@vps19 Disk1]# 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.

Executing configuration script

[root@vps19 Disk1]# /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 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]:y
Starting Oracle Net Listener...Done
 Configuring database...Done
 Starting Oracle Database 11g Express Edition instance...Done
 Installation completed successfully.

Setting environment path

[root@vps19 home]# cd /u01/app/oracle/product/11.2.0/xe/bin
 [root@vps19 bin]# ./oracle_env.sh
 [root@vps19 bin]# cat oracle_env.sh
 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
 export ORACLE_SID=XE
 export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
 export PATH=$ORACLE_HOME/bin:$PATH

Add this environemnt varibale into your .bashrc or .bash_profile or /etc/profile

[root@vps19 bin]# vi /etc/profile
[root@vps19 bin]# source /etc/profile

Login into your Oracle XE and enabling the remote access

[root@vps19 bin]# sqlplus /nolog

SQL> connect sys/YourPassword as sysdba

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

PL/SQL procedure successfully completed.

FacebookTwitterGoogle+RSS