您好,登錄后才能下訂單哦!
這篇文章將為大家詳細(xì)講解有關(guān)oracle 11gR2 asm不能啟動的處理方法,文章內(nèi)容質(zhì)量較高,因此小編分享給大家做個參考,希望大家閱讀完這篇文章后對相關(guān)知識有一定的了解。
公司由于斷電導(dǎo)致oracle 11g R2 asm(aix 6.1) 數(shù)據(jù)庫不能啟動,處理過程如下:
aix1@grid[/oracle11/app/grid/11.2.0]$sqlplus / 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 進(jìn)程:
aix1@grid[/home/grid]$crsctl check css
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Check failed, or completed with errors.
aix1@grid[/home/grid]$ps -ef|grep cssd
grid 135192 225738 0 12:08:39 pts/2 0:00 grep cssd
檢測has進(jìn)程:
aix1@grid[/home/grid]$crsctl check has
CRS-4639: Could not contact Oracle High Availability Services
說明ohasd進(jìn)程沒有啟動,啟動ohasd進(jìn)程:
# ./ohasd start
Starting ohasd:
CRS-4123: Oracle High Availability Services has been started.
檢查:
aix1@grid[/oracle11/app/grid/11.2.0]$ 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
啟動數(shù)據(jù)庫:
aix1@grid[/oracle11/app/grid/11.2.0]$su - oracle11
oracle11's Password:
aix1@oracle11[/dsg]$sqlplus / 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 數(shù)據(jù)庫啟動。
接下就是要探討為什么ohasd進(jìn)程為什么在開機的時候沒有自動啟動?
原因是:安裝grid 軟件的lv不是自動掛載的。所以服務(wù)器在啟動的時候是不能自動掛載grid所在lv,也就不能自動啟動ohasd了。如果手動掛載lv,那么必須手動啟動ohasd服務(wù)。
修改lv為自動掛載:
System Storage Management (Physical & Logical Storage)
-->File Systems
--->Add / Change / Show / Delete File Systems
-->Enhanced Journaled File Systems
-->Change / Show Characteristics of an Enhanced Journaled File System
選擇要自動掛載點
Mount AUTOMATICALLY at system restart? yes ------由no改為yes即可
數(shù)據(jù)剛安裝完成的時候,has進(jìn)程是自動啟動,用下面的命令設(shè)置自動啟動;
aix1@grid[/home/grid]$crsctl enable has --啟用自動啟動
aix1@grid[/home/grid]$crsctl disable has --關(guān)閉自動啟動
手動啟動 has:
crsctl start has
crsctl stop has
查看has 的狀態(tài):
crsctl check has
ohasd 資源啟動后,才能啟動crs資源。
在11gR2中, ohasd包含了crsd、ocssd、evmd.
ohasd負(fù)責(zé)啟動lower stack的集群資源, crsd負(fù)責(zé)啟動上層的集群資源.
關(guān)于oracle 11gR2 asm不能啟動的處理方法就分享到這里了,希望以上內(nèi)容可以對大家有一定的幫助,可以學(xué)到更多知識。如果覺得文章不錯,可以把它分享出去讓更多的人看到。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。