12c ASM实例的参数有问题导致无法启动

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,然后资源就能起来了


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值