11.2.0.3 asm 单实例 启动报错：ORA-00099: warning: no parameter file specified for ASM instance
[20:10:03][grid@11gasm1 ~]$ crs_stat -t -v
[20:10:03]Name Type R/RA F/FT Target State Host
[20:10:03]----------------------------------------------------------------------
[20:10:03]ora.DATA.dg ora....up.type 0/5 0/ ONLINE OFFLINE
[20:10:03]ora.FRA.dg ora....up.type 0/5 0/ ONLINE OFFLINE
[20:10:03]ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE 11gasm1
[20:10:03]ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE 11gasm1
[20:10:03]ora.cssd ora.cssd.type 0/5 0/5 ONLINE ONLINE 11gasm1
[20:10:03]ora.diskmon ora....on.type 0/10 0/5 OFFLINE OFFLINE
[20:10:03]ora.evmd ora.evm.type 0/10 0/5 ONLINE ONLINE 11gasm1
[20:10:03]ora.ons ora.ons.type 0/3 0/ OFFLINE OFFLINE
[20:10:03]ora.zxy1.db ora....se.type 0/2 0/1 OFFLINE OFFLINE
[20:10:25][grid@11gasm1 ~]$ su - grid
[20:10:28]Password:
[20:10:44][grid@11gasm1 ~]$ sqlplus / as sysasm
[20:10:44]
[20:10:44]SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 16 20:10:42 2013
[20:10:44]
[20:10:44]Copyright (c) 1982, 2011, Oracle. All rights reserved.
[20:10:44]
[20:10:44]
[20:10:44]Connected to:
[20:10:44]Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
[20:10:44]With the Automatic Storage Management option
[20:10:44]
[20:10:47]SQL> startup
[20:10:47]ORA-00099: warning: no parameter file specified for ASM instance--就是没有参数文件导致的
[20:10:47]ORA-01081: cannot start already-running ORACLE - shut it down first
[20:11:27]SQL> alter diskgroup DATA mount;
[20:11:28]alter diskgroup DATA mount
[20:11:28]*
[20:11:28]ERROR at line 1:
[20:11:28]ORA-15032: not all alterations performed
[20:11:28]ORA-15017: diskgroup "DATA" cannot be mounted
[20:11:28]ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
重建参数文件：
+ASM.asm_diskgroups='DATA'
+ASM.asm_diskgroups='FRA'
*.asm_diskstring='/dev/asm-disk*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/oracle'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
通过pfile打开数据库：
20:46:25]SQL> startup pfile=/u01/app/11.2.0/grid/dbs/zxy1_+ASM.ora
[20:46:27]ASM instance started
[20:46:27]
[20:46:27]Total System Global Area 283930624 bytes
[20:46:27]Fixed Size 2227664 bytes
[20:46:27]Variable Size 256537136 bytes
[20:46:27]ASM Cache 25165824 bytes
[20:46:34]ASM diskgroups mounted
创建spfile文件：
[20:49:03]SQL> create spfile='+DATA/zxy1/spfileasm.ora' from pfile='/u01/app/11.2.0/grid/dbs/zxy1_+ASM.ora';
[20:49:06]
[20:49:06]File created.
[20:49:06]
[20:49:18]SQL> shutdown immediate
[20:49:22]ASM diskgroups dismounted
[20:49:24]ASM instance shutdown
[20:49:29]SQL> startup
[20:49:31]ASM instance started
[20:49:31]
[20:49:31]Total System Global Area 283930624 bytes
[20:49:31]Fixed Size 2227664 bytes
[20:49:31]Variable Size 256537136 bytes
[20:49:31]ASM Cache 25165824 bytes
[20:49:39]ASM diskgroups mounted
在启动成功！