A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

Step by Step ASM/ Grid Installation in Oracle Standalone

3 min read

Prerequisite.


Add below OS groups


Add  asmdba as secondary group to Oracle user


Create Grid User

[root@dg11 /]# useradd -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid


Change the password for Oracle and Grid user


Create the Directories for Oracle Database installation


Create the Directories for Oracle Grid installation

Step2. Configure Oracle ASM


Load / initiate Oracle ASM

init 0

Add  25 GB  Hard Disk


Add 25 GB HDD to virtual machine which we will use to create 3 partitions of 5,10,10 GB each for our ASM disks.


Open Virtual machine >> Settings >> Storage >> Controller: SATA >> Create new disk

IMG1
IMG2
IMG3
IMG4
IMG5
IMG6
IMG7

Click on OK & Start the VM Machine.


Start virtual machine and login as root user to format the newly added disk

IMG8
IMG9
IMG10
Step3. Create separate ASM Disk for each partition


To check asm disks


Step4. Install Grid Software


Put the content under vi text editor in bash profile & save it.

[grid@dg11 ~]$ vi .bash_profile
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
ORACLE_SID=+ASM; export ORACLE_SID
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/grid/product/19/grid; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
JAVA_HOME=/usr/bin/java; export JAVA_HOME
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/local/bin
export PATH

umask 022

Restart your server to overcome graphics issues. (init 6 or shutdown -r now)

[root@dg11 ~]# /u01/app/grid/product/19/grid/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/grid/product/19/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/grid/product/19/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/dg11/crsconfig/roothas_2022-11-19_05-00-41PM.log
2022/11/19 17:00:51 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE 
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE 
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node dg11 successfully pinned.
2022/11/19 17:01:05 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

dg11     2022/11/19 17:02:04     /u01/app/grid/crsdata/dg11/olr/backup_20221119_170204.olr     724960844     
2022/11/19 17:02:05 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
[root@dg11 ~]# 

Then Click on OK for further progress of Grid installation.

Configure ASM Disk groups

[root@dg11 app]# su - grid
Last login: Sat Nov 19 17:02:04 IST 2022 on pts/1

[grid@dg11 ~]$ ps -ef|grep pmon
grid     14548     1  0 17:05 ?        00:00:00 asm_pmon_+ASM
grid     17046 16980  0 17:15 pts/1    00:00:00 grep --color=auto pmon
[grid@dg11 ~]$ 

Login to ASM & check number of Diskgroup Configured.