Home Oracle DB Oracle Database 19c ASM installation-Step-By-Step process

Oracle Database 19c ASM installation-Step-By-Step process

0
296

With the advancement of various versions and releases by Oracle for as part of RDBMS, Oracle has released recent database version 19c on 13th Feb,2019. It offers market-leading performance, scalability and security both on-premise and in the cloud. As this is a Long Term Release of the Oracle database 12c and 18c family of products, it provides the highest level of release stability and longest time frame for support and bug fixes.

I tried to collect and put together all the commands required for ASM setup for Oracle 19c environment with all its pre-requisites and installation steps.

  • RHEL 7.5+ is needed for Oracle 19c
  • 2. Following rpm packages should be installed in Linux server.

bc
binutils
elfutils-libelf
elfutils-libelf-devel
fontconfig-devel
glibc
glibc-devel
ksh
libaio
libaio-devel
libXrender
libX11
libXau
libXi
libXtst
libgcc
libnsl
librdmacm
libstdc++
libstdc++-devel
libxcb
libibverbs
make
smartmontools
sysstat

  • User and group creation using following scripts.

[[email protected] ~]# groupadd oinstall

[[email protected] ~]# groupadd asmadmin

[[email protected] ~]# groupadd dba

[[email protected] ~]# groupadd oper

[[email protected] ~]# groupadd asmdba

[[email protected] ~]# groupadd asmoper

Grid/Oracle BASE,HOME

======================

[[email protected] ~]# mkdir -p /oragrid/app/product/                     

[[email protected] ~]# mkdir -p /oragrid/app/product/12.2.0.1/grid 

[[email protected] ~]# chown -R grid:oinstall /oragrid

[[email protected] ~]# chmod -R 775 /oragrid

[[email protected] ~]# mkdir -p /oracle/app/oracle/                         

[[email protected] ~]# mkdir -p /oracle/app/oracle/product/19.3.0/dbhome_1

[[email protected] ~]# chown -R oracle:oinstall /oracle

[[email protected] ~]# chmod -R 775 /oracle

[[email protected] ~]# useradd -g oinstall -G dba,asmadmin,asmdba,asmoper -d /home/grid -m grid

[[email protected] ~]#passwd grid

[[email protected] ~]#useradd -g oinstall -G dba,oper,asmdba -d /home/oracle -m oracle

[[email protected] ~]#passwd oracle

  • Disable set Linux parameter using following and set all other parameters in linux

 [[email protected] ~]# vi /etc/sysconfig/selinux

[[email protected] ~]# vi /etc/sysctl.conf

kernel.shmmax = 68719476736

kernel.shmall = 4294967296

kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
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

[[email protected] ~]# /sbin/sysctl -p

[[email protected] ~]#cat /etc/security/limits.conf

  • Unzip following grid binary zip file

LINUX.X64_193000_grid_home.zip

  • Install following oracleasm rpm package for oracleasm disk creation.

[[email protected] ~]# rpm -ivh oracleasm-support-2.1.11-2.el7.x86_64.rpm

[[email protected] ~]# rpm -ivh oracleasmlib-2.0.12-1.el7.x86_64.rpm

  • Export LUN space and create oracleasm disk using following commands for DATA, REDO, VOTE and ARCH diskgroups.

[[email protected] ~]# oracleasm createdisk DATA01 /dev/mapper/sda1

[[email protected] ~]# oracleasm createdisk ARCH01 /dev/mapper/sdb1

[[email protected] ~]# oracleasm createdisk REDO01 /dev/mapper/sdc1

[[email protected] ~]# oracleasm createdisk REDO02 /dev/mapper/sdd1

[[email protected] ~]# oracleasm createdisk VOTE01 /dev/mapper/sde1

  • Scan all the disks using following command.

[[email protected] ~]# oracleasm scandisks

  • List all the disks to check whether created disks are showing.

[[email protected] ~]# oracleasm listdisks

  1. Run the following script available in the unzipped folder in step 5 from grid user. There follow all the steps mentioned in the screenshot.

[[email protected] ~]# su – gird

[[email protected] ~]# ./gridSetup.sh

Your disk paths and their name might be different.

Click Ok and run the above mentioned 2 scripts using root user which completes the installation process.

  • Run the following command using root user to check status of ASM.

[[email protected] ~]#  cd /oragrid/app/product/19.3.0/grid/bin

[[email protected] ~]#  ./crsctl stat res -t -init

Note: Please check my post on Database binary installation to complete installation process.

Oracle Database 19c ASM installation-Step-By-Step process