11.2 how to access the environment ASM instance spfile In the ASM disk group

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.