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

最新推荐文章于 2022-08-08 21:10:28 发布

weixin_33755557

最新推荐文章于 2022-08-08 21:10:28 发布

阅读量520

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/kevinsun/archive/2009/10/14/1583358.html

版权

今天上午，产线报告数据库无法使用，赶到机房，发现数据库已经恢复正常，在 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-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-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: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: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/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/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 ***

*** 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/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/22/07 06:51 pm ***

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

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

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

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

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

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

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

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

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

*** 11/28/08 04:25 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: