Hi All
And thanks in advance.
We are performing RAC failover testes, and we run into hang \ in-doubt transaction state TMGDECIDED are we missing privileges ?.
seems like the database refuse to commit in status TMGREADY ? odd
tmadmin (pt) :
index=1 gtrid=x0 x4d65989f x73f
: Machine id: MSTR, Transaction status: TMGDECIDED
Group count: 2,
Known participants:
group: QUEUESPACEGRP, status: TMGDONE, local, coord
group: CPAGRP, status: TMGREADY, local
database:
select * from dba_2pc_pending;
1 10.15.14909 40.73756E6D3530303000000000000000000000000000000000000000000000000000048CA04D65989F0000073F prepared >no 2/24/2011 1:27:02 AM 2/24/2011 2:16:06 AM gppbac sun7000 7937150
xa log (grep) :
xaoprepare: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x0
xaocommit: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x10000000
xaocommit: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x10000000
xaocommit: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x10000000
xaocommit: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x10000000
xaocommit: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x10000000
xaocommit: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x10000000
xaocommit: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x10000000
xa log :
014010.27131.1.0:
xaocommit: xid=0x28-73756e6d3530303000000000000000000000000000000000000000000000000000048ca04d65989f0000073f-0000001400000032, rmid=0, flags=0x10000
000
014010.27131.1.0:
OCITransCommit: Attempting
014010.27131.1.0:
OCITransCommit return code: -1
014010.27131.1.0:
ORA-01031: insufficient privileges
014010.27131.1.0:
xaoclose_fail: rmid=0
ORACLE XA: Version 10.2.0.1.0. RM name = 'Oracle_XA'.
014010.27131.1.0:
xaocommit: rtn -7
ORACLE XA: Version 10.2.0.1.0. RM name = 'Oracle_XA'.
014010.27131.1.0:
xaosdf: rmid = 0 flags = 0xf
Thanks
Techsgin
Edited by: TechSgin on Feb 23, 2011 5:05 PM