Fast forward to today. I decide to finally set up Oracle's EM dbconsole web UI for administration. I had done this in the past on some other instances with absolutely no problems. So imagine my surprise when it fails to start the dbconsole after installation. When I tried to start it manually, I get this message:
The agentTZRegion value (US/Central) in /u00/app/oracle/product/10.2.0/db_1/foo.world_dev64/sysman/config/emd.properties does not match the current environment TZ setting(US/Central).This error makes no sense at all. US/Central doesn't match US/Central? After some googling I found a note that this occurs when the Oracle software isn't patched, but the operating system is, which is the case here. So Oracle was thinking US/Central (CST), but the operating system was saying US/Central (CDT). CURSES!
So I ended up downloading the latest Oracle one-off patch for 10.2.0.2 (with the version 4 timezone fixes, HI CANADA!) and, after a pretty painless patching process, all is well. Of course I did ignore the "best practice" of having separate ORACLE_HOMEs for your ASM and RDBMS installations, so I did have to shutdown both, but since this RDBMS instance is the only one using this ASM instance, it really didn't matter. It also helps that this is my test 64-bit migration server and no one was using it today but me. :p
I thought I could thumb my nose at Congress and their silly DST changes, but my love of the GUI brought me down. ;_;