Essential ASMCMD and CRSCTL Commands as Key Expertise for Oracle DBAs Overview: ASMCMD is a command-line utility in Oracle Automatic Storage Management (ASM) used by Oracle DBAs to manage ASM disk groups and files. It provides a Linux-like interface to perform navigation, monitor storage, and execute file operations. List All ASM Disk… Read more..

Configuring Disks for Oracle ASM Storage Setup in Oracle database 19C Overview:  The disk configuration is a major step when setting up Oracle ASM (Automatic Storage Management) in Oracle Database 19c. ASM provides an efficient way to manage database storage by organizing disks into disk groups, improving… Read more..

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