This discussion is archived
3 Replies Latest reply: Dec 20, 2012 6:12 AM by LaserSoft RSS

SYSDATE in oracle database RAC is different from OS date

Mdht Newbie
Currently Being Moderated
Hi all,
I have a problem about datetime in database Oracle and OS is difference:
Database Oracle RAC version 11.2.0.3. 2 nodes rac: node1 and node2
Os: Redhat 6.3
My servers are using NTP.

when I reboot server, database was started automatically. I check time (by select sysdate) is 07:00 AM.
But in OS I check (by SQL> !date) time is 21:00 PM

Then I shutdown database and startup again. now the date in database (sysdate) and the date in OS are the same.

I don't know the reason of problem.
The date is difference only case reboot server. So the problem belong to database or OS or network?

thanks so much!

Edited by: Omni on Dec 19, 2012 12:30 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points