My Oracle Support Banner

How to Modify an Existing ASM Spfile in a RAC Environment (Doc ID 1376225.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document provides an example on how to modify an existing Automatic Storage Management (ASM) spfile in a two node Real Application Clusters (RAC) Environment.  These steps can be applied to a multiple node Real Application Clusters (RAC) Environment.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1)  Shutdown +ASM2 instance on second node, or if multiple node RAC, all ASM instances on each node except node 1:
 2)  Then, on node 1, connect to +ASM1 instance:
 3)  Create a modified ASM pfile:
 4)  Start up the +ASM1 instance on the first node:
 5)  Check if the ASM diskgroups are mounted properly or not:
 6)  Create the spfile:
 7)  Check the new spfile location through ASMCMD as well:
 8)  Shutdown +ASM1:
 9)  Check the $ASM_HOME/dbs/init+ASM1.ora to ensure that it points to new location of spfile:
 10)  Restart the +ASM1 instance using the new spfile:
 11)   Check the new spfile location through SQL*Plus:
 12)  Check if the ASM diskgroups are mounted properly or not:
 13)  Go to node 2, or each node in multiple node RAC, and check the $ASM_HOME/dbs/init+ASM2.ora to ensure that it points to new location of spfile:
 14)  Restart the +ASM2 instance using the new spfile, or follow this step, step 15, and step 16 in sequential order, for each ASM instance in multiple node RAC (This is a safe startup process for the ASM instances in RAC, rather then using srvctl to startup the rest of the ASM instances.):
 15)  Check the new spfile location through SQL*Plus, or on each ASM instance in multiple node RAC:
 16)  Check if the ASM diskgroups are mounted properly or not,  or for each ASM instance in multiple node RAC:
 Additional Resources
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.