We a trying to upgrade our vendor provided and somewhat supported Oracle environment from 10g R1 to 10g R2 and can't get a straight answer from them as to what we need to do to make sure we are DST compliant. We currently do not use any of the time zone data types, but will with the next release of our vendor provided Oracle application so it is imperative we get this straight.
We are preparing to upgrade from Oracle 10g R1 (10.1.0.5) to R2 (10.2.0.1 then 10.2.0.2 Patch Set 16) and need to know the process to install the R2 version of Oracle's DST patch.
We installed 10.1.0.5 DST patch sets 3 and 9 to our Oracle R1 servers a year and a half ago, but since the upgrade process to get from R1 to R2 involves uninstalling R1 we assume the DST patch sets will be lost. Is this a correct assumption? Does Oracle have a specific DST patch for each version of Oracle (10.1.x, 10.2.0.1, 10.2.0.2, 10.2.0.2 patch set 16)?
Our vendor is trying to tell us that we should reinstall 10.1.0.5 patch sets 3 & 9 after upgrading to 10.2.0.2 patch set 16 and that just doesn't make any sense.