ITPub博客

首页 > 数据库 > Oracle > ORA-01078 ORA-29701 11gr2 asm 单实例重启系统后不能启动

ORA-01078 ORA-29701 11gr2 asm 单实例重启系统后不能启动

Oracle 作者:lovestanford 时间:2014-01-24 11:21:34 0 删除 编辑

使用 sqlplus / as sysasm 启动asm实例出现下面错误信息:
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

[root@asmtest ~]# /etc/init.d/oracleasm start
Initializing the Oracle ASMLib driver: [  OK  ]
Scanning the system for Oracle ASMLib disks: [  OK  ]


[grid@asmtest ~]$ sqlplus  / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 30 00:41:21 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


 
查看css如下:
css
[grid@asmtest ~]$ 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

diskmon:

[grid@asmtest ~]$ 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都没有自动启动


手工启动css,启动过程diskmon也被拉起,如下:

[grid@asmtest ~]$ crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'asmtest'
CRS-2679: Attempting to clean 'ora.diskmon' on 'asmtest'
CRS-2681: Clean of 'ora.diskmon' on 'asmtest' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'asmtest'
CRS-2676: Start of 'ora.diskmon' on 'asmtest' succeeded
CRS-2676: Start of 'ora.cssd' on 'asmtest' succeeded


查看css状态:

[grid@asmtest ~]$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE              
ora....ER.lsnr ora....er.type ONLINE    ONLINE    asmtest    
ora.asm        ora.asm.type   OFFLINE   OFFLINE              
ora....tand.db ora....se.type OFFLINE   OFFLINE              
ora.cssd       ora.cssd.type  ONLINE    ONLINE    asmtest    
ora.diskmon    ora....on.type ONLINE    ONLINE    asmtest    

 

再次手工启动asm:
[grid@asmtest ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 30 00:50:24 2012

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size                  2212656 bytes
Variable Size             256552144 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted


将css 和diskmon设置为自启动:
crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"


[grid@asmtest ~]$ 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

[grid@asmtest ~]$ crs_stat -p ora.diskmon
NAME=ora.diskmon
TYPE=ora.diskmon.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=1
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

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

上一篇: /etc/hosts
请登录后发表评论 登录
全部评论

注册时间:2012-09-27

  • 博文量
    213
  • 访问量
    974287