Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle and DST changes

RE: Oracle and DST changes

From: Mercadante, Thomas F \(LABOR\) <>
Date: Wed, 31 Jan 2007 12:25:59 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08ACA@EXCNYSM0A1AJ.nysemail.nyenet>


That sounds correct to me. I will be doing similar steps for my 9.2 databases that do not have patches available.  

Look also at whether you should patch JVM. I am patching JVM even though I have zero risk of loss of data. Taking the conservative approach to things.


This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

[] On Behalf Of Barbara Baker Sent: Wednesday, January 31, 2007 11:25 AM To:
Subject: Re: Oracle and DST changes  

Oracle Solaris 9

Mark and Tom:

I have several databases with no possibility of upgrading.

I wonder if I might prevail on you to review these steps and let me know if this is what you did to upgrade your timezones for a database  

  1. Downloaded patch 5126270, manually placed the timezdif.csv in $ORACLE_HOME/oracore/zoneinfo and ran utltzuv2.sql
  2. After step 1, I do not appear to have affected data, nor do I have Java issues
  3. I downloaded patch 4689959 for
  4. I plan to manually move the timezlrg.dat and timezone.dat files to $ORACLEl_HOME/oracore/zoneinfo

Does this sound correct?

I've downloaded about a bazillion metalink articles, and I'm still struggling.

Thanks for any help!


On 1/30/07, Mark Strickland <> wrote:

I just realized that on one of my dev/test servers, Oracle was never upgraded from to (egg on face). There is no DST patch for but I compared the old versions of the timezone files between the two patchsets and they are identical so I copied the new timezone files from to and called it good. The test query does return the correct time. I don't like doing spur-of-the-moment upgrades and this particular server and database are expected to be sunsetted sometime this century, so I decided not to quickly upgrade it. I may decide to do that later.

So, if you have and can't upgrade to a higher 10gR1 patchset, there appears to be a workaround. If I encounter side-effects, I'll be sure to update the list.

Mark Strickland

Received on Wed Jan 31 2007 - 11:25:59 CST

Original text of this message