ORA-02068: following severe error from REMOTEDB

netbanker

I suspect it is network related issue. there is way to trace network issue by oracle, search metalink

oradbHome

原帖由 Yong Huang 于 2010-5-27 01:05 发表
Any other error? ORA-2068 is too generic.

If it's reproducible, or happens very frequently, do SQL trace on the local session and also the remote session. If that doesn't reveal anything (after the error occurs), you probably have to try SQL*Net trace. Reading that trace file is not easy.

Yong Huang

Thanks.

There is only error ORA-02068 and ORA-03135

when happens , I can find out local database session sid , but How I can find out the remote Database session sid ? User db link username and session status is active can to judge the Remote Database session SID ?

the following log  is the local  Database 10046 event .

WAIT #58: nam='SQL*Net message from dblink' ela= 904799061 driver id=1413697536 #bytes=1 p3=0 obj#=115996 tim=1244400514951208
WAIT #58: nam='SQL*Net break/reset to dblink' ela= 2 driver id=1413697536 break?=1 p3=0 obj#=115996 tim=1244400514951282
WAIT #58: nam='SQL*Net break/reset to dblink' ela= 16 driver id=1413697536 break?=0 p3=0 obj#=115996 tim=1244400514951306
ERROR #31:err=2068 tim=2572401936
=====================

[ 本帖最后由 oradbHome 于 2010-5-27 09:46 编辑 ]

Yong Huang

原帖由 oradbHome 于 2010-5-26 19:40 发表
How I can find out the remote Database session sid ? User db link username and session status is active can to judge the Remote Database session SID ?

See message #2 of http://www.itpub.net/thread-1307296-1-1.html

Also, run this SQL in both local and remote DBs as sys:

select /*+ ordered */ substr(s.ksusemnm,1,10)||'-'|| substr(s.ksusepid,1,10) origin, substr(g.k2gtitid_ora,1,35) gtxid, substr(s.indx,1,4)||'.'|| substr(s.ksuseser,1,5) lsession, s.ksuudlna username, substr(decode(bitand(ksuseidl,11), 1,'ACTIVE', 0, decode( bitand(ksuseflg,4096) , 0,'INACTIVE','CACHED'), 2,'SNIPED', 3,'SNIPED', 'KILLED'),1,1) status, e.kslednam waiting
from x$k2gte g, x$ktcxb t, x$ksuse s, x$ksled e
where g.k2gtdxcb=t.ktcxbxba and g.k2gtdses=t.ktcxbses and s.addr=g.k2gtdses and e.indx=s.ksuseopc;

(Original author: an Oracle employee; publicized by Mark Bobak)

oradbHome

怪了。 今天一直没有出现这个错误。

mingdaoblack

Tue May 15 20:32:23 2012
Error 2068 trapped in 2PC on transaction 35.3.52382. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from ADB2
ORA-03113: end-of-file on communication channel

sundog315

mingdaoblack 发表于 2012-5-16 08:22
Tue May 15 20:32:23 2012
Error 2068 trapped in 2PC on transaction 35.3.52382. Cleaning up.
Error s ...

2PC transaction错误

可以从网络层面看一下，有时候可能只是一次远程网络的闪断，都容易导致类似的问题。