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...

Adding new disk to ASM diskgroup

Adding a disk to an ASM diskgroup is really simple, just an alter command. But when if you are doing this in a production database, then before adding we have to make sure that the disk is healthy. We...