Oracle 19c grid installation and configuration

 In this post let's discuss the steps involved in installing and configuring the Oracle 19c grid.

Step 1: Check whether RPMs are installed.

Check whether all the required RPMs are installed in the server by running the following commands.

sudo rpm -qa |grep  kmod-oracleasm
sudo rpm -qa |grep  oracleasm-support
sudo rpm -qa |grep  oracleasmlib
sudo rpm -qa |grep  oracleasmlib-2.0.12-1
sudo rpm -ivh cvuqdisk-1.0.10-1.rpm

Step 2: Create a directory

Create a directory in which we are gonna install the 19c grid.

mkdir -p /oracledba/arena/db/oracle/product/19.3.0.0/grid/
cd /oracledba/arena/db/oracle/product/19.3.0.0/grid

Step 3: Configure ASM

sudo oracleasm configure -i
sudo oracleasm init
sudo oracleasm scandisks
sudo oracleasm listdisks
Step 5: Check the available LUNs and create disks
ls -l /dev/disk/by-id|grep ggn|grep part1
sudo oracleasm createdisk ORA_DATA_01 /dev/sdd1
sudo oracleasm createdisk ORA_DATA_02 /dev/sde1
sudo oracleasm createdisk ORA_DATA_03 /dev/sdf1
sudo oracleasm createdisk ORA_DATA_04 /dev/sdg1
sudo oracleasm createdisk ORA_DATA_05 /dev/sdh1
sudo oracleasm createdisk ORA_DATA_06 /dev/sdi1
sudo oracleasm createdisk ORA_DATA_07 /dev/sdj1
sudo oracleasm createdisk ORA_DATA_08 /dev/sdk1
sudo oracleasm createdisk ORA_DATA_09 /dev/sdl1
sudo oracleasm scandisks
sudo oracleasm listdisks
Step 6: Copy and upzip the software
cd /mnt/dbaSoftware/19c_softwares
cp -rp LINUX.X64_193000_grid_home.zip /oracledba/arena/db/oracle/product/19.3.0.0/grid/
cd /oracledba/arena/db/oracle/product/19.3.0.0/grid/
unzip LINUX.X64_193000_grid_home.zip
Step 7: Run the prechecks

./runcluvfy.sh stage -pre hacfg
Step 8: Install ASM Grid

Ask the sysadmin team to run scripts as root user and then click ok.

Step 10: Add disks to the disk group

Use the below query to check the disk groups added.

set lines 999;
col diskgroup for a15
col diskname for a15
col path for a35
select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path, 
b.header_status
from v$asm_disk b, v$asm_diskgroup a 
where a.group_number (+) =b.group_number 
order by b.group_number,b.name;

Add a disk to the disk group

alter diskgroup ORA_DATA add disk '/dev/oracleasm/disks/ORA_DATA_02' NAME ORA_DATA_02 rebalance power 100;
alter diskgroup ORA_DATA add disk '/dev/oracleasm/disks/ORA_DATA_03' NAME ORA_DATA_03 rebalance power 100;
alter diskgroup ORA_DATA add disk '/dev/oracleasm/disks/ORA_DATA_04' NAME ORA_DATA_04 rebalance power 100;
alter diskgroup ORA_DATA add disk '/dev/oracleasm/disks/ORA_DATA_05' NAME ORA_DATA_05 rebalance power 100;
alter diskgroup ORA_DATA add disk '/dev/oracleasm/disks/ORA_DATA_06' NAME ORA_DATA_06 rebalance power 100;
alter diskgroup ORA_DATA add disk '/dev/oracleasm/disks/ORA_DATA_07' NAME ORA_DATA_07 rebalance power 100;
alter diskgroup ORA_DATA add disk '/dev/oracleasm/disks/ORA_DATA_08' NAME ORA_DATA_08 rebalance power 100;
alter diskgroup ORA_DATA add disk '/dev/oracleasm/disks/ORA_DATA_09' NAME ORA_DATA_09 rebalance power 100;

Rename the disk in the disk group

Since the first disk group was added while installing the grid naming convention might be different from what we follow. Please use the below command to rename the disk group. To rename the disk, we need to unmount the disk group.

alter diskgroup ORA_DATA dismount force;
alter diskgroup ORA_DATA mount restricted;
alter diskgroup ORA_DATA rename disk 'ORA_DATA_0000' to 'ORA_DATA_01';
alter diskgroup ORA_DATA dismount force;
alter diskgroup ORA_DATA mount;