Change the ASM spfile in 11gR2

Change the ASM spfile in 11gR2

How to change the ASM spfile in 11gR2

Logical steps to change the ASM spfile

1. Create intermediate pfile from the current spfile or pfile
2. Create spfile in a new disk group from the intermediate pfile
3. Restart the HA stack to verify that ASM starts up fine with moved spfile
4. Remove the original spfile

You can verify whether you are using the correct spfile for the ASM in the cluster environment.

Multiple way to check the spfile details in 11gR2

#1

oracle +ASM1> asmcmd spget

+OCR_VOTE/bhurac1a/asmparameterfile/registry.253.789386957

#2

oracle +ASM1 > gpnptool get

SPFile="+OCR_VOTE/bhurac1a/asmparameterfile/registry.253.789386957"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"> 1ZtgbzWQAuybhO0J12R2X5D+gMc=A1Bx+lPu1QSsxGYrRJ5jVbhJ/oVkP8DcKxoCgV90gLk7/m4CztcatcRftHSDvg92z/0HzEog7AGltl0pDZZLMgA9sglWUop/GOPkzF1jxO9I7qbjQjeqLOoS79+XXV9M9LQ8KtosNvGE50VdE2tswdWc2IDJ8AelhL9wNCabBwg=

Success.

#3

oracle +ASM1 > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 23 12:22:00 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> show parameter spfile

NAME                                 TYPE                                                  VALUE

------------------------------------ ----------------------------------------------------

spfile                               string  +OCR_VOTE/bhurac1a/asmparameterfile/registry.253.789386957

If you want to create a spfile from the existing spfile with some modification then you need to take backup from existing one.

SQL> create pfile='/home/oracle/init+ASM.ora' from spfile;

In the below case, my spfile is located in the environment and it is NOT picked up by the cluster during the startup.

So I am creating the pfile from spfile which is located in the diskgroup.

SQL> create pfile='/home/oracle/init+ASM.ora' from spfile='+OCR_VOTE/bhurac1a/ASMPARAMETERFILE/REGISTRY.253.757697363';

If you need modify any parameter in the ASM parameter, we can modify it.

Create a new spfile from the pfile

SQL> create spfile=’+OCR_VOTE’ from pfile='/home/oracle/init+ASM.ora';

Once the spfile is create, if you check spfile location in the cluster environment. it will show the new file.

You can verify using the below command. Note: THIS SPFILE WILL BE INCLUDING TO ALL THE CLUSTER NODES IN THE ENVIRONMENT.

#1 set the ASM environment values

$ asmcmd spget

(Or)

$ gpnptool get

Restart the cluster and you could see the cluster is picking up the new spfile.