Oracle 11gr2 installation on Linux (OEL5)

It is my first post. Please review and give suggetions friends..

In below post, you can get knowledge on "How to install ORACLE 11gr2 on ORACLE ENTERPRISE LINUX 5.5"...

What we need :
1- Preinstalled OEL 5 in VMWARE
2- ORACLE 11gr2 database software

Let's start our oracle installation :

At first, we have to set kernel parameter.

(You must be ROOT user to perform these activity.)

vi /etc/sysctl.conf

Insert following lines and save it

fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Run below command to activate the kernel parameter


/sbin/sysctl -p

Run below command in root user :

vi /etc/pam.d/login

Add below lines and save it.

session required pam_limits.so

Run :

vi /etc/security/limits.conf

Add below lines : 

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  1024

oracle              hard    nofile  65536

Now we have to install RPM packages:

# From Oracle Linux 5 DVD

cd /media/cdrom/Server

rpm -Uvh binutils-2.*

rpm -Uvh compat-libstdc++-33*

rpm -Uvh compat-libstdc++-33*.i386.rpm

rpm -Uvh elfutils-libelf*

rpm -Uvh gcc-4.*

rpm -Uvh gcc-c++-4.*

rpm -Uvh glibc-2.*

rpm -Uvh glibc-common-2.*

rpm -Uvh glibc-devel-2.*

rpm -Uvh glibc-headers-2.*

rpm -Uvh ksh*

rpm -Uvh libaio-0.*

rpm -Uvh libaio-devel-0.*

rpm -Uvh libgomp-4.*

rpm -Uvh libgcc-4.*

rpm -Uvh libstdc++-4.*

rpm -Uvh libstdc++-devel-4.*

rpm -Uvh make-3.*

rpm -Uvh sysstat-7.*

rpm -Uvh unixODBC-2.*

rpm -Uvh unixODBC-devel-2.*

rpm -Uvh numactl-devel-*

Now we have to make user and some directories for ORACLE :

groupadd oinstall

groupadd dba

useradd -m -g oinstall -G dba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle

passwd oracle

mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1

chown -R oracle:oinstall /u01

chmod -R 777 /u01

Now we have to set bash profile for ORACLE USER :

vi /home/oracle/.bash_profile

Add following lines in the bash_profile :

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=<Host Name; export ORACLE_HOSTNAME

ORACLE_UNQNAME=ORCL; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_SID=ORCL; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Now unzip the ORACLE 11gr2 software : 

(If you are using OEL 5 in VMware and your parent OS is Windows, then you need WinSCP to transfer file from Windows to Linux)

cd /tmp/

unzip linux_11gR2_database_1of2\(1\).zip

unzip linux_11gR2_database_2of2\(1\).zip

Now you can see a database folder in "/tmp" directory. Then go to /tmp directory and also into "database" directory. (Here you should be in oracle user)..

cd /tmp/database/

To install oracle software by graphically, we have process following commands..

./runInstaller &

After installing, we have to run two following scriptss. (in ROOT user)

sh /u01/app/oraInventory/orainstRoot.sh

sh /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

To create database, we have to run following command..

dbca &