ORA-03135 ,ORA-02050到底什么原因？
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 ***
