How to Upgrade the TimeZone File Version in Oracle Autonomous Database?

This article will guide you with the steps to upgrade the TimeZone File Version in Oracle Autonomous Database.

In Oracle Autonomous Database, the timezone file version upgrade is very simple. i.e. The manual way of upgrading the timezone file version is not required. Instead, there is a feature called "Auto DST Upgrade" feature which will automatically upgrade the Timezone File Version for you.

So, to first identify what is the latest released timezone file version, you can use the following command:

SQL> SELECT param_name, param_value FROM dba_cloud_config 
WHERE LOWER(param_name) = 'latest_timezone_version';

And, to identify what is the timezone file version applied in your database, you can use the following commands:

SQL> select * from v$timezone_file;

SQL> SELECT type, time, description, expected_start_date FROM db_notifications 
WHERE TYPE='TIMEZONE VERSION';

If you find your timezone file version is not latest, and if you want to automatically upgrade the timezone file version, then simply enable the "Auto DST upgrade" feature using the following command:

BEGIN 
   DBMS_CLOUD_ADMIN.ENABLE_FEATURE(
        feature_name => 'AUTO_DST_UPGRADE');
END;
/

To cross-verify whether the "Auto DST Upgrade" feature is enabled or not, you can use the following command:

SQL> SELECT param_name, param_value FROM dba_cloud_config 
WHERE LOWER(param_name) = 'auto_dst_upgrade';

Once it is enabled, restart the Oracle Autonomous Database to take effect. During the restart, Oracle will check for any newer version of timezone file version and, if it finds it, then it will automatically upgrade the timezone file version to the latest version. After the restart completion, you will find that the timezone file version is upgraded.

select * from v$timezone_file;

Hope, this article is helpful to you!!.. Happy reading!!..