Re: leap second oracle

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 22 Jun 2015 16:14:23 -0600
Message-ID: <558888BF.9030803_at_gmail.com>

Since I only have small business and small municipality customers, none of whom need 24x7, I plan on shutting down the databases and hosts and using that opportunity for hardware maintenance. :-)

(As a reminder that not everyone, and not every system, has the 24x7 uptime requirement.)

/Hans

On 22/06/2015 1:19 PM, Anton Bushmelev wrote:
> 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
> |
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 23 2015 - 00:14:23 CEST