Advertisement

Wednesday, April 4, 2018

Oracle Database - 18c - PreReq Setup

This blog list pre-requirements for 18c install. 

Step 1
[As root - RPMS Install]
Have the RPMS Installed as per Oracle Instalaltion Doc https://docs.oracle.com/en/database/oracle/oracle-database/18/ladbi/database-installation-guide-linux.pdf

Step 2
[As root - Create Groups and users]

groupadd -g 1001 oinstall
groupadd -g 1002 dba
useradd -g 1001 -G dba -u 1001 -s /bin/bash -d /home/oracle oracle

Step 3
[As root - Set sysctl configurations]
vi /etc/sysctl.d/97-oracle-database-sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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
net.ipv4.ip_local_port_range = 9000 65500
kernel.shmall = 3145538
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
kernel.shmmax = 12884125286
vm.nr_hugepages = 3839

Step 4
[As root - Apply changes]
## Apply Changes
sysctl --system

Step 5
[As root - Modify Security Config]
vi /etc/security/limits.conf
Append
oracle   soft   nofile    131072
oracle   hard   nofile    131072
oracle   soft   nproc    131072
oracle   hard   nproc    131072
oracle   soft   core    unlimited
oracle   hard   core    unlimited
oracle   soft   memlock   14154922
oracle   hard   memlock    14154922

Step 6
[As root - Append to PAM Config]
vi /etc/pam.d/login
session    required     pam_limits.so

Step 7
[As root ]
Disable SELINUX and Transparent Huge Pages
Make sure Hostname entry is there in /etc/hosts or hostname is pingable.

Step 8
[As root - run below ]
Set permissions to 755 for
chmod 755  /usr/bin/ld.bfd ls -lrt /usr/bin/make

chmod 0644 /etc/sysctl.conf /etc/sysctl.d/97-oracle-database-sysctl.conf

mkdir -p /u01/app/oracle
mkdir -p  /u01/app/oraInventory
mkdir -p /u01/app/oracle/product/180/db1

vi /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall


chown root:oinstall /u01
chmod 755 /u01

chown root:oinstall /u01/app
chmod 755 /u01/app

chown -R oracle:oinstall /u01/app/oracle
chmod -R 755 /u01/app/oracle

chown oracle:oinstall /u01/app/oraInventory
chmod 770 /u01/app/oraInventory
chown root:root /etc/oraInst.loc
chmod 644 /etc/oraInst.loc

No comments:
Write comments