Re: Day light saving time change-ReOpening on Java bug for 9.2 version

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 28 Dec 2006 08:30:05 -0800 (PST)
Message-ID: <815143.47490.qm@web60815.mail.yahoo.com>

I am testing ORACLE 9.2 version Java bug which relate to 2007 day light saving issue. I have questions and need help.

Based on ORACLE document, If java packages installed on database then patch 5047902 (for 9.2) need apply. I look README file on patch 5047902, it mention:

Bugs Fixed by this patch:
# -------------------------
# 5047902 - JVM TIMEZONE COMMONWEALTH GAME FORCING
MOVE OF TIMEZONE CHAGE

#

# Pre Installation Instructions:
# ------------------------------
# - shutdown database
#
# - remove ncomp shared library for java.util package
# On Unix systems, the .so is:
$SRCHOME/javavm/admin/libjox9java_util.so

Does it mean I need delete file libjox9java_util.so?

The reason I ask is patch 5047902 does NOT include new file for libjox9java_util.so. It ONLY include new file for classes.bin.

Thanks for help.

• GovindanK <gkatteri_at_fastmail.fm> wrote:

> >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
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 


__________________________________________________

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Thu Dec 28 2006 - 10:30:05 CST