关于03106: fatal two-task communication protocol error

zy_ly

TRACE文件如下内容


PARSING IN CURSOR #1 len=37 dep=0 uid=64 oct=3 lid=64 tim=18446744073140484457 hv=1516073560 ad='6523224c'
select * from view_ttt
END OF STMT
PARSE #1:c=15625,e=89187,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=18446744073140484447
WAIT #1: nam='SQL*Net message to dblink' ela= 9 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net message from dblink' ela= 731 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net message to dblink' ela= 2 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net message from dblink' ela= 18396 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net more data from dblink' ela= 7 p1=675562835 p2=1 p3=0
EXEC #1:c=15625,e=39867,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=18446744073140548423
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 71 p1=1413697536 p2=2001 p3=0
FETCH #1:c=0,e=277,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=18446744073140560920
WAIT #1: nam='SQL*Net message from client' ela= 1754 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message to dblink' ela= 3 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net message from dblink' ela= 1654 p1=675562835 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=15625,e=14219,p=0,cr=0,cu=0,mis=0,r=8,dep=0,og=4,tim=18446744073140584975
WAIT #1: nam='SQL*Net message from client' ela= 732 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net break/reset to client' ela= 316 p1=1413697536 p2=0 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 363 p1=1413697536 p2=1 p3=0
WAIT #0: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0

zy_ly

渴望

zy_ly

up

zy_ly

没人知道吗

oracle-plus

我也曾經遇到這種情況，但是只是偶然的發生，自己會好的。

goldensun

我想原因可能在于你的TTT表中包含高版本里新增的数据类型，比如DATESTAMP等，更换客户端版本试一下或者你只选择一个常见类型的字段看能否正常显示

zy_ly

没有任何新增的数据类型，如果直接访问没问题，或者通过◎dblink访问表也没问题，就是通过视图不行

zy_ly

up

zy_ly

版主能否解释一下？？？