date and time not matching

[VIRENDER SINGH_1]

hi ,

OS: HP-UX 11i
Oracle 10g (10.2.0.1)

I am using four servers(hp 9000 rp 3440).
a1 and a2 for application servers.
d1 and d2 for database servers.(RAC is implemented).

one of database server's date is not matching with other three servers date.
what is the reason and how to correct it ?

Thanks.

[Jannik]

It might be the timezone on you machine to change that use set_parms.
If it is just a small amount then it is the build in clock in the hardware that is drifting. The recommendation is to use a timeserver. You can configure that form "sam".

Please assign point to you questions!

[Marco A.]

Hello,


Oracle runs in a different environment, check the profile that you have set for the oracle user, timezone, etc, and make it match with the one that you have for the root account.

That's a good start point, check that and let us know.

Regards,


Marco

[Hein van den Heuvel]

How big is the difference?
a whole number of hours?
If the drift is less than a timezone, then check out using a timeserver.

Google for: hpux ntp

Good luck,
Hein.