Oracle 11gR2 uses gpnp profile to store the spfile path of ASM

Oracle 11gR2 uses gpnp profile to store the spfile path of ASM

Since Oracle 11gR2, GI has integrated ASM, and OCR/VOTEDISK has also been stored in the ASM disk group (which must be stored on bare devices before 11gR2 ), at the same time, the functions of ASM are greatly enhanced by 10 Gb.

Let's first introduce the following question:
In 11gR2, OCR/VOTEDISK is stored in the ASM disk group, which means that the prerequisite for GI to be able to start the ASM instance smoothly and MOUNT the corresponding disk group; the ASM spfile is placed in the ASM disk group, which also means that the ASM instance must be started first and the parameter file can be read. So how can we solve this problem? Pgnp profile is introduced in 11gR2 to store the path of the ASM parameter file, which allows oracle to read the parameter file before the ASM instance starts.

In the RAC environment of 11gR2, the parameter files of ASM are stored in the ASM disk group. When the ASM instance is started, the order of the parameter files is as follows:
1. Grid Plug and Play (GPnP) profile
2. spfile + ASM <node_number>. ora
3. init + ASM <node_number>. ora

Note: The above red font section !!!

Therefore, pfile is not available in 11gR2, And the ASM parameter can be saved in gpnp profile, saving a lot of work in management.

In 11gR2RAC, the ASM parameter files support operations such as backup, copy, spmove, and gpnp profile and spget.
Note that it is best to place the ASM parameter file in the ASM magnetic group and ensure that the gpnp of each cluster member is in the same path.

 

A simple example shows how to save the spfile of ASM to the ASM disk group.

========================================================== =====

Prepare the environment

ASMCMD> ls-l
Type Redund Striped Time Sys Name
Asmparameterfile unprot coarse dec 14 15:00:00 Y registry.253.8663020.5
N spfileasm. ora => + OCR_VOTE/rac-cluster/ASMPARAMETERFILE/registry.253.8663020.5 ---- note the link here
ASMCMD> pwd
+ OCR_VOTE/rac-cluster/ASMPARAMETERFILE
ASMCMD> spcopy + OCR_VOTE/rac-cluster/ASMPARAMETERFILE/registry.253.8663020.5 + OCR_VOTE/rac-cluster/ASMPARAMETERFILE/spcopy. ora
ORA-15056: additional error message
ORA-17502: ksfdcre: 4 Failed to create file + OCR_VOTE/rac-cluster/ASMPARAMETERFILE/spcopy. ora
ORA-15268: internal Oracle file + OCR_VOTE.253.1 already exists.
ORA-06512: at line 7 (dbd error: OCIStmtExecute)
ASMCMD> spget
/Home/grid/registry.253.839197161 -- current gpnp profile configuration. This spfile is generated using the spcopy command.
ASMCMD> spmove registry.253.866308245 old_ora.bak --- deleting the default SPFILE will cause the path to be missing.
ASMCMD> ls-l
ASMCMD-8002: entry 'asmparameterfile' does not exist in directory '+ OCR_VOTE/rac-cluster /'

When the instance Environment is ready, the following solutions are available:

ASMCMD> spget
/Home/grid/registry.253.839197161
ASMCMD> spcopy/home/grid/registry.253.839197161 + OCR_VOTE/rac-cluster/ASMPARAMETERFILE/registry. ora -- copy the spfile on the local disk to the ASM Disk
ASMCMD> ls-l
Type Redund Striped Time Sys Name
Asmparameterfile unprot coarse dec 14 19:00:00 Y registry.253.866824081
N registry. ora => + OCR_VOTE/rac-cluster/ASMPARAMETERFILE/registry.253.8661_081 -- note the link here !!!!

ASMCMD> spset + OCR_VOTE/rac-cluster/ASMPARAMETERFILE/registry.253.8661_081 -- Update gpnp profile to the link
ASMCMD> spget
+ OCR_VOTE/rac-cluster/ASMPARAMETERFILE/registry.253.866824081

Restarting the instance takes effect...

ASMCMD> shutdown -- abort
ASM instance shutdown
Connected to an idle instance.
ASMCMD>
ASMCMD>
ASMCMD> startup
ASM instance started

Total System Global Area 1135747072 bytes
Fixed Size 2260728 bytes
Variable Size 1108320520 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
Mounted extern n 512 4096 1048576 4094 0 926 0 n data/
Mounted extern n 512 4096 4194304 2032 0 1592 Y OCR_VOTE/
ASMCMD> spget
+ OCR_VOTE/rac-cluster/ASMPARAMETERFILE/registry.253.866824081

SQL> show parameter spfile;

NAME TYPE
----------------------------------------------------------
VALUE
------------------------------
Spfile string
+ OCR_VOTE/rac-cluster/asmparameterfile/registry.253.866824081-it is confirmed that the instance is started through spfile in gpnp profile

Similarly, other database nodes need spset to update the spfile path. The restart takes effect. This part of the operation is omitted...

Modify the SPFILE File Location of the database in Oracle 11gR2 RAC

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Sharing pool for Oracle Performance Optimization