oracle 11gR2 asm例項 不能啟動處理方法

由於斷電導致oracle 11g R2 asm 資料庫不能啟動，處理過程如下：

/ as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 12 14:22:13 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 程式：

check css
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Check failed, or completed with errors.
-ef|grep cssd
    grid 135192 225738   0 12:08:39  pts/2  0:00 grep cssd

檢測has程式：

check has
CRS-4639: Could not contact Oracle High Availability Services

說明ohasd程式沒有啟動，啟動ohasd程式：

# ./ohasd start
Starting ohasd:
CRS-4123: Oracle High Availability Services has been started.

檢查：

crsctl stat resource -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA2.dg
               ONLINE  OFFLINE      aix1                                        
ora.LISTENER.lsnr
               ONLINE  OFFLINE      aix1                                        
ora.asm
               ONLINE  OFFLINE      aix1                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  OFFLINE                                                  
ora.db11.db
      1        ONLINE  OFFLINE                                                  
ora.diskmon
      1        ONLINE  OFFLINE 

啟動資料庫：

 

- oracle11
oracle11's Password:
/ as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 12 14:34:34 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1.3696E+10 bytes
Fixed Size                  2219808 bytes
Variable Size            6878658784 bytes
Database Buffers         6777995264 bytes
Redo Buffers               37015552 bytes
Database mounted.
Database opened.
SQL>

ok 資料庫啟動。

接下就是要探討為什麼ohasd程式為什麼在開機的時候沒有自動啟動？

原因是：安裝grid 軟體的lv不是自動掛載的。所以伺服器在啟動的時候是不能自動掛載grid所在lv，也就不能自動啟動ohasd了。如果手動掛載lv，那麼必須手動啟動ohasd服務。

修改lv為自動掛載：

System Storage Management (Physical & Logical Storage)
--&gtFile Systems
---&gtAdd / Change / Show / Delete File Systems
--&gtEnhanced Journaled File Systems
--&gtChange / Show Characteristics of an Enhanced Journaled File System

選擇要自動掛載點
Mount AUTOMATICALLY at system restart?              yes         ------由no改為yes即可

資料剛安裝完成的時候，has程式是自動啟動，用下面的命令設定自動啟動;

enable has  --啟用自動啟動

disable has --關閉自動啟動

手動啟動 has：

crsctl start  has

crsctl stop has

檢視has 的狀態：

crsctl check has

ohasd 資源啟動後，才能啟動crs資源。

在11gR2中, ohasd包含了crsd、ocssd、evmd.

ohasd負責啟動lower stack的叢集資源, crsd負責啟動上層的叢集資源.