背景：本版本：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
