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

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@xxxxxxxxxxx> 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

Other related posts: