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 FEBRUARY 25, 2021
Applies to:Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.
E-Business Suite 12.2 Applications DBA, Patch Application Issues
Running the ADOP cleanup phase fails with the following error:
[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
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
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