http://www.itpub.net/showthread.php?threadid=777053&pagenumber=
我做的测试机器,两台机器使用rac,前天同事拿其中一台做为它用。今天重启机器,发现无法启动asm,检查发现alert.log文件:
Starting up ORACLE RDBMS Version: 10.2.0.2.0.
System parameters with non-default values:
large_pool_size = 12582912
instance_type = asm
cluster_database = TRUE
instance_number = 1
remote_login_passwordfile= EXCLUSIVE
background_dump_dest = /u01/app/oracle/admin/+ASM/bdump
user_dump_dest = /u01/app/oracle/admin/+ASM/udump
core_dump_dest = /u01/app/oracle/admin/+ASM/cdump
asm_diskgroups = ASM_DISK1
USER: terminating instance due to error 27504
执行:srvctl start asm -n xx-rac1
PRKS-1009 : Failed to start ASM instance "+ASM1" on node "xx-rac1", [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "xx-rac1", [CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.xx-rac1.ASM1.asm' has placement error.]]
[PRKS-1009 : Failed to start ASM instance "+ASM1" on node "xx-rac1", [CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.xx-rac1.ASM1.asm' has placement error.]]
解决过程:
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
正常
2.然后执行:
./crs_stop -all
./crs_start -all
./crs_stat -t
状态变为:
ora....SM1.asm application ONLINE OFFLINE
3.然后再启动asm:
srvctl start asm -n xx-rac1 -i +ASM1
xx-rac1:ora.xx-rac1.ASM1.asm:SQL> ORA-27504: IPC error creating OSD context
xx-rac1:ora.xx-rac1.ASM1.asm:ORA-27300: OS system dependent operation:check if running failed with status: 0
xx-rac1:ora.xx-rac1.ASM1.asm:ORA-27301: OS failure message: Error 0
xx-rac1:ora.xx-rac1.ASM1.asm:ORA-27302: failure occurred at: skgxpcini1
xx-rac1:ora.xx-rac1.ASM1.asm:ORA-27303: additional information: requested interface eth1 interface not running. Check output from ifconfig command
xx-rac1:ora.xx-rac1.ASM1.asm:SQL> Disconnected
xx-rac1:ora.xx-rac1.ASM1.asm:
CRS-1006: No more members to consider
CRS-0215: Could not start resource 'ora.xx-rac1.ASM1.asm'.]
根据提示,eth1 没有起来,检查发现网线没有插,重新插上后一切OK。
实际上认真看看ora-27504,以及alert.log相关的位置:
Cluster communication is configured to use the following interface(s) for this instance
172.16.0.3
就很容易确定问题。