系統環境：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 完成

【Oracle】ORA-01078 ORA-29701 11gR2 ASM單例項重啟系統後不能啟動

相關文章