RAC ORA-03113:end-of-file on communication channel错误

Yong Huang · 发表于 2012-3-15 11:34

Since it tells you it's "communication failure with ASM instance", why not check the trace files in the ASM trace directory?

leonarding · 发表于 2012-3-19 07:42

Yong Huang 发表于 2012-3-15 11:34
Since it tells you it's "communication failure with ASM instance", why not check the trace files in ...

你好，最近较忙误回复请见谅，我已经查了tracefile Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name: Linux
Node name:    rac2
Release:       2.6.18-53.el5
Version:       #1 SMP Wed Oct 10 16:34:02 EDT 2007
Machine:       i686
Instance name: RACDB2
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 13083, image: oracle@rac2 (LMD0)

*** 2012-03-12 17:22:02.583
*** SERVICE NAME

SYS$BACKGROUND) 2012-03-12 17:22:02.583
*** SESSION ID

166.1) 2012-03-12 17:22:02.583
lmd abort after exception 15064
KJC Communication Dump:
  state 0x5  flags 0x0  mode 0x0  inst 1  inc 2
  nrcv 1  nsp 1  nrcvbuf 1000
  reg_msg: sz 420  cur 0 (s:0 i:0) max 0  ini 100
  big_msg: sz 4128  cur 0 (s:0 i:0) max 0  ini 100
  rsv_msg: sz 4128  cur 0 (s:0 i:0) max 0  tot 100
  rcvr: id 0  orapid 6  ospid 13083
  send proxy: id 0  ndst 0 ()
GES resource limits:
  ges resources: cur 0 max 0 ini 64
  ges enqueues: cur 0 max 0 ini 128
  ges cresources: cur 0 max 0
  gcs resources: cur 0 max 0 ini 0
  gcs shadows: cur 0 max 0 ini 0
KJCTS state: seq-check:no  timeout:yes  waitticks:0x3  highload no
GES destination context:
GES remote instance per receiver context:
Rcvr 0  state 0x0
  rbufs tot 1100  in_ksxp 1100  ubufs 0  free 0
  msgs rdyq 0  watq 0  nsq 0  routq 1100
  rmpool: alloc 1100  avail 0
  ibatch: 2[0] 3[0] 4[0] 5[0] 6[0] 7[0] 8[0] 9[0] 10[0] 11[0]
  ibatch: sum 0
      rcvs 0 tot msgs 0 max sz 0 avg sz 0
  pbatch: 2[0] 3[0] 4[0] 5[0] 6[0] 7[0] 8[0] 9[0] 10[0] 11[0]
  pbatch: sum 0
      rcvs 0 tot msgs 0 max sz 0 avg sz 0
DEFER MSG QUEUE ON LMD0 IS EMPTY
SEQUENCES:
  0:0.0
error 15064 detected in background process          在后台进程中发现此问题
ORA-15064: communication failure with ASM instance    还是说ASM实例通信失败
我使用了另一台机器从新进行了测试
：使用我妈的机器进行了第n次测试
总结rac总报错是与机器有关系，
我的本机就报上次我跟您看的错误，
我妈的台式机就不报错，
不同点：在eth2上，报错本机设置：
192.168.174.128~129
不报错台式机设置：
192.168.61.128~129
因为eth2网卡使用的DHCP动态分配ip，这有可以是网卡MAC地址与ip绑定的结果，只要ip不同，就可以perfect呈现，thank you  very mach

sundog315 · 发表于 2012-3-19 08:51

提示ASM失败，为什么不看看ASM的日志呢？

Yong Huang · 发表于 2012-3-20 00:13

leonarding,

You still don't understand. Please check the ASM instance trace file, not the DB instance trace file.

leonarding · 发表于 2012-3-20 12:17

Yong Huang 发表于 2012-3-20 00:13
leonarding,

You still don't understand. Please check the ASM instance trace file, not the DB inst ...

got it，真相只有一个

你是斑竹么？你叫什么名字啊

Yong Huang · 发表于 2012-3-20 23:19

> 你是斑竹么？你叫什么名字啊

Correct. My name is Yong Huang, 黄勇. Nice to meet you.

leonarding · 发表于 2012-3-26 09:20

Yong Huang 发表于 2012-3-20 23:19
> 你是斑竹么？你叫什么名字啊

Correct. My name is Yong Huang, 黄勇. Nice to meet you.

Morning Nice to meet you too My name is sheng liu . sunday ,ACOUG conference to bei jing ，你来了嘛？

Yong Huang · 发表于 2012-3-26 23:55

ACOUG is a wonderul gathering. But sorry I can't go. I'm thinking of joining them though. Not sure if they accept overseas members, and ideally, if I need to post something, they allow posting in English (just because I type faster).

ddyg110 · 发表于 2013-3-4 20:31

leonarding 发表于 2012-3-19 07:42
你好，最近较忙误回复请见谅，我已经查了tracefile Oracle Database 10g Enterprise Edition Release 10. ...

这种问题还真没遇到过，学习了。

leonarding · 发表于 2013-3-5 17:55

ddyg110 发表于 2013-3-4 20:31
这种问题还真没遇到过，学习了。

这么早的帖子都被你挖到了厉害

[讨论] RAC ORA-03113:end-of-file on communication channel错误

浏览过的版块