If you are working on RHEL, then to use the disk in ASM diskgroup, the disks need to be labeled with ASM. Earlier oracleasm utility was used for this purpose. But oracle developed its own ASM filter d...
ASM
How to change asm spfile location in oracle RAC
Recently we found that, one of our asm instance was using a different spfile. So used below steps to change the spfile. existing spfile – > /u01/app/grid/dbs/asmbackup.ora new spfile ...
ORA-15260: permission denied on ASM disk group
PROBLEM: While creating a diskgroup , got ORA-15260: permission denied on ASM disk group error. [oracle@19c]$ sqlplus / as SYSDBA SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 18 18:42:58 2021 ...
How to move spfile from file system to ASM in RAC
Below are the steps for moving spfile from file system to ASM diskgroup in RAC. database name – ORCL instance_names – ORCL1,ORCL2 oracle DB nodes – dbhstorcl1, dbhstorcl2 1. Check cu...
Datapump export to ASM diskgroup (EXPDP)
It is tvery common to export dump file to the standard file system(Mount points). However, we can export the dump files to ASM diskgroup also. In this article, we will show the steps for this . DEMO 1...
How to create ACFS file system in RAC using command line:
ACFS i.e Oracle ASM Cluster File System is cluster file system service used for High availability services. Example – For achieving high availability in goldenate for Oracle RAC, we can use ACFS...
Create password files for database in ASM diskgroup
Below are the steps for creating password file for database in ASM diskgroup . This method is valid only for oracle 12c onwards. SYNTAX – ASMCMD> pwcreate –dbuniquename {db_unique_name}...
ASM_POWER_LIMIT in oracle ASM
ASM_POWER_LIMIT specifies the disk rebalancing speed of the ASM instance. The higher the limit, the faster rebalancing operation, but consume lot of CPU. Lower values will take longer, but consume few...
oracleasm utility for ASMLIB
ASMlib driver is required on Linux operating systems, to enable a disk readable by ASM. Without ASMLIB, disks can’t be used at asm disks. Below are the steps for configuring ASMlib and marking...
ASMCA utility in oracle
ASMCA ( ASM Configuration Assistant) is a GUI utility provided by grid, to manage ASM instances and diskgroups like , create diskgroup, adding disk/diskgroup, dropping disk/diskgroup, mount/dismount d...