Oracle Database 19c Installation on Oracle Linux 7

Hello, friends in this article we are going to discuss Oracle database 19c (64-bit) Installation on Oracle Linux 7. Using this article we are going to Install an Oracle 19c server based with a 2GB swap.

Table of Contents

Software I used in this article

VMware
Oracle Linux 7 (64-bit)
Oracle Database 19c (19.3, 64-bit)

Download Database Software

You can download Oracle Database 19c software using the below buttons.

Download 19c from OTN

Download 19c from E-delivery

IP Address and Hostname

As per my system, I’m going to use the following IP address and hostname for this installation.

IP Address	Hostname
192.168.1.10	ocp_19c.localdomain

Start Pre-Configuration

Set your machine name in “/etc/hostname” file.

vi /etc/hostname

ocp_19c.localdomain

Edit Hosts file

Now edit “/etc/hosts” file and add above IP address with hostname.

<IP-address>  <fully-machine-name>  <short-name>
192.168.1.10      ocp_19c.localdomain        ocp_19c

Edit sysctl.conf

Add following lines in “/etc/sysctl.conf” to update kernel parameters.

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 update the above kernel parameters.

/sbin/sysctl -p

Edit limits.conf

Edit “/etc/security/limits.conf” file and add below lines.

 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

SELINUX=permissive

Edit “/etc/selinux/config” and set secure Linux permissive.

SELINUX=permissive

RPM Installation

The following RPMs are required to successfully install Oracle Database 19c software.

Note:– During rpm installation, make sure your internet working on your server, some packages will be updated automatically from the internet.

yum install -y bc    
yum install -y binutils
yum install -y compat-libcap1
yum install -y compat-libstdc++-33
yum install -y dtrace-utils
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio
yum install -y libaio-devel
yum install -y libdtrace-ctf-devel
yum install -y libXrender
yum install -y libXrender-devel
yum install -y libX11
yum install -y libXau
yum install -y libXi
yum install -y libXtst
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc++
yum install -y libstdc++-devel
yum install -y libxcb
yum install -y make
yum install -y net-tools # Clusterware
yum install -y nfs-utils # ACFS
yum install -y python # ACFS
yum install -y python-configshell # ACFS
yum install -y python-rtslib # ACFS
yum install -y python-six # ACFS
yum install -y targetcli # ACFS
yum install -y smartmontools
yum install -y sysstat

Create Username and Groups

Create new username and groups for Oracle using the following query.

#Groups
groupadd -g 54321 oinstall 
groupadd -g 54322 dba 
groupadd -g 54323 oper 

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

#Set Password for Oracle users
passwd oracle

How to Disable Firewall Oracle Linux 7

Set firewall disable using the following queries.

#To stop firewall
systemctl stop firewalld 

#To Disable Firewall
systemctl disable firewalld

Update .bash_profile

Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=ocp_19c.localdomain 
export ORACLE_UNQNAME=ocp
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=ocp
export DATA_DIR=/u01/oradata
export PATH=/usr/sbin:/usr/local/bin:$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

Create Directories

Create directories and grant permissions for oracle installation.

mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
mkdir -p /u01/oradata

chown -R oracle:oinstall /u01 
chmod -R 775 /u01

Unzip Database software

Extract the oracle database 19c zip file inside the Oracle home directory, check the below commands.

#unzip /u01/oracle19c.zip -d/u01/app/oracle/product/19.0.0/dbhome_1

After unzip, Now it’s time to start runInstaller.

Read - Oracle 19c RPM based Installation

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: https://www.linkedin.com/in/shripal-singh
Twitter: https://twitter.com/ocptechnology
Facebook: https://www.facebook.com/ocptechnology
YouTube:https://www.youtube.com/ocptechnology