使用 VMware Server 在 Oracle Enterprise Linux 上安装 Oracle RAC遇到的问题

1.PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.rac1.ASM1.asm' has placement error.]]
[PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.rac1.ASM1.asm' has placement error.]]

 

解决过程：

1.1。首先执行

$ crs_stat -t

Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE UNKNOWN

发现state为UNKNOWN。

$crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
正常

1.2.然后执行：

$crs_stop -all
$crs_start -all
$crs_stat -t

状态变为:
ora....SM1.asm application ONLINE ONLINE

1.3.然后再启动asm：

srvctl start asm -n rac1 -i +ASM1

OK

 

2.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL> exit
Disconnected

解决:

$ export ORACLE_SID=+ASM
$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 27 10:35:51 2007

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 130023424 bytes
Fixed Size 1976920 bytes
Variable Size 102880680 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> exit

3.一直提示实例+ASM2无法启动,和+ASM1一样启动了若干次,还是无效,最后在rac1上ssh连接rac2 startup,结果不再提示+ASM2无法启动了,提示"error when connecting to asm instance on local node:lo exception:the network adapter could not establish the connection"