Oracle Database 19c : Pre-Requirements2020/07/15

	Install Oracle Database 19c. Before Installing, Change some settings for requirements of installing Oracle database on here.
[1]	Install Desktop Environment, refer to here.
[2]	Install required packages.

[root@dlp ~]#

dnf -y install binutils gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libgcc.i686 libstdc++ libstdc++-devel libXi libXtst libnsl make sysstat

[3]	Edit Kernel parameters.

[root@dlp ~]#

MEMTOTAL=$(free -b | sed -n '2p' | awk '{print $2}')

[root@dlp ~]#

SHMMAX=$(expr $MEMTOTAL / 2)

[root@dlp ~]#

SHMMNI=4096

[root@dlp ~]#

PAGESIZE=$(getconf PAGE_SIZE)

[root@dlp ~]#

cat > /etc/sysctl.d/50-oracle.conf << EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = $SHMMAX
kernel.shmall = $(expr $ $SHMMAX / $PAGESIZE $ \* $ $SHMMNI / 16 $)
kernel.shmmni = $SHMMNI
kernel.sem = 250 32000 100 128
kernel.panic_on_oops = 1
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
EOF

[root@dlp ~]#

sysctl --system

.....
.....
* Applying /etc/sysctl.conf ...
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

[4]	Create user and groups for Oracle Database service.

[root@dlp ~]#

i=54321; for group in oinstall dba oper backupdba dgdba kmdba asmdba asmoper asmadmin racdba; do
groupadd -g $i $group; i=$(expr $i + 1)
done

[root@dlp ~]#

useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,racdba -d /usr/oracle oracle

[root@dlp ~]#

passwd oracle

Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
[root@dlp ~]#

mkdir -p /u01/app/oracle

[root@dlp ~]#

chown -R oracle:oinstall /u01/app

[root@dlp ~]#

chmod -R 755 /u01

[root@dlp ~]#

vi /etc/security/limits.d/50-oracle.conf

# create new

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
oracle   soft   data     unlimited
oracle   hard   data     unlimited

[5]	Login with the user [oracle] and set environment variables.

dlp login:

oracle

Password:

[oracle@dlp ~]$

vi ~/.bash_profile

# add to the end

umask 022
export ORACLE_BASE=/u01/app/oracle

# create a working directory for using installation

[oracle@dlp ~]$

mkdir database

Matched Content