ORA-01078 ORA-29701 11gr2 asm 單例項重啟系統後不能啟動
使用 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【Oracle】ORA-01078 ORA-29701 11gR2 ASM單例項重啟系統後不能啟動OracleASM單例
- ORA-01078 ORA-29701 11g單機asm系統啟動後不能啟動asmASM
- 11gR2啟動ASM例項時遭遇ORA-29701ASM
- 【轉】11gR2啟動ASM例項時遭遇ORA-29701ASM
- 11gR2啟動ASM例項時遭遇ORA-29701, cssd dismon ohasASMCSS
- oracle 11gR2 asm例項 不能啟動處理方法OracleASM
- 啟動ASM例項出現ORA-29701錯誤ASM
- 安裝GI後重啟作業系統後啟動ASM例項失敗及解決方法作業系統ASM
- ASM例項啟動報錯:ORA-29701 :unable to connect to Cluster ManagerASM
- 配置單例項自動重啟單例
- 系統重啟後卷不能自動掛載
- Oracle單例項+ASM啟動與關閉Oracle單例ASM
- 啟動ASM 例項報錯ASM
- 配置Oracle單例項隨機啟動(11gR2)Oracle單例隨機
- 由AIX系統故障導致系統重啟,使Oracle資料庫自動啟動例項AIOracle資料庫
- 驗證11gR2 RAC中ASM例項通過gpnp profile獲得spfile資訊來啟動ASM例項ASM
- ASM CRS 例項啟動和關閉ASM
- Windows下Oracle 11gR2例項啟動WindowsOracle
- 11gR2 RAC ASM 啟動ASM
- 啟動CRS單例項、設定自動啟動單例
- 11.2單例項ASM啟動報錯ORA-15186單例ASM
- ORACLE 11gR2 單例項資料庫自啟Oracle單例資料庫
- ORA-29701--10g 單機asm不能啟動ASM
- 11gR2 RAC ASM啟動過程ASM
- Flex ASM自動重定位ASM例項測試FlexASM
- redhat as 4.0系統啟動到一半不能啟動!Redhat
- 安裝win10系統後重啟不能正常進入系統如何解決Win10
- 重啟系統後AUTOTRACE統計為零
- 配置作業系統重啟後,Oracle資料庫和監聽自動啟動作業系統Oracle資料庫
- 單例項刪除ASM例項單例ASM
- Oracle 10g RAC 系統 OS啟動時CRS及例項自動啟動指令碼Oracle 10g指令碼
- redhat 6.5 oracle 11.2.0.4 gi oracle asm在作業系統重啟cssd程式無法自動重啟簡析RedhatOracleASM作業系統CSS
- SAP系統不能啟動時的對應
- ASM單例項安裝後,需要手動設定ASM的引數檔案ASM單例
- 使用SRVCTL啟動例項與使用sqlplus啟動例項的區別SQL
- 【SHELL】Linux系統 Oracle例項監控、重啟 簡易Shell指令碼LinuxOracle指令碼
- 修改系統時間導致RAC環境的一個例項重啟
- Oracle之 服務啟動&停止指令碼與開機自啟動(單例項)Oracle指令碼單例