adzdshowlog.out

Brian Millar

Kyle Harris-Oracle

You did not specifically state what problem or you question you may have, but assuming you're troubleshooting something you're seeing in the log you've provided I see this:

[last 3 lines of the log]

   4960691 2:49:00  00:00:00 ad.bin.adop                                PROCEDURE  [END] Running adzdoptl.pl

   4960691 2:49:00  00:00:00 ad.bin.adop                                EVENT      The cutover phase completed successfully.

   4961963 6:39:12  07:50:11 ad.plsql.ad_zd.set_edition                ERROR      Unable to set edition. Invalid edition type : PATCH

[end]

Looking back into the source code for the AD_ZD package, I've traced this error (*probably*) to the following select failing to produce the proper edition type:

  /* Get default edition first */

  select property_value into l_default

  from   database_properties

  where  property_name = 'DEFAULT_EDITION';

  if x_edition_type = 'RUN' then

     /* RUNTIME edition is always the default */

     l_edition := l_default;

  elsif x_edition_type = 'PATCH' then

     /* PATCH edition is always the child of the default */

     begin

       select aed.edition_name into l_edition

       from   all_editions AED

       where  aed.parent_edition_name = l_default;

     exception

       when no_data_found then

          l_edition := NULL;

     end;

So from this, we can hopefully extrapolate / verify where the issue is.

Find out what the property_value is from the first select.

select property_value

from   database_properties

where  property_name = 'DEFAULT_EDITION';

Then:

select aed.edition_name

from   all_editions AED

where  aed.parent_edition_name = '&result_from_first_select';

If that second select returns no rows, then that is the reason for the error. What we would need to know next is why there is no data.

-Kyle