ASM Spfile Is Not Used when ASM Instance Starts

ygzhou518發表於2011-12-19
ASM
ASM Spfile Is Not Used when ASM Instance Starts Even It Exists Inside of OCR Diskgroup (11.2) [ID 1384692.1]
  Modified 18-DEC-2011     Type PROBLEM     Status MODERATED  

In this Document
  Cause
  References

     This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Even ASM instance starts automatically and a apfile exist inside of OCR DiskGroup, spfile parameter shows nothing:
SQL> show parameter spfile

NAME                       TYPE        VALUE
-------------------------- ----------- ----------------spfile                     string

Cause

SPFILE is not visible in ASM instance (show parameter pfile) because ASM starts without using it.
Based on Oracle documentation, when an Oracle ASM instance searches for an initialization parameter file, the search order is:
1. The location of the initialization parameter file specified in the GridPlug and Play (GPnP) profile
2. If the location has not been set in the GPnP profile, then the search order changes to:
- SPFILE in the Oracle ASM instance home
 $ORACLE_HOME/dbs/spfile+ASM.ora
- PFILE in the Oracle ASM instance home

One of the reason why ASM not able to find the SPFILE could be because of "ERROR: -5(Duplicate disk OCR_VOTE:OCR_VOTE_0001)" and ASM is using default parameter settings.
NOTE: No asm libraries found in the system
ERROR: -5(Duplicate disk OCR_VOTE:OCR_VOTE_0001) * instance_number obtained from CSS = 1, checking for the existence of node 0...
* node 0 does not exist. instance_number = 1
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Private Interface ... configured from GPnP for use as a private interconnect.
...
Public Interface ... configured from GPnP for use as a public interface.
...
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/11.2.0/grid/dbs/arch
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
NOTE: Volume support enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options.
WARNING: using default parameter settings without any parameter file

Solution


To fix next error:
ERROR: -5(Duplicate disk OCR_VOTE:OCR_VOTE_0001)

you have to check ASM disks permissions and also if disks are visible twice by ASM instance.

References

NOTE:1274309.1 - CSSD Crash with clssnmvDiskKillCheck: Aborting, killed by install operation

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24867586/viewspace-713540/，如需轉載，請註明出處，否則將追究法律責任。

相關文章