ITPub博客

首页 > 数据库 > Oracle > 【Oracle】ORA-01078 ORA-29701 11gR2 ASM单实例重启系统后不能启动

【Oracle】ORA-01078 ORA-29701 11gR2 ASM单实例重启系统后不能启动

原创 Oracle 作者:dmcatding 时间:2016-12-06 07:52:33 0 删除 编辑

系统环境:Linux Server release 7.3

数据库环境:11.2.0.4.0


[grid@Oraclelinux ~]$sqlplus / as sysasm 启动asm实例出现下面错误信息:

SQL> startup ;
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

查看css如下:
[grid@Oraclelinux ~]$ 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
发现css没有起来

查看grid 状态

[grid@Oraclelinux ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               OFFLINE OFFLINE      oraclelinux                                  
ora.LISTENER.lsnr
               ONLINE  ONLINE       oraclelinux                                  
ora.asm
               OFFLINE OFFLINE      oraclelinux              Instance Shutdown   
ora.ons
               OFFLINE OFFLINE      oraclelinux                                  
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.beijing.db
      1        OFFLINE OFFLINE                               Instance Shutdown   
ora.cssd
      1        ONLINE  ONLINE       oraclelinux                                  
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       oraclelinux 




手动启动,如下:
[grid@Oraclelinux ~]$ crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'oraclelinux'
CRS-2672: Attempting to start 'ora.diskmon' on 'oraclelinux'
CRS-2676: Start of 'ora.diskmon' on 'oraclelinux' succeeded
CRS-2676: Start of 'ora.cssd' on 'oraclelinux' succeeded

再次手工启动ASM:
[grid@Oraclelinux ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 5 17:17:55 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 1135747072 bytes
Fixed Size    2260728 bytes
Variable Size 1108320520 bytes
ASM Cache   25165824 bytes
ASM diskgroups mounted

再次检查GRID 状态
[grid@Oraclelinux ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       oraclelinux                                  
ora.LISTENER.lsnr
               ONLINE  ONLINE       oraclelinux                                  
ora.asm
               ONLINE  ONLINE       oraclelinux              Started             
ora.ons
               OFFLINE OFFLINE      oraclelinux                                  
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.beijing.db
      1        OFFLINE OFFLINE                               Instance Shutdown   
ora.cssd
      1        ONLINE  ONLINE       oraclelinux                                  
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       oraclelinux

设置CSS 为自启动
[grid@Oraclelinux ~]$ crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
[grid@Oraclelinux ~]$ 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


重启系统,再次检查ASM 可以自启动了。

OK 完成

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

请登录后发表评论 登录
全部评论

注册时间:2015-07-04

  • 博文量
    48
  • 访问量
    49380