ORA-01591 lock held by in-doubt distributed transaction stringCause: 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.
解决方案 »
- oracle 服务问题
- 添加到表中的编号显示成了#,在线等
- 怎样把TNSLSNR.EXE加入到WIN2000服务中?
- C++通过ado查询oracle内数据出错
- 还是表连接问题,如果是以下情况呢,该怎么写?
- 很困难select 语句问题?
- 9i,安装系统的时候已经建了oradb库,为了使用console,建了资料库oemrep,但我sql*plus连接的时候,好像联到oemrep,不是联oradb,怎样联orad
- 请教SQL语句写法
- oracle8.1.7中用哪个用户可以执行RECOVER DATABASE,来恢复数据库。
- oracle中可以实现动态字段名么
- 一个很怪异的问题!
- 在win2000下的活动目录是否可以不配置,来装oracle9i?
看看EVENT字段有没有row_calche_lock ,KILL掉这些会话试试。