ORA-03135 ,ORA-02050到底什么原因?

今天上午,产线报告数据库无法使用,赶到机房,发现数据库已经恢复正常,在 alter log 中发现如下错误:

Error 3135 trapped in 2PC on transaction 135.41.1233516. Cleaning up.

Error stack returned to user:

ORA-02050: transaction 135.41.1233516 rolled back, some remote DBs may be in-doubt

ORA-03135: connection lost contact

Wed Oct 14 10:22:01 2009

Errors in file d:"cim"dump"udump"cim_ora_4800.trc:

ORA-03113: end-of-file on communication channel

ORA-03135: connection lost contact

ORA-03135: connection lost contact

ORA-06512: at "CIM.SFDM_DATA_ACCESS_THREE", line 46

ORA-06512: at line 1

 

Wed Oct 14 10:22:01 2009

DISTRIB TRAN CIM.REGRESS.RDBMS.DEV.US.ORACLE.COM.8eb6fd53.135.41.1233516

 is local tran 135.41.1233516 (hex=87.29.12d26c)

 insert pending collecting tran, scn=10134734144807 (hex=937.ad3a8527)

Wed Oct 14 10:22:02 2009

DISTRIB TRAN CIM.REGRESS.RDBMS.DEV.US.ORACLE.COM.8eb6fd53.135.41.1233516

 is local tran 135.41.1233516 (hex=87.29.12d26c))

 delete pending collecting tran, scn=10134734144807 (hex=937.ad3a8527)

Wed Oct 14 10:22:14 2009

Errors in file d:"cim"dump"udump"cim_ora_4800.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-03113: end-of-file on communication channel

ORA-03135: connection lost contact

ORA-03135: connection lost contact

ORA-06512: at "CIM.SFDM_DATA_ACCESS_THREE", line 46

ORA-06512: at line 1

 

在网上找了很久,发现大多是说DB_link或存储过程造成,但存储过程并未使用DB_link,metalink上,说是网络不稳定造成,检查网卡设定,速度设的是自动侦测,而交换机发现此网口频繁100M & 1G切换,怀疑是因为这个原因引起,将网卡设为1G 全双工,最终也不确定原因。如下是在metalink上找到的两篇相关文章,均说是oracle BUG.,不过是后一篇是UNIX Platform.

           如那位有这方面的经验,请不吝提供!

 

Bug No.

5758870

Filed

11-JAN-2007

Updated

28-NOV-2008

Product

Oracle Server - Enterprise Edition

Product Version

10.2.0.3

Platform

Microsoft Windows Server 2003

Platform Version

No Data

Database Version

10.2.0.2

Affects Platforms

Generic

Severity

Severe Loss of Service

Status

Development to Q/A

Base Bug

N/A

Fixed in Product Version

11.0.0.0



 
Problem statement:

 


 
 

 

*** 01/11/07 11:24 pm ***

*** 01/11/07 11:28 pm *** (CHG: Sta->16)

*** 01/11/07 11:28 pm ***

*** 01/11/07 11:51 pm ***

*** 01/12/07 01:15 am ***

*** 01/12/07 06:42 am *** ESCALATED

*** 01/12/07 06:42 am ***

*** 01/12/07 06:44 am *** (CHG: Asg->NEW OWNER)

*** 01/12/07 07:57 am ***

*** 01/12/07 08:04 am ***

*** 01/12/07 12:19 pm *** (CHG: Sta->10)

*** 01/12/07 12:19 pm ***

*** 01/14/07 05:55 pm *** (CHG: Sta->16)

*** 01/14/07 05:55 pm ***

*** 01/18/07 04:31 am ***

*** 01/18/07 09:20 am ***

*** 01/18/07 01:01 pm ***

*** 01/18/07 01:11 pm ***

*** 01/18/07 01:52 pm *** (CHG: Sta->10)

*** 01/18/07 01:52 pm ***

*** 01/18/07 05:44 pm *** (CHG: Sta->16)

*** 01/18/07 05:44 pm ***

*** 01/18/07 08:25 pm ***

*** 01/19/07 06:58 am ***

*** 01/19/07 08:06 am *** (CHG: G/P->P Asg->NEW OWNER)

*** 01/19/07 08:11 am *** (CHG: G/P->G)

*** 01/19/07 08:13 am *** (CHG: Asg->NEW OWNER)

*** 01/19/07 08:13 am ***

*** 01/19/07 04:40 pm ***

*** 01/23/07 02:44 pm ***

*** 01/24/07 03:18 am ***

*** 01/24/07 10:45 am ***

*** 01/24/07 01:27 pm ***

*** 01/24/07 01:27 pm *** (CHG: Sta->10)

*** 01/25/07 06:22 am *** (CHG: Sta->16)

*** 01/25/07 06:22 am ***

*** 01/25/07 07:45 am ***

*** 01/26/07 11:21 am ***

*** 01/26/07 12:27 pm ***

*** 01/26/07 04:11 pm ***

*** 01/30/07 05:32 pm ***

*** 01/30/07 05:32 pm ***

*** 01/30/07 05:55 pm *** (CHG: Sta->10)

*** 01/30/07 05:56 pm ***

*** 01/30/07 06:15 pm *** (CHG: Sta->16)

*** 01/30/07 06:15 pm ***

*** 01/31/07 06:24 am ***

*** 01/31/07 12:59 pm ***

*** 01/31/07 02:15 pm ***

*** 01/31/07 02:16 pm ***

*** 01/31/07 02:18 pm ***

*** 01/31/07 02:18 pm ***

*** 01/31/07 02:19 pm *** (CHG: Asg->NEW OWNER)

*** 01/31/07 02:24 pm *** (CHG: Sta->11)

*** 01/31/07 02:25 pm *** (CHG: SubComp->PRG INTERFACE)

*** 01/31/07 03:43 pm ***

*** 01/31/07 08:19 pm *** (CHG: Asg->NEW OWNER)

*** 01/31/07 08:19 pm ***

*** 01/31/07 11:54 pm ***

*** 02/01/07 11:04 am ***

*** 02/01/07 11:06 am ***

*** 02/01/07 11:08 am *** (CHG: Sta->30)

*** 02/01/07 06:24 pm *** (CHG: Sta->11)

*** 02/01/07 06:24 pm ***

*** 02/02/07 01:19 am ***

*** 02/02/07 01:19 am *** (CHG: Sta->30)

*** 02/02/07 08:54 am *** (CHG: Asg->NEW OWNER)

*** 02/02/07 08:54 am ***

*** 02/04/07 07:42 pm *** (CHG: Sta->11)

*** 02/04/07 07:42 pm ***

*** 02/05/07 04:02 am *** (CHG: Asg->NEW OWNER)

*** 02/05/07 05:13 am *** (CHG: Asg->NEW OWNER)

*** 02/05/07 05:13 am ***

*** 02/08/07 01:42 am *** (CHG: Sta->30)

*** 02/08/07 01:42 am ***

*** 02/08/07 01:43 am *** (CHG: DevPri->2)

*** 02/08/07 01:43 am *** (CHG: Confirmed Flag->Y)

*** 02/08/07 03:44 am *** (CHG: Sta->11)

*** 02/08/07 03:44 am ***

*** 02/09/07 12:37 am ***

*** 02/09/07 12:43 am *** (CHG: Sta->30)

*** 02/09/07 12:43 am ***

*** 02/09/07 03:46 am *** (CHG: Sta->11)

*** 02/09/07 03:46 am ***

*** 02/16/07 04:08 am ***

*** 02/20/07 10:40 am *** (CHG: Sta->30)

*** 02/20/07 10:40 am ***

*** 02/23/07 04:07 am *** (CHG: Sta->11)

*** 02/23/07 04:07 am ***

*** 03/05/07 09:18 am ***

*** 03/05/07 09:41 am *** (CHG: Prod->5 Comp->RDBMS SubComp->TAF)

*** 03/05/07 09:42 am *** (CHG: Asg->NEW OWNER)

*** 03/05/07 09:42 am ***

*** 03/06/07 05:47 pm ***

*** 03/07/07 03:24 pm *** (CHG: Sta->30)

*** 03/07/07 03:24 pm ***

*** 03/08/07 05:13 am ***

*** 03/13/07 11:10 pm ***

*** 03/13/07 11:10 pm *** (CHG: Sta->11)

*** 03/13/07 11:10 pm ***

*** 03/14/07 11:50 am ***

*** 03/14/07 11:50 am *** (CHG: Sta->30)

*** 03/14/07 07:26 pm *** (CHG: Sta->11)

*** 03/14/07 07:26 pm ***

*** 03/16/07 03:34 pm ***

*** 03/18/07 10:35 pm ***

*** 03/20/07 03:30 pm ***

*** 03/21/07 01:56 pm *** (CHG: DevPri->1)

*** 03/21/07 01:56 pm *** (CHG: Sta->52 Asg->NEW OWNER)

*** 03/21/07 01:56 pm ***

*** 03/21/07 10:48 pm *** (CHG: Sta->30)

*** 03/21/07 10:48 pm ***

*** 03/22/07 06:34 pm *** (CHG: Sta->11)

*** 03/22/07 06:34 pm ***

*** 03/23/07 12:48 am *** (CHG: Asg->NEW OWNER)

*** 03/23/07 12:48 am ***

*** 03/23/07 12:50 am ***

*** 03/23/07 03:08 am ***

*** 03/23/07 03:09 am *** (CHG: Asg->NEW OWNER)

*** 03/23/07 09:59 am *** (CHG: Sta->30)

*** 03/23/07 09:59 am ***

*** 03/26/07 03:43 am *** (CHG: Sta->11)

*** 03/26/07 03:43 am ***

*** 03/26/07 02:20 pm ***

*** 03/27/07 03:36 am ***

*** 03/27/07 03:43 pm ***

*** 03/29/07 03:39 pm ***

*** 04/02/07 11:15 am *** (CHG: Sta->52 Asg->NEW OWNER)

*** 04/02/07 11:15 am ***

*** 04/05/07 01:48 am *** (CHG: Sta->11 Asg->NEW OWNER)

*** 04/05/07 03:08 am ***

*** 04/05/07 03:33 am ***

*** 04/05/07 03:36 am *** (CHG: Asg->NEW OWNER)

*** 04/05/07 03:41 am *** (CHG: Asg->NEW OWNER)

*** 04/05/07 04:27 am ***

*** 04/05/07 04:27 am *** (CHG: Asg->NEW OWNER)

*** 04/05/07 06:36 am ***

*** 04/05/07 01:55 pm ***

*** 04/05/07 07:30 pm ***

*** 04/06/07 11:04 am ***

*** 04/06/07 05:10 pm *** (CHG: Sta->52 Asg->NEW OWNER)

*** 04/06/07 05:10 pm ***

*** 04/10/07 05:04 am *** (CHG: Sta->11 Asg->NEW OWNER)

*** 04/10/07 05:04 am ***

*** 04/10/07 08:26 am ***

*** 04/10/07 08:27 am *** (CHG: Asg->NEW OWNER)

*** 04/10/07 07:43 pm ***

*** 04/10/07 07:45 pm ***

*** 04/10/07 07:45 pm ***

*** 04/11/07 11:19 am ***

*** 04/13/07 09:20 am ***

*** 04/13/07 12:45 pm ***

*** 04/16/07 11:55 am ***

*** 04/18/07 12:36 pm ***

*** 04/19/07 11:36 am ***

*** 04/20/07 04:40 pm ***

*** 04/23/07 10:40 am ***

*** 04/25/07 10:43 am ***

REDISCOVERY INFORMATION:

When you get 3135 error after pulling off network cable in select type failover

 on windows server, this is the bug.

WORKAROUND:

None

RELEASE NOTES:

]]]]Customer got 3135 error after after pulling off network cable in select typ

]]e failover on windows server.

*** 04/25/07 10:48 am *** (CHG: Fixed->11.0.0.0)

*** 04/25/07 10:48 am *** (CHG: Sta->80)

*** 04/26/07 04:37 am ***

*** 04/26/07 08:03 am ***

*** 04/26/07 08:14 am ***

*** 04/26/07 05:42 pm ***

*** 04/26/07 06:21 pm ***

*** 04/26/07 06:22 pm ***

*** 04/26/07 06:22 pm ***

*** 04/27/07 05:11 am ***

*** 04/27/07 09:19 am ***

*** 04/27/07 10:42 am ***

*** 05/01/07 07:19 am ***

*** 05/01/07 05:18 pm ***

*** 05/02/07 10:22 am ***

*** 05/03/07 09:57 am ***

*** 05/04/07 02:32 am ***

*** 05/04/07 10:10 am ***

*** 05/05/07 03:54 am ***

*** 05/06/07 04:06 am ***

*** 05/07/07 05:38 pm ***

*** 05/09/07 12:17 am ***

*** 05/15/07 08:38 am ***

*** 05/17/07 09:07 am ***

*** 05/17/07 01:49 pm ***

*** 05/24/07 06:16 am ***

*** 05/25/07 06:54 pm ***

*** 05/29/07 07:48 pm ***

*** 07/12/07 10:09 pm ***

*** 07/16/07 01:25 pm ***

*** 07/16/07 01:25 pm ***

*** 08/01/07 04:19 pm ***

*** 08/21/07 05:28 pm ***

*** 08/21/07 05:30 pm ***

*** 08/21/07 09:41 pm ***

*** 08/21/07 09:41 pm ***

*** 08/22/07 12:31 am ***

*** 08/29/07 07:25 am ***

*** 08/29/07 07:27 am ***

*** 09/09/07 10:50 pm ***

*** 10/09/07 03:56 am ***

*** 10/09/07 07:08 am ***

*** 10/09/07 07:08 am ***

*** 10/22/07 06:51 pm ***

*** 12/19/07 05:40 pm ***

*** 12/19/07 05:40 pm ***

*** 01/11/08 12:32 pm ***

*** 01/13/08 10:45 pm ***

*** 01/13/08 10:45 pm ***

*** 01/28/08 03:27 am ***

*** 01/28/08 05:07 am ***

*** 01/28/08 05:07 am ***

*** 02/28/08 04:23 am ***

*** 02/28/08 05:32 am ***

*** 02/28/08 05:32 am ***

*** 08/08/08 06:09 am ***

*** 08/22/08 03:38 am ***

*** 08/22/08 03:38 am ***

*** 11/28/08 04:25 am ***

*** 11/28/08 07:39 am ***

*** 11/28/08 07:39 am ***


SELECT TYPE TAF FAILES WITH ORA-3135 IF NETWORK CABLE PULLED OFF

 

Bug No.

5386346

Filed

12-JUL-2006

Updated

16-JUL-2006

Product

Oracle Server - Enterprise Edition

Product Version

10.2.0.2.0

Platform

HP-UX Itanium

Platform Version

11.23

Database Version

10.2.0.2.0

Affects Platforms

Generic

Severity

Severe Loss of Service

Status

Suspended, Req'd Info not Avail

Base Bug

N/A

Fixed in Product Version

No Data


Problem statement:

RECO PROCESS CRASHED BY EXCEPTION SIGNAL 11 (KGEADP)

 

 

*** 07/12/06 02:37 am ***

TAR:

----

5588060.992

.

PROBLEM:

--------

.

Distributed transaction was failed.

And reco process was crashed by exception signal (kgeadp) after some minutes.

When instance crased core file was generated. 

I get call stack from core file using gdb. 

.

.

alert.log : 

~~~~~~~~~~~~~~~

Thu Jul 6 18:13:22 2006

Error 3135 trapped in 2PC on transaction 10.3.16071. Cleaning up.

Thu Jul 6 18:13:22 2006

Error stack returned to user:

ORA-02050: Æ®·£Àè¼Ç 10.3.16071°¡ ·Ñ¹éµÇ°í, ´Ù¸¥ ¿ø°Ý DB´Â ºÒ¸í·áÇÑ »óÅÂÀÔ´Ï´Ù

ORA-03135: Á¢¼ÓÀÌ ²÷°å½À´Ï´Ù.

Thu Jul 6 18:13:22 2006

DISTRIB TRAN DSWIAA.c611e5a4.10.3.16071

 is local tran 10.3.16071 (hex=0a.03.3ec7)

 insert pending collecting tran, scn=8849325338789 (hex=80c.64e4b0a5)

Thu Jul 6 18:28:40 2006

Errors in file 

/fsoracle/app/oracle/admin/DSWIAA/bdump/dswiaa01_pmon_4564.trc:

ORA-00476: RECO process terminated with error

Thu Jul 6 18:28:40 2006

PMON: terminating instance due to error 476

Instance terminated by PMON, pid = 4564

Thu Jul 6 18:38:06 2006

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

.

.

RECO process : 

~~~~~~~~~~~~~~~~~

*** 2006-07-03 18:25:57.190

DISTRIB TRAN DSWIAA.c611e5a4.6.29.9495

 is local tran 6.29.9495 (hex=06.1d.2517))

 delete pending collecting tran, scn=8848798224722 (hex=80c.45799152)

*** 2006-07-06 18:28:37.545

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 

0x1fe800000000, PC: [0x40000000034c4f60, kgeadp()+992]

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 

0x1fe800000000, PC: [0x40000000034c4f60, kgeadp()+992]

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 

0x1fe800000000, PC: [0x40000000034c4f60, kgeadp()+992]

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 

0x1fe800000000, PC: [0x40000000034c4f60, kgeadp()+992]

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 

0x1fe800000000, PC: [0x40000000034c4f60, kgeadp()+992]

Background_Core_Dump = partial

.

.

DIAGNOSTIC ANALYSIS:

--------------------

I was trying to find out related information in webiv.

The stack of core file is similar with bug 4496339. 

.

WORKAROUND:

-----------

.

.

RELATED BUGS:

-------------

4496339 (10.1.0.4)

.

REPRODUCIBILITY:

----------------

.

.

TEST CASE:

----------

.

.

STACK TRACE:

------------

reco : 

~~~~~~~~

.

kgeadp

.

.

core file stack : 

~~~~~~~~~~~~~~~~~

.

    kill slcra ssexhd kgeadp kgerev kserec4 

    ssexhd kgeadp kgerev kserec4 ssexhd kgeadp 

    kgerev kserec4 ssexhd kgeadp kgerev kserec4 

    ssexhd kgeadp kgerev kserec4 ssexhd kgeadp 

    kgeade kgesev ksesec2 OCIKNSECA npicon0 k2nrec 

    k2vrec k2vdrv ksbabs ksbrdp opirip opidrv 

    sou2o opimai_real main 

.

.

SUPPORTING INFORMATION:

-----------------------

.

.

24 HOUR CONTACT INFORMATION FOR P1 BUGS:

----------------------------------------

.

.

DIAL-IN INFORMATION:

--------------------

.

.

IMPACT DATE:

------------

.

.

*** 07/12/06 02:40 am ***

*** 07/12/06 05:02 am *** (CHG: Asg->NEW OWNER)

*** 07/12/06 06:45 am *** (CHG: Sta->11)

*** 07/12/06 06:45 am ***

*** 07/12/06 06:47 am *** (CHG: SubComp->PI/DISTRIB)

*** 07/12/06 06:49 am *** (CHG: SubComp->PRG INT/DISTR)

*** 07/12/06 06:50 am *** (CHG: SubComp->PRG INTERFACE)

*** 07/12/06 06:50 am ***

*** 07/12/06 06:50 am *** (CHG: Asg->NEW OWNER)

*** 07/12/06 06:50 am ***

*** 07/12/06 06:50 am ***

*** 07/12/06 09:12 pm *** (CHG: DevPri->2)

*** 07/12/06 09:12 pm *** (CHG: Confirmed Flag->Y)

*** 07/12/06 09:12 pm *** (CHG: Sta->30)

*** 07/12/06 09:12 pm ***

*** 07/16/06 07:01 pm *** (CHG: Sta->33)

*** 07/16/06 07:01 pm ***

转载于:https://www.cnblogs.com/kevinsun/archive/2009/10/14/1583358.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值