12.2 E-Business Suite Applications DBA Online Patching ADOP Utilities Fail With Error 'ORA-20010 Unable to acquire lock on ad_adop_sessions Table'
(Doc ID 1903316.1)
Last updated on MAY 04, 2024
Applies to:
Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2Cloud]Information in this document applies to any platform.
Purpose
Resolution of adop failure error:
[ERROR] Failed to execute sql statement :
begin
AD_ZD_ADOP.LOCK_SESSIONS_TABLE('<hostname>',60,2);
end;
[ERROR] SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 -
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> begin
*
ERROR at line 1:
ORA-20010: ERROR: Unable to acquire lock on ad_adop_sessions table. LOCK row
seems to have been inserted by another session
ORA-06512: at "APPS.AD_ZD_ADOP",
begin
AD_ZD_ADOP.LOCK_SESSIONS_TABLE('<hostname>',60,2);
end;
[ERROR] SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 -
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> begin
*
ERROR at line 1:
ORA-20010: ERROR: Unable to acquire lock on ad_adop_sessions table. LOCK row
seems to have been inserted by another session
ORA-06512: at "APPS.AD_ZD_ADOP",
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Purpose |
Troubleshooting Steps |