Retire/cleanup edition

Posted by Tom on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Retire-cleanup-edition-tp3499.html

Hi Erman!
Any hints on diagnose ?
Trying to retire editions.
Have run :
adop phase=prepare
adop phase=actualize_all
adop phase=finalize finalize_mode=full
adop phase=cutover
adop phase=cleanup cleanup_mode=full

restarted db , have run exec sys.ad_zd_sys.retire_old_editions;
adop phase=cleanup cleanup_mode=full

Editions  are still there. And no dangling objects, no erros in cleanup phase
SQL> @ADZDSHOWCOBJS.sql
=================================================================== Covered Objects per Edition
=================================================================Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> @ADZDSHOWCOBJX.sql
=========================================================================
= Covered Objects
=========================================================================


The old editions still there:
SQL> @ADZDSHOWED.sql
================================================================
= Editions
=====
Edition Name Type Status Current?
--------------- -------- -------- --------
ORA$BASE ACTIVE
V_20170908_1602 ACTIVE
V_20170911_1702 OLD ACTIVE
V_20170915_1405 RUN ACTIVE CURRENT


 adopscanlog -latest=yes
No errors

I could drop editions directrly, but would like to know whats wrong .
so, any hints how to diagnose further ?

Thx,Tom