Today we will learn how to install Oracle Database Release 12.2.0.1 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 given below link:

Creating Virtual Machine in Virtual Box

Then, copy the media in OEL

Unzip both the folders

unzip linuxx64_12201_database.zip

Pre-Requisite Steps

If you are planning to use the “ yum install oracle-database-server-12cR2-preinstall -y” 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-database-server-12cR2-preinstall -y

[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “0” entry_duration= “1” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]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.[edsanimate_end]

Oracle recommend the following minimum parameter settings.

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

The current values can be tested using the following command.

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

[edsanimate_start entry_animation_type= “shake” entry_delay= “0.5” entry_duration= “1” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]All the Steps Done below will be executed by ROOT user:[edsanimate_end]

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

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

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   nofile    1024

oracle   hard   nofile    65536

oracle   soft   nproc    16384

oracle   hard   nproc    16384

oracle   soft   stack    10240

oracle   hard   stack    32768

oracle   hard   memlock    134217728

oracle   soft   memlock    134217728

Now  we will Create User and Groups for the Installation of Database 12c

#groupadd -g 54321 oinstall

#groupadd -g 54322 dba

#groupadd -g 54323 oper

#useradd -u 54321 -g oinstall -G dba,oper oracle

#passwd oracle

# systemctl stop firewalld

# systemctl disable firewalld

Amend the /etc/security/limits.d/90-nproc.conf file as described below.

# Change this

*          soft    nproc    1024

# To this

* – nproc 16384

Create directories in which the Oracle Database 12c will be installed.

#mkdir -p /u01/app/oracle/product/12.2.0.1/db_1

#chown -R oracle:oinstall /u01

#chmod -R 775 /u01

Bash Profile Setting

Login as the oracle user and add the following lines at the end of the .bash_profile file.

# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=database.com

export ORACLE_UNQNAME=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1

export ORACLE_SID=orcl

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

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

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

Begin Database Installation

Now go to the directory where 12c setup has been unzipped and run Installer.

Uncheck the following icon and then click next

Select Create and configure a database and then click next

Select Server Class and then Click Next

Select the following and then click Next.

Select the following and then click Next.

Enter the password and then Click Next.

Note:Remember  The Global Database name and Pluggable Database Name. In our case

Global Database Name: cdb

Pluggable Database Name : pdb

Check Ignore All and the Click Next

Click Yes and then Click Next

Click Install

Installation will be started, it will take atleast 20 minutes to install and create Database 12c

Execute  following script on terminal window, Then Click Ok

#/u01/app/oracle/product/12.2.0.1/db_1/root.sh

Click Next

Click Close

[edsanimate_start entry_animation_type= “pulse” entry_delay= “0” entry_duration= “0.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]Your Oracle Database 11g Version 11.2.0.3 has been installed!!!!![edsanimate_end]