My Oracle Support Banner

ADPATCH in Patch 28888636 Got ORA-04021 and Hang (Doc ID 2634494.1)

Last updated on FEBRUARY 08, 2020

Applies to:

Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

Applying Patch 28888636 got error and hang.

Adworker log below.

ERROR
-----------------------
package /oracle/<SID>/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/ICXSESEB.pls

Done deactivating PL/SQL compilation.

AD Worker error:
ORA-04021: timeout occurred while waiting to lock object


Failed to execute statement. Statement is

create or replace package body icx_sec as
/* $Header: ICXSESEB.pls 120 ...

AD Worker error:
ORA-04021: timeout occurred while waiting to lock object


Done resetting PL/SQL compilation.

Unable to process file in PACKAGE mode.

Not converting file for Invoker's Rights because it appears to
be a package body creation script (based on the filename).
 File is: /oracle/<SID>/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/ICXSESEB.pls


sqlplus -s APPS/***** @/oracle/<SID>/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/ICXSESEB.pls
Connected.
create or replace package body icx_sec as
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object

Changes

None

Cause

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
Symptoms
Changes
Cause
Solution
References


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