Make sure that you have applied the Oracle DST patches for this weekend

Oracle databases across the nation may crash on Sunday if their DBA fails to apply these important patches for Daylight Savings Time (DST).

These patches are required for any Oracle shops that meets he criteria below, including shops running Oracle Applications, Oracle Java (JRE, JDK) and some grid users.  Oracle ACE, Chris Foot notes:

http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-03-04.1596857853

The biggest issue we had was with Oracle's updates to the DST patching documentation. Since we were required to do a LOT of patching, it was important for us to get a head start. In the middle of January, we download all of the DST documentation and studied the information. We then created our plan of attack and began implementing it.

We also checked the DST area on MOSC every few days for updates. Here's where the problem arose. Some of the database patching documentation (10G specifically) can be described as "somewhat fluid" in nature. Our DST coordinator, Brian "Captain Patch" Hays found that some of the changes forced him to assemble his DST team to review their impact.

Although the updated documentation did not force us to redo any patches, we did have to revisit several of the environments that we already patched to ensure that we didn't have to reapply them. In one case, the initial documentation did not provide a complete listing of DST datatypes that could be used in table definitions.

We reviewed each of the environments looking for tables containing the additional DST datatypes and were pleased to find that none were in use. I can state that when we did apply the database patches (both for the database and the Oracle Java Engine), they worked flawlessly.

Recommendations

We intend to check for updates to all Oracle DST documentation until March 11. I would highly suggest that you also do so.

According to Oracle MOSC, there are some important patches that need to be applied to accommodate the USA changes in Daylight Savings Time (DST) before Match 13, 2007.  Here are the MOSC notes:

409210.1 - USA 2007 DST Changes: Frequently Asked Questions for Oracle Fusion Middleware

397281.1 - USA 2007 Daylight Saving Time (DST) Compliance for Oracle Server Technologies Products

403659.1 - 2007 Daylight Saving Time Changes For Oracle Applications

412789.1 - USA 2007 Daylight Saving Time Changes - Webcasts

416854.1 - Using the Oracle RDA 4.7 New Feature: Daylight Saving Time Tool Box

*****************************************

Need a Health Check?

Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

BC has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 919-783-4133 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call me at 919-783-4133 for details, and check-out our on-site Oracle training catalog:

http://www.dba-oracle.com/bc-catalog.pdf