10g rac 仅有一台机器不能启动

简介: http://www.itpub.net/showthread.php?threadid=777053&pagenumber=我做的测试机器,两台机器使用rac,前天同事拿其中一台做为它用。

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

就很容易确定问题。

目录
相关文章
|
Oracle 关系型数据库 数据库管理
|
网络协议 Oracle 关系型数据库
|
Oracle 关系型数据库 数据库
|
文字识别 Oracle 前端开发
|
文字识别 Oracle 前端开发