oracle 11g R2 单实例 ASM 启动：ORA

今天启动之前安装好的 oracle 11g r2 单实例 asm的时候，连接启动asm实例时，报错： SQL startup ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service 从报错说.应该是CSS服务没有启动起

今天启动之前安装好的 oracle 11g r2 单实例 asm的时候，连接启动asm实例时，报错：

SQL> startup

ORA-29701: unable to connect to Cluster Synchronization Service

绘蛙AI商品图

电商场景的AI创作平台，无需高薪聘请商拍和文案团队，使用绘蛙即可低成本、批量创作优质的商拍图、种草文案

148

查看详情

从报错说.应该是CSS服务没有启动起来，查看CSS服务情况

[grid@linusfay-up ~]$ sudo crs_stat -t
[sudo] password for grid:
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.BACKUP.dg  ora....up.type OFFLINE   OFFLINE               
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE               
ora....EMDG.dg ora....up.type OFFLINE   OFFLINE               
ora.asm        ora.asm.type   OFFLINE   OFFLINE               
ora.cssd       ora.cssd.type  ONLINE    OFFLINE               
ora.diskmon    ora....on.type OFFLINE   OFFLINE               
ora.evmd       ora.evm.type   ONLINE    OFFLINE               
ora.ons        ora.ons.type   OFFLINE   OFFLINE               
ora.orcl.db    ora....se.type OFFLINE   OFFLINE 

尝试手动启动css

[grid@linusfay-up ~]$ sudo crs_start ora.cssd
Attempting to start `ora.cssd` on member `linusfay-up`
Attempting to start `ora.diskmon` on member `linusfay-up`
Start of `ora.diskmon` on member `linusfay-up` succeeded.
Start of `ora.cssd` on member `linusfay-up` succeeded.

启动成功

尝试连接启动ASM实例

[grid@linusfay-up ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 26 15:47:40 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size                  2227664 bytes
Variable Size             256537136 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

连接 启动成功！

为什么在主机重启后，CSS服务没有随着主机重启而restart呢

查看设置：

[grid@linusfay-up ~]$ sudo crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m

下面将AUTO_START属性的可选值列以下：

AUTO_START

Indicates whether Oracle Clusterware automatically starts a resource after a cluster server restart.Valid AUTO_START values are:

• always: Restarts the resource when the server restarts regardless of the state of the resource when the server stopped.--始终restart
• restore: Restores the resource to the same state  that it was in when the server stopped.Oracle Clusterware attempts to restart the resource if the value of TARGET was ONLINE before the server stopped. --根据关闭前一次状态是否选择启动
  
• never: Oracle Clusterware never restarts the resource regardless of the state of the resource when the server stopped.

tips

      1)默认情况下HAS(High Availability Service)是自动启动的.通过如下命令可以取消和启用自动启动
        crsctl disable has
        crsctl enable has
      2)HAS手动启动和停止
        crsctl start has
        crsctl stop has
      3)查看HAS的状态
        crsctl check has
      4)如果想让ora.css和ora.diskmon服务随着HAS的启动而自动启动，那么你可以这两个服务的AUTO_START属性
        crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
        or
        crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
      5)如果想取消ora.css和ora.diskmon的Auto start
        crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
        crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"