ORA-02087: object locked by another process in same transaction

ORA-02087: object locked by another process in same transaction
Cause: A database link is being used in the cluster database environment that loops back to the same instance. One session is trying to convert a lock that was obtained by the other session.
Action: Get the more restrictive lock first. For example, if session 1 gets a share lock and session 2 gets an exclusive lock on the same object, get the exclusive lock first. Or, simply use the same session to access the object.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02087：同一事务中另一个进程锁定的对象,
.原因：在循环回同一实例的集群数据库环境中使用数据库链接。一个会话正在尝试转换另一个会话获取的锁。,
.操作：首先获取更严格的锁定。例如，如果会话1获取共享锁，并且会话2获得对同一对象的排它锁，那么首先获取排它锁。或者，只需使用相同的会话来访问对象。,
.

aiaiDBA

13718043309

010-86462881

ORA-02087: object locked by another process in same transaction

1 个回答

相似问题