11gR2启动ASM实例时遭遇ORA-29701-CSDN博客

早上启动asm 报错，马上google 发现这个好东东，保存下前辈的成功，呵呵

原文地址:http://tomszrp.itpub.net/post/11835/493005

[grid@vm11gr2] /home/grid>sqlplus "/as sysasm"ITPUB个人空间*r@#s@8Q a*y

c c?T"?$dGcjn0w24558279 SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:16:21 2009ITPUB个人空间)Kl+Cu&f8i\Z+OA
ITPUB个人空间)CkDo;v
Copyright (c) 1982, 2009, Oracle. All rights reserved.
-H Z t8Q#K|I#m5wi24558279
A_1ro}E24558279 Connected to an idle instance.ITPUB个人空间 @{4H:w/G'f&e*Z.[W
SQL>startup
E }\HZO'eVV!K24558279 ORA-01078: failure in processing system parametersITPUB个人空间~r-o X+P
ORA-29701: unable to connect to Cluster Synchronization Service
cy Iuj0b"~1?$b!Z2_@24558279 SQL>
0](t:QOE/Gx'P P&]24558279 无法连接到CSS服务上.到操作系统上检查一下看看
+v;WF1JQ;~,DG$Dq24558279ITPUB个人空间1gJjv3xYt
[grid@vm11gr2] /home/grid>crsctl check css
}2T#h7kD#U24558279 CRS-4530: Communicationsfailurecontacting Cluster Synchronization Services daemonITPUB个人空间&N-d&J)|(oGJm
[grid@vm11gr2] /home/grid>
Ez`CQS[24558279 [grid@vm11gr2] /home/grid> ps -ef|grep cssd
+u"hY{[ r*t24558279 果然没有CSS的服务daemon进程,再看一下HAS(High Availability Service)的状态ITPUB个人空间U,TaxD:fky2{
ITPUB个人空间l2E|Gc0WO1u
[grid@vm11gr2] /home/grid>crsctl check hasITPUB个人空间%F}*?R%H^.H&^
CRS-4638: Oracle High Availability Services isonline
-r*W2aK }"R24558279
oI_Q&tY24558279 [grid@vm11gr2] /home/grid>ps -ef|grep d.bin
WJ&Q[1Q#VyS;WC24558279 grid 5886 1 0 10:06 ? 00:00:01 /u01/app/grid/product/11.2/grid/bin/ohasd.bin rebootITPUB个人空间qu5|%i!l8{c
[grid@vm11gr2] /home/grid>ITPUB个人空间6T1V-x*Bv
发现HAS的服务确实启动了的,而ora.cssd和ora.diskmon这2个服务是依赖于HAS维护的.
-A3Z/B S&DOSBq yh@24558279 ITPUB个人空间cm^E7RiO
ITPUB个人空间*t!{]!b-r+}&fK~l-X&p-F
进一步查看各资源的状态
q[] a*VIB"~HR[24558279 [grid@vm11gr2] /home/grid>crs_stat -t
ClC5HYA24558279 Name Type Target State HostITPUB个人空间o}~zm
--------------------------------------------------------------
,ne4`9K.[vM$^9N`_1u24558279 ora.FLASH_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2ITPUB个人空间5M*cI ec+TXMG~
ora.SYS_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
X~Fix}Ol24558279 ora.asm ora.asm.type OFFLINE OFFLINE vm11gr2
6Sz'D!y2w8s[A24558279 ora.cssd ora.cssd.type OFFLINE OFFLINE vm11gr2
YIX:NK)cj'B24558279 ora.diskmon ora.diskmon.type OFFLINE OFFLINE vm11gr2ITPUB个人空间6R-MM,I(Jd6Rp\
[grid@vm11gr2] /home/grid>ITPUB个人空间'EcJ*R\s8x
ITPUB个人空间1MHdx@6K3_
[grid@vm11gr2] /home/grid>crsctl status resource -t
:w0s B9G@+G(NCC24558279 --------------------------------------------------------------------------------
~:a L^:jH24558279 NAME TARGET STATE SERVER STATE_ DETAILSITPUB个人空间,qgL"a _R
--------------------------------------------------------------------------------
5w {p1f.k {r&u24558279 Local Resources
C"\-vdA)[24558279 --------------------------------------------------------------------------------ITPUB个人空间fM^ cX J
ora.FLASH_DATA.dgITPUB个人空间iE$o)K u I
OFFLINE OFFLINE vm11gr2ITPUB个人空间*|nH;]|e,} J
ora.SYS_DATA.dg
LO%]uD i.f24558279ITPUB个人空间 Fjd:mjjb g
OFFLINE OFFLINE vm11gr2ITPUB个人空间K`8L w]U_B
ora.asm
E7t q(HA?S&\0Q#KC24558279
*FV[I3w*i"_{24558279 OFFLINE OFFLINE vm11gr2
$A6i+VY!x3aP24558279 --------------------------------------------------------------------------------
5U4LLJ8fc24558279 Cluster Resources
$hK/rjoU F24558279 --------------------------------------------------------------------------------
`B}x4sO24558279 ora.cssd
(D.}Uc$~d24558279ITPUB个人空间Y"K0r6wN\&[6C
1 OFFLINE OFFLINE
y#w2l8u t@p24558279 ora.diskmon
IVn O"q@ [}24558279ITPUB个人空间 t/V:`6R W~ ki
1 OFFLINE OFFLINEITPUB个人空间1Dz s(MN)KTrJ/r:BR

^(^"Ljc;aP24558279 再看一下ora.cssd和ora.diskmon的属性
r$o-Z(f"CG24558279 [grid@vm11gr2] /home/grid> crs_stat -p ora.cssdITPUB个人空间$M1s#UrP
NAME=ora.cssd
,qq3aEZ n:J:HH24558279 TYPE=ora.cssd.typeITPUB个人空间1S_#O9Nv_
ACTION_SCRIPT=
`XC!V1Rf7M H-IGrH24558279 ACTIVE_PLACEMENT=0ITPUB个人空间\MG ?.t/f?
AUTO_START=never
clpq$p#p5b24558279 CHECK_INTERVAL=30
-Z6Q)E~-Hi2eAKs24558279 DESCRIPTION="Resource type for CSSD"
3h)i(sY~i24558279 FAILOVER_DELAY=0
8c/s5x^5Y!lzRqL24558279 FAILURE_INTERVAL=3
1[E'VYz\oM\"Z-?24558279 FAILURE_THRESHOLD=5
(Q K6ruuB24558279 HOSTING_MEMBERS=
C,O%p^p7Ft;U~v24558279 PLACEMENT=balancedITPUB个人空间5t'YW,qC,W
RESTART_ATTEMPTS=5
&S[ ag#K0[-{^BS5R24558279 SCRIPT_TIMEOUT=600ITPUB个人空间K-}*a]%]b({u
START_TIMEOUT=600
(v7@]ni1T m24558279 STOP_TIMEOUT=900
fu)RNK5nNo:L2C24558279 UPTIME_THRESHOLD=1m
X:J4P&pe2v%W&R24558279
Ct1u \[ nK8A/^z24558279 [grid@vm11gr2] /home/grid>crs_stat -p ora.diskmonITPUB个人空间9_Tm|8zF\j
NAME=ora.diskmon
B-SiX+|e|24558279 TYPE=ora.diskmon.type
)LkN,]8[,e24558279 ACTION_SCRIPT=ITPUB个人空间3a;o3F9`V!]
ACTIVE_PLACEMENT=0
y+tJh DYj24558279 AUTO_START=neverITPUB个人空间J d\ @&c
CHECK_INTERVAL=20ITPUB个人空间.xh7i%N$N gI@
DESCRIPTION="Resource type for Diskmon"ITPUB个人空间v5f#ryPp@
FAILOVER_DELAY=0
(}/OVTd24558279 FAILURE_INTERVAL=3
([)]W6Xz%i'z'_24558279 FAILURE_THRESHOLD=5
S0?"^'WCga|b*c24558279 HOSTING_MEMBERS=ITPUB个人空间$R-s0of!Bc {
PLACEMENT=balancedITPUB个人空间0Fu0v[XWLf?(X0u
RESTART_ATTEMPTS=10ITPUB个人空间(ozx4a+_Z)F
SCRIPT_TIMEOUT=60ITPUB个人空间 ua;aco/k&v
START_TIMEOUT=60ITPUB个人空间5Zhi?FK
STOP_TIMEOUT=60
&`.~!u(I/p!yA2s24558279 UPTIME_THRESHOLD=5s
9N S'ED1p6u24558279 [grid@vm11gr2] /home/grid>ITPUB个人空间"[z1}jK
到这里基本就找到了原因了,可以看到这两个资源的AUTO_START属性默认都设置为never,也就是说他们不会随着HAS服务的启动而自动启动的,ITPUB个人空间]{0E;iR}
尽管默认情况下HAS服务是开机自动启动的.好了，那我们就手动启动一下吧:
6{+V0Y[6_n,~24558279 [grid@vm11gr2] /home/grid>crsctl start resource ora.cssdITPUB个人空间Rm2jA8|x-fU)c
CRS-2672: Attempting to start 'ora.cssd' on 'vm11gr2'
9zqb.r;DC8I$J1g24558279 CRS-2679: Attempting to clean 'ora.diskmon' on 'vm11gr2'
DS5^q(W7_.t24558279 CRS-2681: Clean of 'ora.diskmon' on 'vm11gr2' succeededITPUB个人空间b1fL"?P j$eX
CRS-2672: Attempting to start 'ora.diskmon' on 'vm11gr2'ITPUB个人空间gk#DYD&e_
CRS-2676: Start of 'ora.diskmon' on 'vm11gr2' succeeded
$e7~Mbm+|)Es4vvN^24558279 CRS-2676: Start of 'ora.cssd' on 'vm11gr2' succeeded
3sp*B.Ar\$N24558279 [grid@vm11gr2] /home/grid>
}rbA.qfuS3A24558279ITPUB个人空间g?I(wf"h
注:ora.cssd和ora.diskmon这两个服务是有依赖关系的，启动哪个都会把两个都起来.ITPUB个人空间XN @6d s9L:va4I#f%v
ITPUB个人空间dJxLv0dQ
[grid@vm11gr2] /home/grid>crs_stat -tITPUB个人空间Pdh*r1{
Name Type Target State Host
2?Hc*iUK4\Y24558279 --------------------------------------------------------------ITPUB个人空间$_A TN"OK'C"^
ora.FLASH_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
i]r;S&T6J#K*l24558279 ora.SYS_DATA.dg ora.diskgroup.type OFFLINE OFFLINE vm11gr2
@0R[S!KYr){5\24558279 ora.asm ora.asm.type OFFLINE OFFLINE vm11gr2
$A#k1yy#Bk"BJ {24558279 ora.cssd ora.cssd.type ONLINE ONLINE vm11gr2
1d,EEB)y.AL7j!DX24558279 ora.diskmon ora.diskmon.type ONLINE ONLINE vm11gr2ITPUB个人空间$H8H e]0hH:m
[grid@vm11gr2] /home/grid>ITPUB个人空间T^Fk(v.B
CSS服务起来了，重启动asm instance ITPUB个人空间]JmN/{~ {G

V] _|]-u24558279 [grid@vm11gr2] /home/grid>sqlplus "/as sysasm"
]*PUs@'R yC24558279
F'[1W%z`24558279 SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:30:03 2009
:gx;q6v2f:_24558279
i'bk WqK B4ND24558279 Copyright (c) 1982, 2009, Oracle. All rights reserved.ITPUB个人空间)J2Fw+e Z0h
ITPUB个人空间"]IagH4q'\(Z
Connected to an idle instance.
)D^y-}|@$NU*R24558279
Lp)|qqc4v'[j24558279 SQL>startupITPUB个人空间s6pG4k&e/o9r}?~
ASM instance startedITPUB个人空间w.^o@kIF ?I
ITPUB个人空间,x3d QC?)TPuN
Total System Global Area 284565504 bytesITPUB个人空间X{;`:B(F^tV`)Ir|c
Fixed Size 1336036 bytes
u}Nd0L8E24558279 Variable Size 258063644 bytes
-XEE7c2t%Z3E v24558279 ASM Cache 25165824 bytesITPUB个人空间ZYcE5|
ASM diskgroups mountedITPUB个人空间FA@+qm!Ce$W
SQL>exitITPUB个人空间&Q7S\\})J(I)Q
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
p1L6ER;[Z,b,aX5W24558279 With the Automatic Storage Management option
r.J^&ScVA1~-?(_0N24558279 [grid@vm11gr2] /home/grid>crs_stat -tITPUB个人空间7g:zM@D
Name Type Target State Host
}7i8`KkwW+}A7K"\24558279 --------------------------------------------------------------
-L^7s5@:p[-Za+~24558279 ora.FLASH_DATA.dg ora.diskgroup.type ONLINE ONLINE vm11gr2
s0k{?;`Y4}7H24558279 ora.SYS_DATA.dg ora.diskgroup.type ONLINE ONLINE vm11gr2ITPUB个人空间H c m3tC7}a
ora.asm ora.asm.type ONLINE ONLINE vm11gr2ITPUB个人空间%n;N6hF3gT3i
ora.cssd ora.cssd.type ONLINE ONLINE vm11gr2ITPUB个人空间-TU,xH:Pl"hP)L"X$yR
ora.diskmon ora.diskmon.type ONLINE ONLINE vm11gr2
$zm XJd24558279 [grid@vm11gr2] /home/grid>
'd,OF#S%|L24558279ITPUB个人空间G&P5\x/[}
tips
q {4PP-P24558279
(u }pH%|v24558279 1)默认情况下HAS(High Availability Service)是自动启动的.通过如下命令可以取消和启用自动启动ITPUB个人空间"z)G!v Z*[5IMG$vO i
crsctl disable hasITPUB个人空间:V bx*Yz
crsctl enable has
i6`0]"l|WJ0b`24558279 2)HAS手动启动和停止
_{B,O*s'n.z24558279 crsctl start has
c0Vw/xX#O6e24558279 crsctl stop has
:lWz2f#]4ZF"l24558279 3)查看HAS的状态ITPUB个人空间L1u:G%o#gP"i ~
crsctl check has
,B5@nE#W5x24558279 4)如果想让ora.css和ora.diskmon服务随着HAS的启动而自动启动，那么你可以这两个服务的AUTO_START属性
V s+d,pg3b24558279 crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
-qpr-uy24558279 orITPUB个人空间le/n|3uW9ls W
crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
4x s&J7mQmA!T24558279 5)如果想取消ora.css和ora.diskmon的Auto start
+Mp pN.h3j24558279 crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
%w;}Xh)G24558279 crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"