RE: Day light saving time change-ReOpening

  • From: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>
  • To: <gkatteri@xxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 Dec 2006 16:06:37 -0500

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


Other related posts: