RDBMS DST Timezone update failed with ORA-04098: trigger is invalid (Doc ID 2921346.1)

Last updated on JANUARY 18, 2023

Applies to:

Symptoms

While updating DST Timezone version from 34 to 38 , it failed with ORA-04098 error :

SQL>@utltz_upg_apply.sql

DECLARE
*
ERROR at line 1:
ORA-04098: trigger 'trigger name' is invalid and failed
re-validation
ORA-06512: at "SYS.DBMS_DST", line 1131
ORA-06512: at "SYS.DBMS_DST", line 611
ORA-06512: at "SYS.DBMS_DST", line 209
ORA-06512: at "SYS.DBMS_DST", line 858
ORA-06512: at "SYS.DBMS_DST", line 596
ORA-06512: at "SYS.DBMS_DST", line 1123
ORA-06512: at line 11

Currently DST_UPGRADE_STATE shows as UPGRADE :

SELECT *
FROM database_properties
WHERE property_name LIKE 'DST_%'
ORDER BY property_name;

PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------------ ------------------------------ ----------------------------------------
DST_PRIMARY_TT_VERSION 38 Version of primary timezone data file
DST_SECONDARY_TT_VERSION 34 Version of secondary timezone data file
DST_UPGRADE_STATE UPGRADE State of Day Light Saving Time Upgrade

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.