ASM实例的参数出了错,导致CRS资源无法启动,下面是修复的记录
asmpfile.ora内容如下(此文件是我刚创建完数据库未做任何修改时的备份,可以vi直接粘贴创建):
+ASM1.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
+ASM2.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
*.asm_diskgroups='DATA','FRA'#Manual Mount
*.asm_diskstring='/u01/asm-disk'
*.asm_power_limit=1
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
[grid@rac1 trace]$ crsctl stat res -t
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.
[grid@rac1 trace]$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 16 08:26:28 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/tmp/asmpfile.ora'
ASM instance started
Total System Global Area 1140850688 bytes
Fixed Size 2933400 bytes
Variable Size 1112751464 bytes
ASM Cache 25165824 bytes
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> startup nomount pfile='/tmp/asmpfile.ora'
ASM instance started
Total System Global Area 1140850688 bytes
Fixed Size 2933400 bytes
Variable Size 1112751464 bytes
ASM Cache 25165824 bytes
SQL> create spfile from pfile='/tmp/asmpfile.ora';
create spfile from pfile='/tmp/asmpfile.ora'
*
ERROR at line 1:
ORA-17635: failure in obtaining physical sector size for
'+OCR/rac-cluster/ASMPARAMETERFILE/registry.253.930666537'
ORA-15001: diskgroup "OCR" does not exist or is not mounted
SQL> create spfile='/tmp/asmpfile1.ora' from pfile='/tmp/asmpfile.ora';
File created.
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 1140850688 bytes
Fixed Size 2933400 bytes
Variable Size 1112751464 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> create spfile from pfile='/tmp/asmpfile.ora';
create spfile from pfile='/tmp/asmpfile.ora'
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance
SQL> create spfile='+OCR' from pfile='/tmp/asmpfile.ora';
File created.
SQL> shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 1140850688 bytes
Fixed Size 2933400 bytes
Variable Size 1112751464 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@rac1 trace]$
做完后重启一下crs,然后资源就能起来了