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

This blog is intended for Oracle DBA’s who are tasked with patching the database.

 

ISSUE:

 

Applied DSTv40 patch#3469179 and noticed that time zone of PDB is not updated.

Root container version time zone is 40 but pluggable database time zone version is 35.

 

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

 

 

CAUSE:

Patch didn’t get applied to PDB

SOLUTION:

  1. Connect to PDB and run DBMS_DST.begin upgrade procedure.

 

sqlplus / as sysdba

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;

/

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Recent Posts

Start typing and press Enter to search