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

Last updated on MAY 08, 2023

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

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

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