Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

re: Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

pc — Wed, 30 Jan 2013 19:42:05 GMT

thanks Robert. It worked.

cheers

re: Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

Robert Bialek — Mon, 28 Jan 2013 07:55:41 GMT

1. Change to the $ORACLE_HOME/gpnp/<server>/profiles/peer/ directory and execute the "gpnptool getpval -asm_dis" command, or

2. Use the -p parameter to specify the full path to the profile.xml:

grid@iudb007:~/ [+ASM5] gpnptool getpval -asm_dis -p=$ORACLE_HOME/gpnp/iudb007/profiles/peer/profile.xml

Warning: some command line parameters were defaulted. Resulting command line:

/u00/app/grid/product/11.2.0.3/bin/gpnptool.bin getpval -asm_dis -p=/u00/app/grid/product/11.2.0.3/gpnp/iudb007/profiles/peer/profile.xml -o-

/dev/mapper/*p1

Cheers,

Robert

re: Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

PC — Sat, 26 Jan 2013 10:03:49 GMT

I get the foll.:

$ gpnptool getpval -asm_dis

Error: Can't open profile 'profile.xml' for read: file not found

Can you pls advice as to what could be the reason? The above is when entire RAC stack is up on the node.

Thanks.

re: Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

nnarimanov — Sun, 02 Dec 2012 20:20:45 GMT

Hi Robert,

Very nice article, thanks. Keep on blogging.

re: Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

Robert Bialek — Wed, 21 Nov 2012 14:15:26 GMT

Hi Ramesh,

sorry for the delay.

> But Is it possible to down the ASM instance in 11gR2 Grid while ocr and voting disks are placed in the diskgroups ?

> Can you please explain the consequences for this?

Yes, you can shutdown the ASM instance with:

1. "crsctl stop crs" or "crsctl stop cluster -n node"

This way you will shutdown not only the ASM instance, but rather the cluster and all ASM dependent cluster resources on the server.

2.shutdown abort (other options will not work, because the cluster is also considered as a client).

ASMCMD> lsct

DB_Name Status Software_Version Compatible_version Instance_Name Disk_Group

+ASM CONNECTED 11.2.0.3.0 11.2.0.3.0 +ASM1 GRID <<<---

asmvol CONNECTED 11.2.0.3.0 11.2.0.3.0 +ASM1 CLUSTERFS

TVD102 CONNECTED 10.2.0.5.0 10.2.0.5.0 TVD1021 U7010

TVD102 CONNECTED 10.2.0.5.0 10.2.0.5.0 TVD1021 U7020

SQL> shutdown abort

ASM instance shutdown

SQL>

This will lead to a crash of every resource which depends on ASM (TVD1021,TVD1021, ACFS), but the cluster core components will be still up and running:

grid@iudb044:~/ [+ASM1] crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

grid@iudb044:~/ [+ASM1] crsctl status resource -init -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Cluster Resources

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

ora.asm

1 OFFLINE OFFLINE Instance Shutdown

ora.cluster_interconnect.haip

1 ONLINE ONLINE iudb044

ora.crf

1 ONLINE ONLINE iudb044

ora.crsd

1 ONLINE ONLINE iudb044

ora.cssd

1 ONLINE ONLINE iudb044

ora.cssdmonitor

1 ONLINE ONLINE iudb044

ora.ctssd

1 ONLINE ONLINE iudb044 OBSERVER

ora.diskmon

1 OFFLINE OFFLINE

ora.drivers.acfs

1 ONLINE ONLINE iudb044

ora.evmd

1 ONLINE ONLINE iudb044

ora.gipcd

1 ONLINE ONLINE iudb044

ora.gpnpd

1 ONLINE ONLINE iudb044

ora.mdnsd

1 ONLINE ONLINE iudb044

HTH,

Robert

re: Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

Ramesh Togara — Fri, 16 Nov 2012 09:32:50 GMT

Hi Robert.

Excellent post. Good information for better understand.

Can you please clarify me the below.

As you mentions cluster can only read the information about ocr&vote disk information from an unmounted disk.

But Is it possible to down the ASM instance in 11gR2 Grid while ocr and voting disks are placed in the diskgroups ? Can you please explain the consequences for this?

Thanks in advance..

Regards ,

Ramesh Togara.

re: Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

Bhanu — Wed, 07 Nov 2012 15:55:17 GMT

Thanks for good informaiton.

re: Oracle ASM Spfile Stored in an ASM Disk Group - How it Works ?

goran — Thu, 05 Jul 2012 20:34:01 GMT

Hi Robert,

Thanks for another good blog.

That's why is very important for 11gR2 to have always a backup of GPnP wallet, profile as well as OLR.

Further explanation which complement to your post can be found here:

aychin.wordpress.com/.../oracle-11gr2-asm-spfile-eng

regards,

goran