Installation Of Oracle Database Release 11.2.0.3 on Oracle Enterprise Linux(OEL) 6.4

First download the media from below given link:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

For creating a Virtual machine kindly refer to the Blog Creating Virtual Machine in Virtual Box

Copy the media in OEL

Unzip both the folders by Using Following Given Commands:

unzip p10404530_112030_Linux-x86-64_1of7$DB$.zip

unzip p10404530_112030_Linux-x86-64_2of7$DB$.zip

Operating System Settings

If you are planning to use the “oracle-rdbms-server-11gR2-preinstall” package to perform all your prerequisite setup, follow the instructions at http://public-yum.oracle.com.

If you have internet available on your server then you can run below command directly:

# yum install oracle-rdbms-server-11gR2-preinstall

NOTE: If you have not used the “oracle-rdbms-server-11gR2-preinstall” package to perform all prerequisites, you will need to manually perform the following setup tasks.

Oracle recommend the following minimum parameter settings.

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

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 = 1048586

Current values can be tested using the following command.

/sbin/sysctl -a | grep <param-name>

All the Steps Done below will be executed by ROOT user:

If there is any change in the values of the parameter above edit the following lines in the /etc/sysctl.conf file.

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

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=1048586

Run the following command to change the current kernel parameters.

/sbin/sysctl –p

Now, Add the following lines to the /etc/security/limits.conf file.

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft nofile 4096

oracle hard nofile 65536

oracle soft stack 10240

Now, We will Create User and Groups for the Installation of Database 11g. Open the terminal and copy the following below commands to create User and Groups

groupadd -g 501 oinstall

groupadd -g 502 dba

groupadd -g 503 oper

groupadd -g 504 asmadmin

groupadd -g 506 asmdba

groupadd -g 505 asmoper

useradd -u 502 -g oinstall -G dba,asmdba,oper oracle

passwd oracle