Re: Oracle and DST changes

If you concentrate on the following 4 alone, a clearer picture should emerge. I am assuming you donot have any App.Srvr , OID stuff etc.

Note  : 359145.1 Impact of 2007 USA daylight saving changes on the Oracle database
Note  : 340512.1 Timestamps & time zones - Frequently Asked Questions
Note  : 397281.1 USA 2007 Daylight Saving Time (DST) Compliance for Database and Fusion Middleware
Note  : 396426.1 Effects on client and middle-tier of applying time zone patches on the Oracle Database

If your application is not using any TZ related code, then 9i would not need to be patched/upgraded.

If you are using Java Stored Procedures then JVM would need to be patched/upgraded irrespective of 9i/10g.

HTH GovindanK
On Mon, 22 Jan 2007 16:38:49 -0500, "Fedock, John (KAM.RHQ)" <John.Fedock_at_us.kline.com> said:

I have spent the afternoon reviewing the DST issues (database and JVM) that take affect in March.

After looking at MetaLink notes 359145.1, 396387.1, 396671.1, 397281.1, 402742.1, 396906.1, 396670.1 and 397013.1, my head is spinning. Each note refers to 3 other notes and so on and so on.

I have many databases from 9.2.x thru 10.2.x, all on Windows.

How are others handling? Can anyone summarize in less than 2 pages?

John Fedock

"K" Line America, ISD Department

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