USA 2007 DST Changes: Frequently Asked Questions and Problems for Oracle JVM Patches (Doc ID 414309.1)

Last updated on SEPTEMBER 24, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 to 10.2.0.1 [Release 8.1.5 to 10.2]
Oracle Database - Standard Edition - Version 8.1.5.0 to 10.2.0.1 [Release 8.1.5 to 10.2]
Information in this document applies to any platform.
Oracle Server - Standard Edition - Version: 8.1.5.0 to 10.2.0.1
Information in this document applies to any platform.

Purpose

This note is about the DSTv3 and DSTv4 / USA 2007 Daylight Saving Time (DST) update, newer DST updates exist and this information may not be relevant anymore for those. For newer DST patches these please see <Note 412160.1> Updated DST transitions and new Time Zones in Oracle Time Zone File patches

This FAQ provides answers to common questions regarding the Oracle JVM (OJVM) patches for the Daylight Saving Time (DST) changes in 2007 in the USA. This note will also provide guidance on common issues which can occur when these patches are applied.

For information about the patches which need to be applied please see the Oracle JVM section and Table 3 in <Note 359145.1> Impact of 2007 USA daylight saving changes on the Oracle database

For more generic Frequently Asked Questions about how the DST changes in 2007 affect the Oracle database please see <Note 402742.1> USA 2007 DST Changes: Frequently Asked Questions for Oracle Database Patches. This FAQ contains a number of questions in the "Generic" section which also relate to JVM issues, so you are advised to check these as well when your questions are not answered below.

@

Questions and Answers

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Questions and Answers

Oracle JVM / DST related questions answered in other FAQsThe following questions related to the JVM are covered in <Note 402742.1>:
102. Is Oracle7 affected?
103. Is Oracle8 affected?
111. Are Time Zone file patches or the OJVM patches included in a CPU
111b. Are there any conflicts between the CPUs and DST patches?
112. Are the time zone file patch and the OJVM patch linked?

0. Which patches do I need, and how do I install them?If you found this article through a search and not as a link from other articles, it is good to know which patches this article talks about. There is a 'choice' of 2 (sets of) patches which provide a complete update of the Oracle JVM time zone knowledge.

The "earlier" patches which update the Oracle JVM time zone rules include the updates for the Commonwealth Games in Australia in March/April 2006 and the changes to DST rules in the USA in 2007. This update was created in March 2006 when those changes where the latest known updates. Details on those patches are available in the OJVM section of <Note 359145.1>.

The latest update to the Oracle JVM time zone rules is the "OJVM Time Zone Update February-2007".
This patch contains updates for Australia from December 2006 and Canada from 2007, and a number of other updates. These OJVM time zone patches are cumulative, so the Feb-2007 patch also includes the updates discussed above, and supersedes the patches from <note 359145.1>. It is recommended you apply the highest OJVM Time Zone Update version that is available on your database version.

For more information about the availability of this latest OJVM time zone update please see:
<Note 414742.1> Applying "OJVM Time Zone Update February-2007" (5865568) on an Oracle Database

1. The post-install instructions for the OJVM patch fail with ORA-3113 and/or ORA-7445The post install instructions of the some of the OJVM patches tell you to run a "CREATE OR REPLACE JAVA SYSTEM" command. This can fail with ORA-3113, and at the same time an ORA-7445 will be raised in the alert.log of the database.
When this happens the most likely reason is that you did not correctly follow the pre-install instructions of the patch for Oracle 8 or 9. These instructions tell you to remove (or backup and remove) the file $ORACLE_HOME/javavm/admin/libjox[89]java_util.so (or .sl, or .dll), and (depending on the version and patch) a number of other files. See question 3 below for details on why this is.
These files are not replaced during the installation of the patch, it should remain off the system. If the libjox[89]java_utl file is available after the patch has been applied it will cause these ORA-7445 / ORA-3113 errors.

This file should not be renamed and left in the same location, since it can then still be found. It should be backed up into a different directory and removed completely from the original $ORACLE_HOME/javavm/admin directory.

This issue is further discussed in <Note 409030.1>.

2. The OJVM patch readme tells me to remove .so files, but they don't exist on my platformOn certain platforms .sl files are used instead of .so files. The OJVM patch readme tells you to remove the file $ORACLE_HOME/javavm/admin/libjox[89]java_util.so. This is a small error in the readme, it should mention that this is either a .so or a .sl file. So on platforms where .sl files are used read these instructions as if they reference $ORACLE_HOME/javavm/admin/libjox[89]java_util.sl

3. Why do the Oracle8, 9.0.1 and 9.2 OJVM patch instructions instruct to delete a library?

4. Post-install step for JVM patch can damage the database !

5. Does the database need to be down before the OJVM patch is applied?

6. How can I test if the OJVM patch has been applied correctly?

6b. How can I list the valid time zones in the Oracle JVM?

6c. Why are there different time zones in the OJVM and in the Oracle time zone files?

6d. How can I test the latest "OJVM February 2007 Time Zone Update" ?

7. Are any client patches needed for the OJVM patch?

8. How can I find out if the OJVM is being used?

9. Do the post-install instructions mean I have to "reload" the whole JVM and all Java classes loaded into the database?

10. Do I need to run any specific post-install actions if I've applied the JVM patch as part of a patchset.

11. Why is there a difference in the OJVM patch install instructions for 8/9/10.1 and 10.2?

12. Why did the OJVM patch install instructions for 10.2.0.1 change on January 24th.

13. How can the OJVM patch be applied to a Data Guard environment?

14. Since applying the OJVM DST patch, Java timestamps from 2006 and earlier have changed rules in the Oracle JVM

15. How about Canadian time zones?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.