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.