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 APRIL 04, 2018

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 - Production on Fri May 30 22:29:10 2014
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

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