Oracle sysdate and dates showed on banners are different !!!

[Alvaro Altair]

I have a HP L3000 / S800 running HPUX 11.00 with Oracle 8.0 installed,
Oracle sysdate and dates showed on banners are different (in minutes) from OS date. The OS is correct time. After rebooting the box the times were syncronized, but day after day the difference is growing minutes/seconds ahead.
What patch, resolve this issue? Thanks

[harry d brown jr]

Are you running xntpd ?

Is this part of some cluster?

I could explain hour(s) difference, but minutes is just weird! Is it possible you are near some space time continum rift?

live free or die
harry d brown jr

[Stephen Keane]

Is the battery OK?

[Alvaro Altair]

Hello,

No running xntp
Batery Ok,
No part of cluster

Oracle depends on gettimeofday() OS function for the evaluation of system date (sysdate).

I could find 2 Bugs logged with Oracle for similar issue:

Bug 3184388 SYSDATE VALUE ARE INCORRECT Platform is HP 9000 Series HP-UX (64-bit) and Oracle version 9.2.0.4

Bug 3378615 SYSDATE WILL VARY BY AS MUCH AS 45 SECONDS FROM UNIX SYSTEM DATE Platform is H
P 9000 Series HP-UX (32-bit) and Oracle version is 8.1.7.3

The problem seems to hang around the gettimeofday(),


Sample test:

SQL> select to_char(sysdate,'dd/mm/yy hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'
-----------------
18/02/05 11:16:11
SQL> !date
Fri Feb 18 11:11:59 SAT 2005


Thanks

[Jean-Luc Oudart]

Hi,

I tried on rp5470 (L-Class) an I don't have any difference between SYSDATE and OS date.
I run oracle 8174

Regards
Jean-Luc

[Alvaro Altair]

Hi,

My oracle is 806

Thanks