ntp usage on a machine out of sync
Just to check my sanity. We had a machine which was 7 mins out, due to ntp peers being blocked by firewall. After the issue was cleared, I brought, the time to within 2 mins, using DATE command. Then I used ntpdate command several times to get the time approximately right. Once it was right, I enabled ntp. I was told by my peers that I was wrong, and it would affect the Oracle database. The best way to do this is the let the machine come to the correct time on it's own. I don't understand that, having installed 100s of machines, am I missing something? What happens during summer/winter time changes, when an hour change occurs in one step? Does it not affect the database?