we are currently developing some application using webspear ( WSAD)
we are using two phase commit.
I am geting ora-1591 error for few tables.
I have searched all oracle documentation and followed the step given there but this error is still not resolved.
When I am giving commit force it says no such transaction pending.
When I see pending_Transactions$ table, then there are no records are shown there but when I see the pending_session$ table two session are show.
I tried to give rollback force < transaction id > for both the transaction but it gives same error as not such pending transactions.
As of today, I am unable to use few tables, since they are locked and
I don't now how to release these lock.
can any one help on this?
You did the work on your side, but have you checked the other side (the remote database/instance?)
There is always the ultimate, bounce both instances.