ORA-01078 ORA-29701 11g單機asm系統啟動後不能啟動asm

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