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

Oracle XE

Oracle 11g Express Edition Setup
Limitations

will use maximum of 1 GB RAM
11 GB user data
may be installed on a multiple CPU server, but may only be executed on one processor in any server
one database
x86_64 only 

The following are the steps to install a Oracle 11g XE in fedora.

[email protected]>/service iptables status
[email protected]>service iptables stop
[email protected]>vi /etc/sysconfig/selinux

selinux=disabled

To begin, make sure that the following Linux packages are installed. To verify that the
following Linux packages are installed use the rpm ñqa 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/sysctl.conf are as
follows. These changes are to be made by logging in as the oracle 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:

————————Optional Part—————————————–

  1. Create new groups and the oracle user as shown in the following code
    snippet, by logging in as the oracle user:

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle


  1. Log in as the oracle/oracle user and add the following lines at the end of the
    .bash_profile file:
vi .bash_profile

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;
:wq

. .bash_profile

Step3:

[[email protected] Disk1]# yum install libaio

Step4: .
[[email protected] Disk1]# rpm -i oracle-xe-11.2.0-1.0.x86_64.rpm

  1. Run /etc/init.d/oracle-xe configure as the oracle user to configure
    the database.

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 oracle user:

/etc/init.d/oracle-xe start

To manually stop the database, run the following command as the oracle user:

/etc/init.d/oracle-xe stop