11gR2啟動ASM例項時遭遇ORA-29701
早上啟動asm 報錯，馬上google 發現這個好東東，儲存下前輩的成功，呵呵
原文地址:http://tomszrp.itpub.net/post/11835/493005
[grid@vm11gr2] /home/grid> sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:16:21 2009
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服務上.到作業系統上檢查一下看看
[grid@vm11gr2] /home/grid> crsctl check css
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
[grid@vm11gr2] /home/grid>
[grid@vm11gr2] /home/grid> ps -ef|grep cssd
果然沒有CSS的服務daemon程式,再看一下HAS(High Availability Service)的狀態
[grid@vm11gr2] /home/grid> crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@vm11gr2] /home/grid> ps -ef|grep d.bin
grid 5886 1 0 10:06 ? 00:00:01 /u01/app/grid/product/11.2/grid/bin/ohasd.bin reboot
[grid@vm11gr2] /home/grid>
發現HAS的服務確實啟動了的,而ora.cssd和ora.diskmon這2個服務是依賴於HAS維護的.
進一步檢視各資源的狀態
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.asm ora.asm.type OFFLINE OFFLINE vm11gr2
ora.cssd ora.cssd.type OFFLINE OFFLINE vm11gr2
ora.diskmon ora.diskmon.type OFFLINE OFFLINE vm11gr2
[grid@vm11gr2] /home/grid>
[grid@vm11gr2] /home/grid> crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_ DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FLASH_DATA.dg
OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg
OFFLINE OFFLINE vm11gr2
ora.asm
OFFLINE OFFLINE vm11gr2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
再看一下ora.cssd和ora.diskmon的屬性
[grid@vm11gr2] /home/grid> 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
[grid@vm11gr2] /home/grid> 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
[grid@vm11gr2] /home/grid>
到這裡基本就找到了原因了,可以看到這兩個資源的AUTO_START屬性預設都設定為never,也就是說他們不會隨著HAS服務的啟動而自動啟動的,
儘管預設情況下HAS服務是開機自動啟動的.好了，那我們就手動啟動一下吧:
[grid@vm11gr2] /home/grid> crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'vm11gr2'
CRS-2679: Attempting to clean 'ora.diskmon' on 'vm11gr2'
CRS-2681: Clean of 'ora.diskmon' on 'vm11gr2' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'vm11gr2'
CRS-2676: Start of 'ora.diskmon' on 'vm11gr2' succeeded
CRS-2676: Start of 'ora.cssd' on 'vm11gr2' succeeded
[grid@vm11gr2] /home/grid>
注:ora.cssd和ora.diskmon這兩個服務是有依賴關係的，啟動哪個都會把兩個都起來.
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
ora.asm ora.asm.type OFFLINE OFFLINE vm11gr2
ora.cssd ora.cssd.type ONLINE ONLINE vm11gr2
ora.diskmon ora.diskmon.type ONLINE ONLINE vm11gr2
[grid@vm11gr2] /home/grid>
CSS服務起來了，重啟動asm instance
[grid@vm11gr2] /home/grid> sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:30:03 2009
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> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
[grid@vm11gr2] /home/grid> crs_stat -t
Name Type Target State Host
--------------------------------------------------------------
ora.FLASH_DATA.dg ora.diskgroup.type ONLINE ONLINE vm11gr2
ora.SYS_DATA.dg ora.diskgroup.type ONLINE ONLINE vm11gr2
ora.asm ora.asm.type ONLINE ONLINE vm11gr2
ora.cssd ora.cssd.type ONLINE ONLINE vm11gr2
ora.diskmon ora.diskmon.type ONLINE ONLINE vm11gr2
[grid@vm11gr2] /home/grid>
tips
1)預設情況下HAS(High Availability Service)是自動啟動的.通過如下命令可以取消和啟用自動啟動
crsctl disable has
crsctl enable has
2)HAS手動啟動和停止
crsctl start has
crsctl stop has
3)檢視HAS的狀態
crsctl check has
4)如果想讓ora.css和ora.diskmon服務隨著HAS的啟動而自動啟動，那麼你可以這兩個服務的AUTO_START屬性
crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
or
crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
5)如果想取消ora.css和ora.diskmon的Auto start
crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12457158/viewspace-689349/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20191128]11GR2 asm例項audit檔案.txtASM
- Oracle 11gR2 ASM例項記憶體管理OracleASM記憶體
- 3.1.5 啟動例項
- RAC+DG(asm單例項)ASM單例
- 【Oracle】ASM例項安裝入門OracleASM
- ASM單例項安裝後，需要手動設定ASM的引數檔案ASM單例
- 2.4.9 Step 8: 啟動例項
- 3.1.5.9 啟動遠端例項
- 3.1.5.5 啟動例項到限制模式模式
- oracle 10203啟動例項報警Oracle
- 呀！ASM例項起不來可咋整ASM
- 2.4.15 Step 14: (可選) 開啟自動例項啟動
- 3.1.4 準備啟動一個例項
- 【ASM】ASM啟動無法找到spfile問題原因ASM
- App啟動頁設計例項和技巧，啟動即讓人心動APP
- oracle例項啟動異常慢案例一Oracle
- 3.1.5.4 啟動例項並mount 資料庫資料庫
- 3.1.5.1 關於啟動資料庫例項資料庫
- OpenStack Q版雙機部署-啟動例項
- oracle 12c RAC安裝，例項不能多節點同時啟動Oracle
- 11.2.0.4單例項ASM安裝報錯ohasd failed to ... line 73.單例ASMAI
- ORACLE11GR2 RAC解除安裝ASM例項步驟OracleASM
- 資料庫startup啟動時前滾回滾進行例項恢復的理解資料庫
- 【ASM】Oracle asm刪除磁碟組注意事項ASMOracle
- 【ASK_ORACLE】Relink ASM單例項資料庫詳細步驟OracleASM單例資料庫
- 解決ASM無法啟動問題ASM
- 3.1.5.7 啟動例項、掛載資料庫並啟動完整的媒體恢復資料庫
- led驅動程式例項
- CSS 例項之開啟大門CSS
- rac二節點例項redo故障無法啟動修復
- ORA-29702複製RAC Oracle軟體啟動單例項Oracle單例
- 【ASM】RAC19C因引數設定不當，asm無法啟動ASM
- Flowable啟動流程例項和查詢任務以及完成任務
- openstack環境-解決windows例項重啟後比當前時間晚8小時Windows
- 一步一步搭建11gR2 rac+dg之配置單例項的DG(八)單例
- Python 動態新增例項屬性，例項方法，類屬性，類方法Python
- 開機啟動項
- 資料庫啟動遭遇ORA-00600: [keltnfy-ldmInit]資料庫
- 3.1.5.3 在不掛載資料庫的情況下啟動例項資料庫