SOLUTION
Apply patch:13417321 DST 18 : HALF YEARLY DST PATCHES, MAY 2012 to the 11.2.0.3 database.
The timezone Etc/UTC support for Oracle database 11.2.0.3.0 is added via DSTv18 Patch 13417321.
Refer to:
Bug 13417321 - DST 18 : HALF YEARLY DST PATCHES, MAY 2012
Applying the DSTv18 update for the Oracle Database (Doc ID 1448706.1)
Or
As a workaround, set the TZ variable to UTC ($ export TZ=UTC) or use -Duser.timezone=UTC to change it in the JVM. Then, restart the application.
Or
set the connection property oracle.jdbc.timezoneAsRegion to "false".
(This option is not recommended as it will revert to sending a fixed offset on the connection and can reintroduce incorrect DST related behavior, which is why the change in JDBC to use timezone name/region directly if it is a known Oracle one rather than convert to a GMT offset was done in the first place).
Niciun comentariu:
Trimiteți un comentariu