由于某种原因导致HAS服务无法启动,进而到时ASM实例瘫痪,处理这种问题,最简单直接的方法是,重新创建HAS。
[grid@addb~]$ crsctl stat res -t
CRS-4639:Could not contact Oracle High Availability Services
CRS-4000:Command Status failed, or completed with errors.
[grid@addb~]$ crsctl start has
CLSU-00105:Operating System interface has reported an internal failure
CLSU-00103:error location: scrcreate5
CLSU-00104:additional error information: need ha priv
CRS-4000:Command Start failed, or completed with errors.
删除之前的has的配置:
[grid@addbinstall]$ su - root
Password:
[root@addb~]# cd /u01/app/12.1.0/grid/crs/install/
[root@addbinstall]# ./roothas.pl -deconfig -verbose
Usingconfiguration parameter file: ./crsconfig_params
PRKO-2573: ONS daemon is already stopped.
CRS-2673:Attempting to stop 'ora.cssd' on 'addb'
CRS-2677:Stop of 'ora.cssd' on 'addb' succeeded
CRS-2730:Resource 'ora.asm' depends on resource 'ora.cssd'
CRS-4000:Command Delete failed, or completed with errors.
CRS-2791:Starting shutdown of Oracle High Availability Services-managed resources on'addb'
CRS-2673:Attempting to stop 'ora.evmd' on 'addb'
CRS-2677:Stop of 'ora.evmd' on 'addb' succeeded
CRS-2793:Shutdown of Oracle High Availability Services-managed resources on 'addb' hascompleted
CRS-4133:Oracle High Availability Services has been stopped.
2015/07/2413:27:45 CLSRSC-337: Successfully deconfigured Oracle Restart stack
重新配置has
[root@addbinstall]# ./roothas.pl
Usingconfiguration parameter file: ./crsconfig_params
2015/07/2413:27:51 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADDMODE
CreatingOCR keys for user 'grid', privgrp 'oinstall'..
Operationsuccessful.
LOCALONLY MODE
Successfullyaccumulated necessary OCR keys.
CreatingOCR keys for user 'root', privgrp 'root'..
Operationsuccessful.
CRS-4664:Node addb successfully pinned.
2015/07/2413:27:55 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'
addb 2015/07/24 13:28:23 /u01/app/12.1.0/grid/cdata/addb/backup_20150724_132823.olr
CRS-2791:Starting shutdown of Oracle High Availability Services-managed resources on'addb'
CRS-2673:Attempting to stop 'ora.evmd' on 'addb'
CRS-2677:Stop of 'ora.evmd' on 'addb' succeeded
CRS-2793:Shutdown of Oracle High Availability Services-managed resources on 'addb' hascompleted
CRS-4133:Oracle High Availability Services has been stopped.
CRS-4123:Oracle High Availability Services has been started.
2015/07/2413:28:55 CLSRSC-327: Successfully configured Oracle Grid Infrastructure for aStandalone Server
重新配置HAS之后发现,asm实例无法自启动了,cssd服务也停掉了,更不用说磁盘组了。所以要进行如下设置。
[grid@addb~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server Statedetails
--------------------------------------------------------------------------------
LocalResources
--------------------------------------------------------------------------------
ora.ons
OFFLINE OFFLINE addb STABLE
--------------------------------------------------------------------------------
ClusterResources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE addb STABLE
--------------------------------------------------------------------------------
设置ora.cssd自动启动,并将ASM添加到has stack中,设置原先的spfile。
[grid@addb~]$ crsctl modify res ora.cssd -attr AUTO_START=1
[grid@addb~]$ crsctl modify res ora.diskmon -attr AUTO_START=1
[grid@addb~]$ srvctl add asm -p +DG_SYS/ASM/ASMPARAMETERFILE/registry.253.885909531
查看是否设置成功
[grid@addb ~]$crsctl stat res ora.cssd -p -init
NAME=ora.cssd
TYPE=ora.cssd.type
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r--
ACTIONS=
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTION_TIMEOUT=60
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/cssdagent%CRS_EXE_SUFFIX%
AGENT_HB_INTERVAL=0
AGENT_HB_MISCOUNT=10
ALERT_TEMPLATE=
ALIAS_NAME=
AUTO_START=1
CARDINALITY=1
使用pfile启动实例,将实际spfile文件加载到stack中。
[grid@addb~]$ sqlplus / as sysasm
SQL*Plus:Release 12.1.0.1.0 Production on Fri Jul 24 13:48:14 2015
Copyright(c) 1982, 2013, Oracle. All rightsreserved.
Connectedto an idle instance.
SQL>startup pfile=$ORACLE_HOME/dbs/init+ASM.ora
ASMinstance started
TotalSystem Global Area 1135747072 bytes
FixedSize 2859520 bytes
VariableSize 1107721728 bytes
ASMCache 25165824 bytes
ASMdiskgroups mounted
SQL>show parameter spfile
NAME TYPE VALUE
----------------------------------------------- ------------------------------
spfile string
SQL>shutdown
ASMdiskgroups dismounted
ASMinstance shutdown
重启启动has后,oracle restart通过stack中的spfile自动启动ASM。
[grid@addb ~]$crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server Statedetails
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE addb STABLE
ora.DG_SYS.dg
ONLINE ONLINE addb STABLE
ora.asm
ONLINE ONLINE addb Started,STABLE
ora.ons
OFFLINE OFFLINE addb STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE addb STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE addb STABLE
--------------------------------------------------------------------------------
SQL> showparameter spfile
NAME TYPE VALUE
----------------------------------------------- ------------------------------
spfile string +DG_SYS/ASM/ASMPARAMETERFILE/r
egistry.253.885909531