linux 11Gasm启动crs,ORA-01078 ORA-29701 11g单机asm系统启动后不能启动asm

ORA-01078 ORA-29701 11g单机asm系统启动后不能启动asm

===========================

--昨天搭的11g单机asm

--os 关闭之后重新启动后启动asm报错

--如下：

[root@localhost init.d]# su - grid

-bash-3.2$ sqlplus  / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 10:44:42 2012

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

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

ORA-29701: unable to connect to Cluster Synchronization Service

SQL>

--报错css没有启动

--使用crs_stat命令查看css状态

--发现AUTO_START=never

--也就是说其实css还没有设定为自动启动

--又查看了diskmon，也同样是不自动启动

-bash-3.2$ 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

-bash-3.2$ crs_stat -p ora.diskmon

NAME=ora.diskmon

TYPE=ora.diskmon.type

ACTION_SCRIPT=

ACTIVE_PLACEMENT=0

AUTO_START=never

CHECK_INTERVAL=20

DESCRIPTION="Resource type for Diskmon"

FAILOVER_DELAY=0

FAILURE_INTERVAL=3

FAILURE_THRESHOLD=5

HOSTING_MEMBERS=

PLACEMENT=balanced

RESTART_ATTEMPTS=10

SCRIPT_TIMEOUT=60

START_TIMEOUT=60

STOP_TIMEOUT=60

UPTIME_THRESHOLD=5s

--手动启动css

--启动过程中diskmon被一起拉起来

--启动后查询集群资源状况如下：

-bash-3.2$ crsctl start resource ora.cssd

CRS-2672: Attempting to start 'ora.cssd' on 'localhost'

CRS-2679: Attempting to clean 'ora.diskmon' on 'localhost'

CRS-2681: Clean of 'ora.diskmon' on 'localhost' succeeded

CRS-2672: Attempting to start 'ora.diskmon' on 'localhost'

CRS-2676: Start of 'ora.diskmon' on 'localhost' succeeded

CRS-2676: Start of 'ora.cssd' on 'localhost' succeeded

-bash-3.2$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.DATA.dg    ora....up.type OFFLINE   OFFLINE

ora....ER.lsnr ora....er.type ONLINE    ONLINE    localhost

ora.asm        ora.asm.type   OFFLINE   OFFLINE

ora.cssd       ora.cssd.type  ONLINE    ONLINE    localhost

ora.db11.db    ora....se.type OFFLINE   OFFLINE

ora.diskmon    ora....on.type ONLINE    ONLINE    localhost

--再次手动启动asm

--成功，之后启动数据库顺利

-bash-3.2$ sqlplus  / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 10:48:16 2012

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

Connected to an idle instance.

SQL> startup

ASM instance started

Total System Global Area  284565504 bytes

Fixed Size                  1336036 bytes

Variable Size             258063644 bytes

ASM Cache                  25165824 bytes

ASM diskgroups mounted

SQL>

--其他相关服务

--has默认是自动启动的

--手动启停命令如下

--查看状态

crsctl check has

--关启自动启停

crsctl disable has

crsctl enable has

--手动启停

crsctl start has

crsctl stop has

--css和diskmon可以设置为自动启动

--开启css和diskmon自动启动

crsctl modify resource "ora.cssd" -attr "AUTO_START=1"

crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"

--关闭css和diskmon自动启动

crsctl modify resource "ora.cssd" -attr "AUTO_START=never"

crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"

--设置自动启动css后资源状态

-bash-3.2$ crsctl modify resource "ora.cssd" -attr "AUTO_START=1"

-bash-3.2$ crs_stat -p ora.cssd

NAME=ora.cssd

TYPE=ora.cssd.type

ACTION_SCRIPT=

ACTIVE_PLACEMENT=0

AUTO_START=1

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