Oracle Database 19C Time zone not updated in PDB after applying RDBMS DSTv40 Patch# 3469179

SYS@CTEST>show con_name

CON_NAME

——————————

CDB$ROOT

SYS@CTEST>SELECT VERSION FROM v$timezone_file;

VERSION

———-

40

SYS@CTEST>select TZ_VERSION from registry$database;

TZ_VERSION

———-

40

SYS@CTEST>SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE ‘DST_%’ ORDER BY PROPERTY_NAME;

PROPERTY_NAME                            VALUE

—————————————- —————————————-

DST_PRIMARY_TT_VERSION                   40

DST_SECONDARY_TT_VERSION                 0

DST_UPGRADE_STATE                        NONE

SYS@CTEST>alter session set container=TEST;

Session altered.

SYS@CTEST>show con_name

CON_NAME

——————————

TEST

SYS@CTEST>SELECT VERSION FROM v$timezone_file;

VERSION

———-

35

SYS@CTEST>select TZ_VERSION from registry$database;

TZ_VERSION

———-

35

SYS@CTEST>SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE ‘DST_%’ ORDER BY PROPERTY_NAME;

PROPERTY_NAME                            VALUE

—————————————- —————————————-

DST_PRIMARY_TT_VERSION                   35

DST_SECONDARY_TT_VERSION                 0

DST_UPGRADE_STATE                        NONE

ALTER pluggable DATABASE TEST CLOSE immediate;

ALTER pluggable DATABASE TEST OPEN upgrade;

ALTER SESSION SET CONTAINER=TEST;

SET SERVEROUTPUT ON

DECLARE

BEGIN

DBMS_DST.begin_upgrade(40);

END;

/