Re: DST Apology

I can top that.
10.2.0.3 (10g R2 patchset 2) was re-uploaded today. patchset 5337014 No change has yet been made to the readme.html indicating what changed. Nothing.

So I visited the magic 8 ball site to ask it if I would need to uninstall and re-apply the patchset to the vast number of database servers that have already been diligently updated with the patch.

"Question: will I need to re-apply the Oracle 10g R2 patchset 2 to win32 oracle servers?"
"Absolutely!"
http://web.ics.purdue.edu/~ssanty/cgi-bin/eightball.cgi

The Magic 8 ball was of no help.

Sounds like a Service Request is in order. I'm back into full blown bastard mode.

Paul

On 2/21/07, Andre van Winssen <dreveewee_at_gmail.com> wrote:
>
> Oracle keeps re-releasing the utltzuv2.sql scipt, on Windows. Today I
> found 5601428 for 10.2.0.2 again with new release date. No indication of
> version 4 files, could not figure out so quickly what else was changed.
> A bit strange is that the script requires jvm to be installed. If not then
> it will fail to complete succesfully (ORA-29538: Java not installed)
>
> Regards,
> Andre
>
>
> 2007/2/20, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com>:
> >
> > Yes, and like everything it's easy when you know how… but it is
> > complicated when every oracle version has it's own process. Even though I
> > am safe in that I only have 10g dictionary data, I went through all the
> > motions… and indeed am now putting in the version 4 files.
> >
> >
> >
> > Two notes:
> >
> >
> >
> > If you are pressed for time do version 3 to be on time, and to be out
> > ahead of things like the scheduler which might begin using the affected
> > times. However, putting version 4 out there now is going to save you from
> > essentially double dipping for about the same pain. I'm doing them one at
> > a time, so there is no preasure now, and I can put the 4's out there…. I
> > found that most of the focus is on 3… e.g. oracle9 query for timezone
> > version 4 installed. Other queries exist, but this is an example of
> > something available for 3 that 'might' not be available for 4. I have an
> > SR requesting it, so we shall see. (strictly speaking it is not necessary).
> >
> >
> >
> >
> > IMPORTANT: I strongly suggest you heed Brandons advice, because going
> > back and fixing your data after you are finished seems simple… but be
> > forwarned of things like how much time it takes. The script itself warns
> > you it is not quick. (so multiply that by your data). I ran it and it
> > took forever, but I had no data, and had to prime the pump to get the script
> > started. I know one other person who says it went quite quick for her, so
> > buyer beware.
> >
> >
> >
> > Joel Patterson
> > Database Administrator
> > joel.patterson_at_crowley.com
> > x72546
> > 904 727-2546
> > ------------------------------
> >
> > *From:* oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] * On Behalf Of *Allen, Brandon
> > *Sent:* Tuesday, February 20, 2007 3:26 PM
> > *To:* jkstill_at_gmail.com; Oracle-L Freelists
> > *Subject:* RE: DST Apology
> >
> >
> >
> > It's okay, we still love you Jared ;-)
> >
> >
> >
> > But while we're on the subject (again), let me emphasize for the 42nd
> > time that the "updated" utltzuv2.sql script as downloaded from
> > Metalink is in fact *not* complete/correct. I have been trying to get this
> > point across for weeks now (on this list, under the subject "ALERT -
> > Potentially Serious Problem with DST Patches for New Timezones"), but
> > I'm not sure how many people are listening. Metalink released two
> > notes addressing this problem on Feb 12th and I strongly recommend everyone
> > read them: 414590.1 & 414826.1.
> >
> >
> >
> > Regards,
> >
> > Brandon
> >
> >
> > ------------------------------
> >
> > *From:* oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] * On Behalf Of *Jared Still
> >
> >
> > You do however need to make certain that you use the correct
> > utltzuv2.sql script for your database - it will need to be downloaded
> > from MetaLink.
> >
> > Privileged/Confidential Information may be contained in this message or
> > attachments hereto. Please advise immediately if you or your employer do not
> > consent to Internet email for messages of this kind. Opinions, conclusions
> > and other information in this message that do not relate to the official
> > business of this company shall be understood as neither given nor endorsed
> > by it.
> >
>
>

-- 
-- ALTER SESSION SET EVENTS 'immediate trace name hanganalyze level 4';

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