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 Read More

Learn the basic command of Oracle ASM in Oracle Database Login to the Oracle ASM Instance [oracle@ractest1 ~]$ . oraenv ORACLE_SID = [+ASM1] ? +ASM1 The Oracle base remains unchanged with value /u02/app/oracle ls – It displays the list of disk associated to single instance. ASMCMD> ls DATA/ ls -g – It… Read more..

Stop the Single ASM Instance in Oracle Database – To stop the ASM Instance, First we need to Stop the RDBMS & then we need to stop the ASM Instance Check the status of database [oracle@pri-db1 ~]$ srvctl status database -d testdb1 Instance testdb1 is running on node testdb1 Stop the RDBMS Database [oracle@pri-db1 ~]$ Read More

How to Auto Start CRS after on Reboot Server I wanted to restart the CRS automatically after reboot the server., By default the CRS AUTO_START is never. You need to configure the AUTO_START=always., Fallow the below steps. Check the current status of CRS on server [root@pri-db bin]# ./crsctl stat res ora.cssd -p | grep AUTO_START Read More

Instantiating disk failed while creation of ASM Disk. The below error is occur while creation of the ASM Disk in one of my test server. [root@testdb asm_rpm]# /usr/sbin/oracleasm createdisk DATA /dev/sdc1 Writing disk header: done Instantiating disk: failed ——- error Clearing disk header: done This issue can be resolved by diable & enable the… Read Read More

How to backup of the ASM HEADER in Oracle ASM Database. Overview of ASM Disk Header ASM disk header contains the metadata essential for the operation and availability of an ASM disk group, ASM disks are formatted into Allocation Units, The… Read more..