On redhat rhel3, we have to update the tzdata rpm, but I'm not sure if I need to bring down the database first. Randy > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of GovindanK > Sent: Wednesday, December 27, 2006 3:10 PM > To: 'ORACLE-L'; Don Doo > Subject: Day light saving time change-ReOpening > > >Hi, > > The US is changing the day light saving time. We are using the > TIMESTAMP data types at different places. Is there anything that we need > to worry regarding the day >light saving time change > >Thanks, > >Don. > > I saw this post a while ago. Now we have starting working on this. I > thought i will share my findings. > * Note 359145.1 - Impact of 2007 USA daylight saving changes on the > Oracle database > * Note 397281.1 - USA 2007 Daylight Saving Time (DST) Compliance for > Database and Fusion Middleware > * Note 391354.1 What Is The Impact Of US 2007 Daylight Savings Time > (DST) Changes For OID/AS? > * Note 77370.1 What are the effects of changing the system clock on an > Oracle Server instance? > * Note 340512.1 Timestamps & time zones - Frequently Asked Questions > * Bug 4689959 - DST RULE CHANGE IN US, NEED PATCHED TIMEZONE FILES > * Note 402742.1 - USA 2007 DST Changes: Frequently Asked Questions for > Oracle RDBMS > * Note 396225.1 - OTM - Daylight Savings Time Changes for 2007 > > Besides you have the following links too > > http://sunsolve.sun.com/search/document.do?assetkey=1-26-102178-1 > http://www.microsoft.com/windows/timezone/dst2007.mspx > > Note 403311.1 - United States Time Zone Changes 2007: E-Business Suite > (EBS) > Note 357056.1 - Impact of changes to daylight saving time (DST) rules on > the Oracle database > Note 396387.1 - Workarounds when Database time zone patches are not > available for your patchset > Note 396426.1 - Effects on client and middle-tier of applying time zone > patches on the Oracle Database > Note 396670.1 - Usage of utltzuv2.sql before updating time zone files in > Oracle 9 > Note 396671.1 - Usage of utltzuv2.sql before updating time zone files in > Oracle 10 > Note 397770.1 - How to check if Oracle JVM is installed in the Database > Note 399832.1 - Workarounds when utltzuv2.sql patches are not available > for your patchset > Note 402316.1 - Database Time Zone Patching Strategy in the Enterprise > Note : 396906.1 Patches to Update the Time Zone Transition Rules > Note : 77370.1 What are the effects of changing the system clock on an > Oracle Server instance? > > HTH > GovindanK > Certified DBA > Learning Stops at ... Infinity > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l