My Oracle Support Banner

执行ADFIXUSER.sql的时候发生了死锁和ORA-00060错误 (Doc ID 2548557.1)

Last updated on JUNE 01, 2019

适用于:

Oracle E-Business Suite Technology Stack - 版本 12.1.3 到 12.1.3 [发行版 12.1]
本文档所含信息适用于所有平台

症状

On Oracle Applications 12.1.3 version, Database for Application Technology,
执行ADFIXUSER.sql的时候发生死锁并发生了下面的错误:
ORA-00060: deadlock detected while waiting for resource, ORA-06512: at "SYS.AD_ZD_SYS", line 39

下面的步骤可以再现这个问题:
1. 执行EBS (12.1.3)的脚本ADFIXUSER.sql,调用sys.ad_zd_sys.fix_sysuser;

sqlplus -s APPS/**** @/u01/applmgr/patch/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ADFIXUSER.sql

2. 会出现下面的错误:

begin
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.AD_ZD_SYS", line 39
ORA-06512: at line 2

3. 下面这些对象中出现死锁:

USERNAME TERMINAL KILL TABLE_LOCKED LOCK_MODE
--------- ------------ --------- ------------------------- - ------------------
SYS UNKNOWN 1149,7 SYS.WRI$_ADV_OBJSPACE_TR Row Exclusive
SYS UNKNOWN 1149,7 SYS.WRI$_ADV_OBJECTS Row Exclusive
SYS UNKNOWN 1149,7 SYS._NEXT_OBJECT Row Exclusive
SYS UNKNOWN 1149,7 SYS._NEXT_OBJECT Row Exclusive
SYS UNKNOWN 1149,7 SYS.ORA$BASE Share
SYS UNKNOWN 1149,7 HR.IRC_POSTING_CONTENTS Share

 

可以用下面的SQL来确认发生死锁的对象:

select a.session_id,a.oracle_username, a.os_user_name, b.owner "OBJECT OWNER", b.object_name,b.object_type,a.locked_mode from (select object_id, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, LOCKED_MODE from v$locked_object) a,(select object_id, owner, object_name,object_type from dba_objects) b where a.object_id=b.object_id;

 

更改

 

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


文档内容
症状
更改
原因
解决方案

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.