|
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
|