Mir Sayeed Hassan – Oracle Blog

Error occur while detecting ASM as Oracle Grid infrastructure is not configured properly ASMCA needs Oracle Grid Infrastructure to configure ASM in Single Instance ASM Database

Brief:

– First of all the Grid Infrastructure is install with standalone server only option
– Due to this the error occur while adding an ASM Disk into the Oracle Grid Infrastructure using ASMCA
– To resolve this., We should fallow the below step by step process.
– For this method, we can call as the Configuring of Oracle ASM Disk Groups Manually using Oracle ASMCA
– You can create and configure additional disk groups after this process.

Find the below error message.

Verify any disk is assign/created to ASM Diskgroup.

Scan Disks.

[root@restoredb ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...

List Disks.

[root@restoredb ~]# oracleasm listdisks
TEST

Find the below error while adding an ASM Disk into it.

To resolve this., Execute the below command as root user

If you are runing as a Stand-alone Server., Issue this:

[root@restoredb ~]# export ORACLE_HOME=/u01/app/11.2.0/grid

[root@restoredb ~]# $ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/crs/install $ORACLE_HOME/crs/install/roothas.pl

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user 'oracle', 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 restoredb successfully pinned.
Adding Clusterware entries to upstart

restoredb 2023/04/27 18:33:50 /u01/app/11.2.0/grid/cdata/restoredb/backup_20230427_183350.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server

Now you can start adding the ASM Disk into the Server as shown below.

Create an ASM Disk

 

ASM Disk has been created successfully

ASM Disk added successfully

Verify:

[oracle@restoredb ~]$ . oraenv
ORACLE_SID = [pspswi1] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@restoredb ~]$ asmcmd

ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 114431 114371 0 114371 0 N TEST/

=====Hence tested & verified in our test env=====