ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01078 ORA-29701 11g单机asm系统启动后不能启动asm

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

原创 Linux操作系统 作者:安佰胜 时间:2012-01-05 11:01:49 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13177610/viewspace-714456/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 11g单机使用asm
请登录后发表评论 登录
全部评论

注册时间:2009-08-26

  • 博文量
    215
  • 访问量
    607392