Database Administration (MOSC)

MOSC Banner

Time Zone Patching (TSTZ) Error - DST_UPGRADE_STATE -> DATAPUMP(1)

Hi All,

Our DB version is 19c

We have encountered errors related to datapump during our time zone patching. We did not see the same in our non-prod instances. We can see that as per Doc ID 1509653.1, DST_UPGRADE_STATE value should be “NONE” for DATABASE_PROPERTIES view.

This is the actual error/code:

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

We followed the note - How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ? (Doc ID 336014.1) to solve the problem where we tried to cleanup the orphaned DataPump jobs. Still the below value for DST_UPGRADE_STATE showing as DATAPUMP(1). We did try to bounce the database, which also didn’t work.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center