Oracle中没有spfile,记 一次Oracle数据库集群ASM没有spfile情况

背景：本版本：Oracle rac 11.2.0.4 运行状态正常。

问题起因：想要修改集群心跳时间参数_asm_hbeatiowait，发现无法修改ASM的，原因是没有spfile；

现象：

SQL> show parameter spfile

NAME TYPE VALUE

spfile string

SQL>

SQL> create pfile from spfile;

create pfile from spfile

*

ERROR at line 1:

ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

SQL> alter system set “_asm_hbeatiowait”=120 scope=spfile sid=’’;

alter system set “_asm_hbeatiowait”=120 scope=spfile sid=’’

*

ERROR at line 1:

ORA-32001: write to SPFILE requested but no SPFILE is in use

解决方式：

1、 手动创建pfile

[grid@rac1 ~]$ cd /u01/app/11.2.0.4/grid/dbs/

vi init+ASM1.ora

._asm_hbeatiowait=120

+ASM1.asm_diskgroups=‘DATANEW’#Manual Mount

+ASM2.asm_diskgroups=‘DATANEW’#Manual Mount

.asm_diskstring=’/dev/raw/,/dev/rac1’

*.asm_power_limit=1

*.diagnostic_dest=’/u01/app/oracle’

*.instance_type=‘asm’

*.large_pool_size=12M

*.remote_login_passwordfile=‘EXCLUSIVE’

2、由pfile 创建spfile

[grid@rac1 ~]$ sqlplus / as sysasm

SQL> create spfile=’+OCRVOTE’ from pfile;

File created.

3、查看验证

[grid@rac1 ~]$ asmcmd -p

ASMCMD [+ocrvote/rac-cluster] > spget

+OCRVOTE/rac-cluster/asmparameterfile/registry.253.1038244795

4、查看参数

/u01/app/11.2.0.4/grid/gpnp/rac1/profiles/peer/profile.xml

[grid@rac1 ~]$ cat /u01/app/11.2.0.4/grid/gpnp/rac1/profiles/peer/profile.xml

ASM-Profile id=“asm” DiscoveryString="/dev/raw/*" SPFile="+OCRVOTE/rac-cluster/asmparameterfile/registry.253.1038244795"/

5、重新启动 ASM 验证

[oracle@rac1 /]# srvctl stop asm -n rac1 -f

6、启动asm

[grid@rac1 ~]$ sqlplus / as sysasm

SQL> startup

7.另一个节点，重启ASM