Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)

Before we begin installing Oracle Database XE in Linux, we need to prepare
the environment by installing the required packages, setting kernel parameters,
and so on.
———–Installing and Uninstalling Oracle Database XE————-

To begin, make sure that the following Linux packages are installed. To verify that the
following Linux packages are installed use the rpm –qa <package name> command:
• kernel-headers-2.6.18-194.el5.x86_64.rpm
• glibc-2.5-49.x86_64.rpm
• make-3.81-3.el5.x86_64.rpm
• binutils-2.17.50.0.6-14.el5.x86_64.rpm
• glibc-devel-2.5-49.x86_64.rpm
• glibc-headers-2.5-49.x86_64.rpm
• libgomp-4.4.0-6.el5.x86_64.rpm
• gcc-4.1.2-48.el5.x86_64.rpm
• libaio-0.3.106-5.x86_64.rpm
The parameters that need to be included in the sysctl.conf file under /etc are as
follows. These changes are to be made by logging in as the root user:
kernel.semmsl=250
kernel.semmns=32000
kernel.semopm=100
kernel.semmni=128
kernel.shmmax=4294967295
kernel.shmmni=4096
kernel.shmall=2097152
kernel.sem= 250 32000 100 128
fs.file-max= 6815744
net.ipv4.ip_local_port_range=9000 65500
We are now ready to start the Oracle Database XE installation. However, it is
recommended to complete the following steps for creating a Linux user oracle:
1. Create new groups and the oracle user as shown in the following code
snippet, by logging in as the root user:
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle
2. Log in as the oracle user and add the following lines at the end of the
.bash_profile file:
# Oracle instance name
ORACLE_SID=XE; export ORACLE_SID;
# Oracle home directory
ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe; export ORACLE_HOME;
# Search path for executable

PATH=$ORACLE_HOME/bin:$PATH; export PATH;
# Search path for shared libraries
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_
LIBRARY_PATH
3. Copy the downloaded software to a temporary folder, say /u01/software,
and run the following command as the root user to install Oracle Database
XE, as shown in the following screenshot:
4. Run /etc/init.d/oracle-xe configure as the root user to configure
the database. You will be prompted to select the HTTP port for Oracle
Application Express, database listener port, SYS and SYSTEM user
password, and the boot option. It is recommended to accept the default
values and continue with the configuration of the database as shown in the
following screenshot:
Installing and Uninstalling Oracle Database XE

To access the database’s home page go to Applications menu | Oracle Database 11g
Express Edition | Get Started.
Starting and stopping Oracle Database XE in
Linux
After you have installed Oracle Database XE, the database is up and running and
you can begin using it right away.

Alternatively, we can start the database manually by running the following
command as the root user:
# /etc/init.d/oracle-xe start
To manually stop the database, run the following command as the root user:
# /etc/init.d/oracle-xe stop
——Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)——
When you uninstall Oracle Database XE, all components, including datafiles, control
files, redo logfiles, and software are removed.
Log on with the root privilege and run the command shown in the following

root@xe1 software]# rpm -e oracle-xe

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: