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:
- 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;
/ |
|