Re: public DST patches for 10g?

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 11 Apr 2008 10:38:02 +0200
Message-ID: <47ff236c$0$14343$e4fe514c@news.xs4all.nl>


Posted this before but don't see it appearing, if you see it twice: sorry for that:

<usenetpersongerryt_at_gmail.com> schreef in bericht news:e89b45d2-3741-47d5-b563-24ae2faf7c5d_at_k1g2000prb.googlegroups.com...
> On Apr 9, 8:31 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
>> <usenetpersonger..._at_gmail.com> schreef in
>> berichtnews:20c92843-d509-4848-8c47-b3d86337eb1d_at_b9g2000prh.googlegroups.com...
>> > On the Oracle site you can download :
>> > Oracle Database 10g Release 2 (10.2.0.1.0) for Solaris Operating
>> > System
>> > (SPARC) (64-bit) for evaluation.
>> > I did this sometime ago but now I find that oem will not fire up
>> > due to a DST issue where some places on Earth have 'new' DST
>> > settings (like most of North America) and the agent thinks
>> > I'm 1 hour out of sync and refuses to start.
>> > For those of us who do not have or need a metalink account (: >)
>> > are there public patches available? I believe that 10.2.0.4 addresses
>> > this.
>
>> Did you try emctl resetTZ agent
>
> Well that's what the error log suggests trying.
> But there's nothing wrong with the time zone : >
> Other than it was shifted ahead a few weeks in 2007.
> I tried all the suggestions anyway but no go.
> I think the only cure is a patchset properly appllied.

That's right. I had to do some of these patches myself lately, a lot of docs referring to other docs, dead links in the html docs etc. It took me some hours to find the patch itself was very simple, once I FOUND it. To find out our time zone (MET-1METDST) was still not in it. But Europe/Paris seems to be the same.
One thing you could try is to run the Sun Timezone updater (tzupdater) without patching your db, you'll get the new time zones files as well. And it looks like that's all you need.
Run it in your database home jre environment.

BUT: I did not test this. At least backup your jre/1.xx/lib/zi directroy before you do so.

For those who HAVE support and read this thread: it's patch 6672979 you'll need.
It is a CORE patch.

Shakespeare Received on Fri Apr 11 2008 - 03:38:02 CDT

Original text of this message