Re: How to set time difference limit between RAC nodes in 10g
From: Lu Jiang <lu.jiang69_at_yahoo.com>
Date: Mon, 24 Sep 2012 21:15:36 -0700 (PDT)
Message-ID: <1348546536.43208.YahooMailNeo_at_web125206.mail.ne1.yahoo.com>
Hi,
I just want to share with you. I am in a RAC training class this week, the instructor is very knowledgeable. I asked the same question and He told me that Oracle should evict the node if time difference is big than 5 minutes, and the 5 minutes limit is set internally, it can not be adjusted.
We have NTP configured, but one of the node does not synchronize its time with NTP server, looks it only sync its time while rebooting. All other RAC nodes which seems have the same configuration but synchronize their time perfectly. This is 10g db on Windows environment. Any thoughts on this. Also I have submitted a SR, hope i can get some update soon.
Thanks,
Lu
From: Ls Cheng <exriscer_at_gmail.com>
To: lu.jiang69_at_yahoo.com
Cc: "Mark.Bobak_at_proquest.com" <Mark.Bobak_at_proquest.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wednesday, September 19, 2012 5:27 AM Subject: Re: How to set time difference limit between RAC nodes in 10g
Date: Mon, 24 Sep 2012 21:15:36 -0700 (PDT)
Message-ID: <1348546536.43208.YahooMailNeo_at_web125206.mail.ne1.yahoo.com>
Hi,
I just want to share with you. I am in a RAC training class this week, the instructor is very knowledgeable. I asked the same question and He told me that Oracle should evict the node if time difference is big than 5 minutes, and the 5 minutes limit is set internally, it can not be adjusted.
We have NTP configured, but one of the node does not synchronize its time with NTP server, looks it only sync its time while rebooting. All other RAC nodes which seems have the same configuration but synchronize their time perfectly. This is 10g db on Windows environment. Any thoughts on this. Also I have submitted a SR, hope i can get some update soon.
Thanks,
Lu
From: Ls Cheng <exriscer_at_gmail.com>
To: lu.jiang69_at_yahoo.com
Cc: "Mark.Bobak_at_proquest.com" <Mark.Bobak_at_proquest.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wednesday, September 19, 2012 5:27 AM Subject: Re: How to set time difference limit between RAC nodes in 10g
Hi
If you are using NTP why you have to worry about time difference?
I dont think Oracle will evict a node when there is time difference, I have seen in the past 20, 30 minutes time difference between nodes and they were up and running, of course timestamp used in application were screwed up though
Regards
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 24 2012 - 23:15:36 CDT