ORA-01591 lock held by in-doubt distributed transaction num

[Michaelyfj]

我在做快照时，提示
ORA-01591 lock held by in-doubt distributed transaction 19.4.16的错误！
请问该如何解决！

[Michaelyfj]

why！！！

[guostong]

表被别人锁住了，
你的数据库是分布式吗？

[Michaelyfj]

两个数据库之间没有直接的关系，只是做快照而已！

[guostong]

别的表可以做快照吗？

[guostong]

书上说你可能有一个会话访问此表还未提交，查查看

[guostong]

你在 DBA_2PC_PENDING 中看看有没有死的会话，KILL之

[Michaelyfj]

我从一台Master Oracle Server向另一台服务器做快照，出现了如上问题？
to guostong:
表被别人锁住：“别人”指的是谁？

[guostong]

别人指别的会话，
你的两个数据库之间有什么关系吗？

[Michaelyfj]

to guostong:
有一个死会话, 如何Kill它.
我在删除快照时出错,信息如下:

SQL> drop snapshot t_road;
drop snapshot t_road
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01591: lock held by in-doubt distributed transaction 19.4.16

[Michaelyfj]

我用delete from dba_2pc_pending删除掉,同样有以上问题.

[Michaelyfj]

救救我啊！

[emily_wang]

ORA-01591 lock held by in-doubt distributed transaction string

Cause: An attempt was made to access resource that is locked by a dead two-phase commit transaction that is in prepared state.

Action: The database administrator should query the PENDING_TRANS$ and related tables, and attempt to repair network connection(s) to coordinator and commit point. If timely repair is not possible, the database administrator should contact the database administrator at the commit point if known or the end user for correct outcome, or use heuristic default if given to issue a heuristic COMMIT or ABORT command to finalize the local portion of the distributed transaction.

[Michaelyfj]

在Instance Manager中有很多InActive的进程，如何把他们kill掉!