ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to start up the ASM instance when the spfile is misconstrued or lost ?

How to start up the ASM instance when the spfile is misconstrued or lost ?

原创 Linux操作系统 作者:spider0283 时间:2011-08-29 20:07:50 0 删除 编辑

[ID 1313657.1]
修改时间
11-AUG-2011     类型 PROBLEM     状态 MODERATED
 

In this Document
  Symptoms
  Cause
  Solution


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.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.
The CRS and the ASM instance can not start because the spfile is misconstrued or lost

Symptoms

The CRS and the ASM instance can not start up because the spfile is misconstrued or lost

- Start the ASM instance fail with error

SQL> startup;
ORA-00099: warning: no parameter file specified for ASM instance
ORA-00304: requested INSTANCE_NUMBER is busy

- Start up the CRS services fail with error

# crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors

- Checked the gpnp profile and found that it refer to spfile which is not exist in the ASM (or shared storage)


For example :
$ cat /u01/app/11.2.0/grid/gpnp/gps-rac2/profiles/peer/profile.xml

Cause

- In our case the spfile indicated in the gpnp profile was not found in the ASM diskgroup

cat /u01/app/11.2.0/grid/gpnp/gps-rac2/profiles/peer/profile.xml

- In general to be able to start up the CRS properly
  There should be a proper pfile or spfile to let the ASM instance startup
  and/or
  The gpnp profile should indicate to a proper spfile

Solution

1- Create a new ASM pfile
ora_+ASM1.ora
+ASM1.asm_diskgroups='DATA','FRA'#Manual Mount
+ASM2.asm_diskgroups='DATA','FRA'#Manual Mount
*.asm_diskstring='/dev/rdsk/emcpower*'
*.asm_power_limit=1
*.diagnostic_dest='/mnt/crs/oracle'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

2- Start up the ASM instance
on the first node

$ export $ORACLE_SID=
$ export $ORACLE_HOME=

$ sqlplus / as sysasm

sql> startup pfile=


The asm instance shall start up properly

3- Check if the ASM diskgroups are mounted properly or not

sql> select name , state from v$asm_diskgroup


4- Create the spfile

sql> create spfile='+DATA/../spfileasm.ora' from pfile='

5- In the gpnp profile we shall find that the spfile information set properly there

cat /u01/app/11.2.0/grid/gpnp/gps-rac2/profiles/peer/profile.xml

6- We need to stop and startup the CRS to make sure that the ASM and the CRS stack startup automatically without any issues


显示相关信息 相关的


产品
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
ASM; CRS; CRSCTL; GRID; PFILE; PROFILE; SPFILE; STARTUP
错误
ORA-99; ORA-304; CRS-4000; CRS-4640

返回页首返回页首

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38267/viewspace-706164/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-29

  • 博文量
    194
  • 访问量
    627813