暂无图片
分享
David008
2019-05-22
dblink 异常(可查询,但是创建视图时异常)

用户可正常执行dblink查询语句(该dblink为私有 对应的用户为busi,具备ceate any view权限),但是在执行create view xxx as select * from xx@tstacct;时报出ORA-02019: connection description for remote database not found ,

10046事件信息如下:

/ora10g/admin/crmcl/udump/crmcl1_ora_266642_ybb.trc

*** TRACE DUMP CONTINUED FROM FILE /ora10g/admin/crmcl/udump/crmcl1_ora_266642.trc ***


EXEC #1:c=0,e=6238,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=26738351357944

WAIT #1: nam='SQL*Net message to client' ela= 2 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=26738351357967

WAIT #1: nam='SQL*Net message from client' ela= 7304565 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=26738358662556

XCTEND rlbk=0, rd_only=1

=====================

PARSING IN CURSOR #2 len=85 dep=0 uid=35 oct=21 lid=35 tim=26738358662967 hv=0 ad='1048fc08'

create view acct.charge_item_due_201905 as select * from acct.charge_item_due@tstacct

END OF STMT

PARSE #2:c=0,e=330,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=26738358662964

BINDS #2:

EXEC #2:c=0,e=234,p=0,cr=0,cu=2,mis=0,r=0,dep=0,og=1,tim=26738358663237

ERROR #2:err=2019 tim=1231442558

WAIT #2: nam='log file sync' ela= 67893 buffer#=193 p2=1846586545 p3=0 obj#=-1 tim=26738358731221

WAIT #2: nam='SQL*Net break/reset to client' ela= 1 driver id=1650815232 break?=1 p3=0 obj#=-1 tim=26738358731247

WAIT #2: nam='SQL*Net break/reset to client' ela= 43 driver id=1650815232 break?=0 p3=0 obj#=-1 tim=26738358731300

WAIT #2: nam='SQL*Net message to client' ela= 1 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=26738358731314

*** 2019-05-22 13:24:20.312

WAIT #2: nam='SQL*Net message from client' ela= 7909359 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=26738366640701

PARSE #1:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=26738366640778

EXEC #1:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=26738366640845 


收藏
分享
1条回答
默认
最新
David008
问题已关闭: 经测试 dblink改成public后正常
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏