ORA-56920 ERROR WHILE DOING THE TIMEZONE UPGRADE : 
****************************************************

ERROR:

SQL> EXEC DBMS_DST.BEGIN_UPGRADE(23);

BEGIN DBMS_DST.BEGIN_UPGRADE(23); END;

*

ERROR at line 1:

ORA-56920: a prepare or upgrade window or an on-demand or datapump-job loading of a secondary time zone data file is in

an active state

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

ORA-06512: at "SYS.DBMS_DST", line 1162

ORA-06512: at line 1

While investigating to sort out this we found previous time zone upgrade to DST 17 was incomplete and below are the details.

We checked primary and secondary time zone version,it is as below.But,DST_SECONDARY_TT_VERSION value  should be 0.

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         17

DST_SECONDARY_TT_VERSION       11

DST_UPGRADE_STATE              UPGRADE

We have followed below procedure to made DST 17 upgrade complete. After completing  the upgrade, DST_SECONDARY_TT_VERSION automatically changed from 11 to 0.

FIX:

*****

SQL> VAR fail number

BEGIN

DBMS_DST.END_UPGRADE(:fail);

DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);

END;

SQL>   2    3    4    5

  6  /

An upgrade window has been successfully ended.

Failures:0

PL/SQL procedure successfully completed.

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         17

DST_SECONDARY_TT_VERSION       0

DST_UPGRADE_STATE              NONE

Hence the above issue got resolved and now we are able to upgrade the  time zone as usual.