RE: How to set time difference limit between RAC nodes in 10g

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 18 Sep 2012 19:12:20 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F016C5838B1_at_AAPQMAILBX02V.proque.st>



You don't mention a version. If you're on 11gR2, Clusterware includes Cluster Time Synchronization Service (CTSS). Normally, if you're running NTP, CTSS runs in observer mode, and watches time skew and logs into log files (though I don't remember which log, off the top of my head). If ntp isn't configured on even one of the nodes in the cluster, CTSS goes into active mode, and will manager the time difference. Better to have NTP correctly configured, though.

So, I think the monitoring and logging you're looking for is already there, though I don't specifically recall which logfile it's in.

I'm not sure how far out of sync nodes have to get to be evicted, as I've never seen it happen. Are you actually suffering node evictions due to this, or is this just theoretical, at the moment?

-Mark



From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Lu Jiang [lu.jiang69_at_yahoo.com] Sent: Tuesday, September 18, 2012 18:57
To: oracle-l_at_freelists.org
Subject: How to set time difference limit between RAC nodes in 10g

Hi DBA gurus,

I know we should synchronize time on all rac nodes with NTP. Time difference between RAC nodes could have impact on data integrity. It is good if we can be notified if one of the RAC node's time out of synch.

Could any one shed some lights on how to set the time difference limit on 10g rac nodes so that oracle would send error to alert log and evict the node? Did some research on this, some folks say the default value is one minute and some folks say the default value is 30 seconds. Could not find anything about this setting from Oracle documentation.

Thanks,
Lu
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 18 2012 - 18:12:20 CDT

Original text of this message