timezone update issues in 11.2.0.1->11.2.0.2 upgrade
stellrMar 9 2011 — edited Nov 28 2012I'm getting lost in the note maze on timezones. I'm upgrading, "out of place," from 11.2.0.1 to 11.2.0.2. When I run utlu112i.sql it tells me to:
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 11.2.0.1.0 database timezone version
.... to the latest version which comes with the new release.
I find, via a search of metalink, "Updating the RDBMS DST version in 11gR2 (11.2.0.1 and up) using DBMS_DST [ID 977512.1]" which says:
Locate the latest RDBMS DST patch available in NOTE:412160.1 Updated DST transitions and new Time Zones in Oracle Time Zone File patches
Apply the RDBMS DST patch to the $ORACLE_HOME using Opatch, there is no need to shutdown the database to apply the RDBMS DST patch.
This is where I get lost. 412160.1 provides DSTv15diff, but this does not look like a patch to me. Also, there is no digest provided, so I can't be sure the file is valid on download (sigh):
$ unzip -l DSTv15diff.zip
Archive: DSTv15diff.zip
Length Date Time Name
-------- ---- ---- ----
0 12-17-10 14:41 DSTv15diff/
4604 12-17-10 14:46 DSTv15diff/DST15new.txt
1882 12-17-10 14:40 DSTv15diff/readme.txt
32850 12-17-10 14:42 DSTv15diff/tzdst15.txt
-------- -------
39336 4 files
Updated DST transitions and new Time Zones in Oracle Time Zone File patches [ID 412160.1] does not seem to say how to apply this patch.
What rabbit trail did I miss?