leap second oracle

  • From: Anton Bushmelev <djeday84@xxxxxxxxx>
  • To: Oracle-List <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 22 Jun 2015 22:19:57 +0300

Hello guru of oracle-l
how do you plan pass leap seond on lujy 30 of 2015 ?
it is enough to have latest ntp package ? or we need also latest kernel?
what do i found :
а) database side Leap seconds (extra second in a year) and impact on the Oracle database. (Doc ID 730795.1) <https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=730795.1>

..
Oracle RDBMS uses "Unix time", it has no clock of it's own and simply uses the OS to deliver the current time and date.
....
Please work with your systems admin that, if your OS is updated to know about the leap second, to *configure it in such a way it does not report 60 seconds as a OS time when a leap second is added.**
*
b) os side:
as per RH note Resolve Leap Second Issues in Red Hat Enterprise Linux <https://access.redhat.com/articles/15145>
with latest version of ntp client leap second will be added by passing 2 times 59 second and no 60 second will occur

Systems running NTP

|2008-12-31 23:59:59:052549000 UTC <-- 1st occurrence of the 60th second
2008-12-31 23:59:59:259988000 UTC
2008-12-31 23:59:59:465214000 UTC
2008-12-31 23:59:59:669629000 UTC
2008-12-31 23:59:59:873936000 UTC
2008-12-31 23:59:59:079184000 UTC <-- 2nd occurrence of the 60th second
2008-12-31 23:59:59:284011000 UTC
2008-12-31 23:59:59:488648000 UTC
2008-12-31 23:59:59:692691000 UTC
2008-12-31 23:59:59:896577000 UTC
2009-01-01 00:00:00:052378000 UTC
|

Do i miss smth ? or we need just latest ntp and -x flag ?

|ps: sorry for my english
|

Other related posts: