Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time
Zone File Patches (Doc ID 412160.1)
<Note 2893289.1> Applying the DSTv39 update for the Oracle Database
RDBMS Patch 34533061
unzip -d <PATCH_TOP_DIR> p34533061_190000_Linux-x86-64.zip
cd <PATCH_TOP_DIR>/34533061
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
The OJVM DSTv39 patch 34533150
unzip -d <PATCH_TOP_DIR> p34533150_190000_Generic.zip
cd <PATCH_TOP_DIR>/34533150
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd <PATCH_TOP_DIR>/34533150
opatch apply
Check Timezone
sqlplus / as sysdba
alter session set container=TEST;
SELECT version FROM v$timezone_file;
@utltz_upg_check.sql
@utltz_upg_apply.sql
Etiketler :
Oracle