這篇文章將為大家詳細(xì)講解有關(guān)oracle 11gR2 asm不能啟動(dòng)的處理方法,文章內(nèi)容質(zhì)量較高,因此小編分享給大家做個(gè)參考,希望大家閱讀完這篇文章后對(duì)相關(guān)知識(shí)有一定的了解。
在諸暨等地區(qū),都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局,加強(qiáng)發(fā)展的系統(tǒng)性、市場(chǎng)前瞻性、產(chǎn)品創(chuàng)新能力,以專(zhuān)注、極致的服務(wù)理念,為客戶(hù)提供成都做網(wǎng)站、網(wǎng)站建設(shè)、外貿(mào)營(yíng)銷(xiāo)網(wǎng)站建設(shè) 網(wǎng)站設(shè)計(jì)制作定制網(wǎng)站,公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站設(shè)計(jì),營(yíng)銷(xiāo)型網(wǎng)站,成都外貿(mào)網(wǎng)站制作,諸暨網(wǎng)站建設(shè)費(fèi)用合理。
公司由于斷電導(dǎo)致oracle 11g R2 asm(aix 6.1) 數(shù)據(jù)庫(kù)不能啟動(dòng),處理過(guò)程如下:
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
檢測(cè) 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
檢測(cè)has進(jìn)程:
aix1@grid[/home/grid]$crsctl check has
CRS-4639: Could not contact Oracle High Availability Services
說(shuō)明ohasd進(jìn)程沒(méi)有啟動(dòng),啟動(dòng)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
啟動(dòng)數(shù)據(jù)庫(kù):
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ù)庫(kù)啟動(dòng)。
接下就是要探討為什么ohasd進(jìn)程為什么在開(kāi)機(jī)的時(shí)候沒(méi)有自動(dòng)啟動(dòng)?
原因是:安裝grid 軟件的lv不是自動(dòng)掛載的。所以服務(wù)器在啟動(dòng)的時(shí)候是不能自動(dòng)掛載grid所在lv,也就不能自動(dòng)啟動(dòng)ohasd了。如果手動(dòng)掛載lv,那么必須手動(dòng)啟動(dòng)ohasd服務(wù)。
修改lv為自動(dòng)掛載:
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
選擇要自動(dòng)掛載點(diǎn)
Mount AUTOMATICALLY at system restart? yes ------由no改為yes即可
數(shù)據(jù)剛安裝完成的時(shí)候,has進(jìn)程是自動(dòng)啟動(dòng),用下面的命令設(shè)置自動(dòng)啟動(dòng);
aix1@grid[/home/grid]$crsctl enable has --啟用自動(dòng)啟動(dòng)
aix1@grid[/home/grid]$crsctl disable has --關(guān)閉自動(dòng)啟動(dòng)
手動(dòng)啟動(dòng) has:
crsctl start has
crsctl stop has
查看has 的狀態(tài):
crsctl check has
ohasd 資源啟動(dòng)后,才能啟動(dòng)crs資源。
在11gR2中, ohasd包含了crsd、ocssd、evmd.
ohasd負(fù)責(zé)啟動(dòng)lower stack的集群資源, crsd負(fù)責(zé)啟動(dòng)上層的集群資源.
關(guān)于oracle 11gR2 asm不能啟動(dòng)的處理方法就分享到這里了,希望以上內(nèi)容可以對(duì)大家有一定的幫助,可以學(xué)到更多知識(shí)。如果覺(jué)得文章不錯(cuò),可以把它分享出去讓更多的人看到。
新聞標(biāo)題:oracle11gR2asm不能啟動(dòng)的處理方法
文章位置:http://m.rwnh.cn/article32/gdigsc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供網(wǎng)站設(shè)計(jì)、定制開(kāi)發(fā)、移動(dòng)網(wǎng)站建設(shè)、品牌網(wǎng)站設(shè)計(jì)、營(yíng)銷(xiāo)型網(wǎng)站建設(shè)、網(wǎng)站建設(shè)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話(huà):028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)