Oracle Database 18c: Oracle Restart Installation Part 1/2 - Prereq

In this blog series I am going to cover Oracle Restart Installation of Oracle 18c on Oracle Linux 7.

This is a 2 blog series where we will do the pre-reqs in first blog and the real installation in the 2nd blog.

In this part I cover the pre-req completion of installation.

You must ensure server is resolvable via a DNS Server

Linux Configuration
1. Install rpm's via yum

yum install oracle-database-preinstall-18c.x86_64 -y
yum install oracleasm-support -y
yum install kmod-oracleasm.x86_64 -y


2. Groups and User Addition

groupadd -g 54331 asmadmin
useradd -g oinstall -G asmadmin,dba -u 54232 grid
Set password for root, oracle and grid user

 Copy secure/limits.d
cd /etc/security/limits.d/
cp oracle-database-preinstall-18c.conf grid-database-preinstall-18c.conf [Replace oracle by grid user]

 Add huge pages
vi /etc/sysctl.conf
vm.nr_hugepages = 10000
sysctl --system

5. Swap Creation - Refer Blog - Swap Creation

6. Update Contents of /etc/profile 

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  ulimit -s 32768
  else
    ulimit -u 16384 -n 65536
    ulimit -s 32768
  fi
fi

if [ $USER = "grid" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  ulimit -s 32768
  else
    ulimit -u 16384 -n 65536
    ulimit -s 32768
  fi
fi

7. ORACLEASM Configuration

#oracleasm configure -i
#oracleasm init
#oracleasm createdisk OCR_VOTE1 /dev/xvdc1
#oracleasm createdisk OCR_VOTE2 /dev/xvdd1
#oracleasm createdisk OCR_VOTE3 /dev/xvde1
[root@rac18c01 tmp]# oracleasm configure -i
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done


[root@rac18c01 ~]# oracleasm init


[root@rac18c01 ~]# oracleasm createdisk OCR_VOTE1 /dev/xvdc1
Writing disk header: done
Instantiating disk: done

[root@rac18c01 ~]# oracleasm createdisk OCR_VOTE2 /dev/xvdd1
Writing disk header: done
Instantiating disk: done

[root@rac18c01 ~]# oracleasm createdisk OCR_VOTE3 /dev/xvde1
Writing disk header: done
Instantiating disk: done


[root@rac18c01 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "OCR_VOTE1"
Instantiating disk "OCR_VOTE2"
Instantiating disk "OCR_VOTE3"

8. Create Directories

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

mkdir /u01/app/180
chown grid:oinstall /u01/app/180
chmod 755 /u01/app/180

mkdir /u01/app/grid
chown grid:oinstall /u01/app/grid
chmod 755 /u01/app/grid

mkdir /u01/app/oraInventory
chown grid:oinstall /u01/app/oraInventory
chmod 755 /u01/app/oraInventory

mkdir -p /u01/app/oracle/product/180/db
chown -R oracle:oinstall /u01/app/oracle

#[As grid user]
mkdir -p /u01/app/180/grid

The next blog covers the installation of Oracle Restart.