On the ASM instance of 11.2, execute show parameter spfile:
[Grid @ rac1 ~] $ Sqlplus/as sysasm
SQL * Plus: Release 11.2.0.1.0 Production on Sun MAY 11 15:56:12 2014
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Automatic Storage Management option
SQL> show parameter spfile
NAME TYPE VALUE
-----------------------------------------------------------------------------
Spfile string + DATA/asm/asmparameterfile/registry.253.704991445
The spfile is in the ASM disk group. However, unlike earlier versions, spfile is not located in the $ ORACLE_HOME/dbs directory.
[Grid @ rac1 ~] $ Ls $ ORACLE_HOME/dbs
AB _ + ASM. dat
Hc _ + ASM. dat
Init. ora
Orapw + ASM
Peshm _ + ASM_1
How does the ASM instance know the specific position of its spfile?
The answer is through a local registry ".
Oracle's Grid Infastructure uses this "local registry" to record all local controllable resources.
The "local registry" is located in the/etc/oracle/olr. loc file. Check the olrconfig_loc variable:
[Grid @ rac1 ~] $ Cat/etc/oracle/olr. loc
Olrconfig_loc =/u01/app/grid/product/11.2.0/grid/cdata/localhost/rac1.olr
Crs_home =/u01/app/grid/product/11.2.0/grid
View the "local registry" content:
[Grid @ rac1 ~] $ Ocrdump-local-xml
[Grid @ rac1 ~] $ Grep-I spfile OCRDUMPFILE
Another spfile setting error causes the database to fail to start.
Pfile parameter of Oracle oradim
How to copy data files in ASM to the Operating System
Restoration After all Oracle 11g rac asm disks are lost
Oracle 11g from entry to proficient in PDF + CD source code
Installing Oracle 11g R2 using RHEL6 ASM
Oracle 10g manual creation of the ASM Database