Oracle 11GR2 uses GPNP profile to store ASM's SPFile path

Starting with Oracle 11GR2, GI integrated Asm,ocr/votedisk is also housed in ASM disk groups (11GR2 previously needed to be stored in bare devices), and ASM has a much greater capability than 10g.

Let's first introduce a problem: in 11gr2, Ocr/votedisk is stored in ASM Disk group, which means that the GI can start with the ability to start the ASM instance smoothly and can mount the corresponding disk group, while the ASM SPFile is placed in the ASM disk group, This also means that the ASM instance is started and can read the parameter file. So how do we solve this problem? The PGNP profile is introduced in 11GR2 to store the ASM parameter file path, which allows Oracle to read the parameter file before the ASM instance starts.

In a 11GR2 RAC environment, ASM's parameter files are stored in the ASM Disk group. When the ASM instance starts, look for the parameter file in the following order, which is directly found:

1. Grid Plug and Play (GPNP) profile

2. Spfile+asm<node_number>.ora

3. Init+asm<node_number>.ora

Please note: The above red font section!!!

Therefore, there can be no pfile in 11gr2, and the ASM parameters can be saved in GPNP profile, which saves a lot of work on management.

11GR2RAC environment, ASM parameter Files support Backup (spbackup), copy (spcopy), Move (spmove), Query Gpnp profile (Spget), set (Spset), etc. ASM's parameter files are best placed in the ASM Magnetic group while ensuring that each cluster member's GPNP is the same path

A simple example of how to re-save ASM spfile to ASM disk groups

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

Prepare the Environment

Asmcmd> ls-l

Type redund striped Time Sys Name

Asmparameterfile Unprot Coarse DEC 15:00:00 Y registry.253.866303695

N Spfileasm.ora = +ocr_vote/rac-cluster/asmparameterfile/registry.253.866303695----Note Here is the link

asmcmd> pwd

+ocr_vote/rac-cluster/asmparameterfile

asmcmd> spcopy +ocr_vote/rac-cluster/asmparameterfile/registry.253.866303695 +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. The spfile is generated using the Spcopy command.

asmcmd> spmove registry.253.866303695 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/'

Instance environment is ready, here are the workarounds:

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 19:00:00 Y registry.253.866316081

N

Registry.ora = +ocr_vote/rac-cluster/asmparameterfile/registry.253.866316081--Note that this is a link!!!!

Asmcmd>spset +ocr_vote/rac-cluster/asmparameterfile/registry.253.866316081--Update GPNP profile to link

Asmcmd> Spget

+ocr_vote/rac-cluster/asmparameterfile/registry.253.866316081

Restart instance in 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_f Iles Name

Mounted EXTERN N 512 4096 1048576 4094 926 0 926 0 N data/

Mounted EXTERN N 512 4096 4194304 2032 1592 0 1592 0 Y ocr_vote/

Asmcmd> Spget

+ocr_vote/rac-cluster/asmparameterfile/registry.253.866316081

Sql> Show parameter SPFile;

NAME TYPE

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

VALUE

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

SPFile string

+ocr_vote/rac-cluster/asmparameterfile/registry.253.866316081-Confirmed by GPNP profile SPFile Launch instance

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

Modify the SPFile file location of the database in the Oracle 11gR2 RAC http://www.linuxidc.com/Linux/2012-09/70718.htm

Install Oracle 11gR2 (x64) http://www.linuxidc.com/Linux/2014-02/97374.htm under CentOS 6.4

Oracle 11gR2 installation steps in VMware virtual machines http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Install Oracle 11g XE r2http://www.linuxidc.com/linux/2014-03/98881.htm under Debian

Oracle performance optimized shared pool http://www.linuxidc.com/Linux/2012-02/54062.htm

See Oracle Feature page for more information on Oracle HTTP://WWW.LINUXIDC.COM/TOPICNEWS.ASPX?TID=12

This article permanently updates the link address: http://www.linuxidc.com/Linux/2015-01/112535.htm

Oracle 11GR2 uses GPNP profile to store ASM's SPFile path