My Oracle Support Banner

ADOP Cleanup Phase with Full Mode Failed With Error '[UNEXPECTED]Error occurred while calling cleanup plsql API' And ORA-00054 (Doc ID 2527801.1)

Last updated on JULY 11, 2019

Applies to:

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

Symptoms

E-Business Suite 12.2 Applications DBA, Patch Application Issues


Running the ADOP cleanup phase fails with the following error:

[ERROR] Error Message :
[UNEXPECTED]Error occurred while calling cleanup plsql API
[UNEXPECTED]Cleanup phase completed with errors/warnings. Please check logfiles
Log file: /r12/oracle/TEST/fs_ne/EBSapps/log/adop/28/adop_20000000_100000.log

adzdshowlog.out

"APPLSYS"."FND_CONCURRENT_REQUESTS" set unused (RECALC_PARAMETERS)
  10:00:00 00:00:00 ad.plsql.ad_zd_table.cleanup ERROR ERROR: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired, SQL: alter table "APPLSYS"."FND_COCURRENT_REQUESTS"
  14:00:00 04:00:00 ad.plsql.ad_zd.set_edition ERROR Unable to set edition. Invalid edition type : PATCH


The issue can be reproduced at will with the following step:
1. ADOP phase=cleanup cleanup_mode=full

Changes

 

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.