【Oracle】ORA-01078 ORA-29701 11gR2 ASM单实例重启系统后不能启动
系统环境：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博客 ” ，链接：https://blog.itpub.net/30327022/viewspace-2129798/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
