Global Enqueue Services Deadlock detected解决思路

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