Database Administration (MOSC)

MOSC Banner

Cant rollback force or commit a "In-Doubt Transactions"

edited Nov 1, 2012 11:30PM in Database Administration (MOSC) 4 commentsAnswered ✓
11.2.0.1

Hi,

I have a In doubt transactions which I cant rollback or commit.

I found some dosc on metalink, but we dont ahve two nodes, the transactions comes from an application server.

I used

select * from DBA_2PC_PENDING;

to get the global_tran_id/local_tran_id

Its state is prepared.

I have used commit rollback and commit force, but the transaction still remains when query the DBA_2PC_PENDING.

How do I get rid of it?

Regards

S

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center