Retire/cleanup edition

classic Classic list List threaded Threaded
4 messages Options
Tom
Reply | Threaded
Open this post in threaded view
|

Retire/cleanup edition

Tom
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
Reply | Threaded
Open this post in threaded view
|

Re: Retire/cleanup edition

xaheer
Hi,

Are you facing any issues with your patching cycle?

Please check this MOS note "12.2 E-Business Suite Adadmin Fails With 'AD Administration error: ERROR: Patching cycle in progress - run this utility from patch file system. You can only run it from run file system when not patching' (Doc ID 2174397.1)".

It could help.

thanks,
X A H E E R
Reply | Threaded
Open this post in threaded view
|

Re: Retire/cleanup edition

Laurel
Hi!
I am not in patching cycle. SO, the note is  not applicable. But thanks for trying to help! :)

I want to cleanup old editions and inspite that there are no any objects in old editions, oracle is not retiring those..

Br,Tom
Reply | Threaded
Open this post in threaded view
|

Re: Retire/cleanup edition

ErmanArslansOracleBlog
Administrator
Hi,

Lets take a look at the cleanup logs then..
Please send me the latest cleanup (full mode) log.. Lets see what it has done..