Managing Applications using Enterprise Manager (MOSC)

MOSC Banner

AMP 13.5.1 with 12.2.13 AD/TXK Delta 15 creates patch edition sessions which block adop cleanup

I have applied thousands of 12.2 patches with AMP installed, but yesterday on 13.5.1 AMP and upgrade to 12.2.13 and 19.21, AMP is creating EM_MONITOR sessions in the patch edition which cause adop cleanup to be unable to drop the old patch edition.

Processing cleanup actions in parallel.

  Log: /u01/oracle/prd122/fs_ne/EBSapps/log/adop/23/20240108_214312/cleanup/oel7mt/log/cleanup.log


Generating report of queued DDL actions.

  Output: /u01/oracle/prd122/fs_ne/EBSapps/log/adop/23/20240108_214312/cleanup/oel7mt/adzdallddls.out


Running cleanup in STANDARD mode.

  Log: @ADZDSHOWLOG.sql "2024/01/08 21:43:55"

  [ERROR]   ORA-38805: edition is in use, SQL: drop edition "V_20240108_1500" cascade

  [ERROR]   Please run the script $AD_TOP/patch/115/sql/ADZDKILLOLDSESSIONS.sql to resolve ORA-38805: edition is in use issue

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center