My Oracle Support Banner

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 JANUARY 29, 2023

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2Cloud]
Information in this document applies to any platform.


Resolution of adop failure error:

[ERROR]     Failed to execute sql statement :

[ERROR]     SQLPLUS error: buffer=
SQL*Plus: Release -
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
Troubleshooting Steps

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