Global Enqueue Services Deadlock detected. More info in file
根据oracle notes http://blog.csdn.net/card_2005/article/details/8098584
这个报错匹配第五个章节LB deadlock,这类问题大多数都是oracle bug引起。
*** 2012-10-18 19:49:29.048
Submitting asynchronized dump request [28]----------enqueue 0x14b542dce8------------------------
lock version : 18673
Owner node : 2
grant_level : KJUSERNL
req_level : KJUSEREX
bast_level : KJUSERNL
notify_func : 0x408306c
resp : 0x159ed474e8
procp : 0x14c30b58e0
pid : 0
proc version : 74
oprocp : (nil)
opid : 0
group lock owner : (nil)
xid : 0000-0000-00000000
dd_time : 0.0 secs
dd_count : 0
timeout : 0.0 secs
On_timer_q? : N
On_dd_q? : N
lock_state : GRANTED
Open Options : KJUSERNO_XID
Convert options : KJUSERGETVALUE
History : 0x77d497ad
Msg_Seq : 0x1
res_seq : 22
valblk : 0x8012da0aff7f00000000000000000000 .
Global blockers dump end:-----------------------------------
Global Wait-For-Graph(WFG) at ddTS[0.41bdc] :
BLOCKED 0x14c3f1d8d8 5 wq 2 cvtops x1 TX 0x4010006.0x84b98 [17F000-0002-04B16F1F] inst 2
BLOCKER 0x13c983d5f0 5 wq 1 cvtops x28 TX 0x4010006.0x84b98 [2F9000-0003-0101469D] inst 3
BLOCKED 0x14023c8318 5 wq 2 cvtops x1 TX 0x255001b.0x39332 [2F9000-0003-0101469D] inst 3
BLOCKER 0x147da4cf48 5 wq 1 cvtops x28 TX 0x255001b.0x39332 [17F000-0002-04B16F1F] inst 2
* Cancel deadlock victim lockp 0x14c3f1d8d8