Upgrade Question on 10g

Hi,

We are running Oracle 10.2.0.1.0. We want to upgrade to the latest patchset, 10.2.0.4.

I guess first, is this really necessary. Also, we I noticed this comment in the documentation:

1. When patching from a lower 10.2 release or upgrading from 10.1.0.X directly to 10.2.0.4, check the current version of the Oracle time zone definitions with the following command:
2. SELECT version FROM v$timezone_file; o If this query reports version 4, no action is required; in this case, continue with steps described in section 7.6. o If this reports a version lower or higher then 4, see OracleMetalink document 553812.1 Actions for the DSTv4 update in the Release 10.2.0.4 patchset.

Item 1 says a "lower 10.2 release". I believe this is not us because we are on 10.2.0.1.0. However, the query to select from v$timezone returns a 2 for the version........which would point us to document 553812.1.

So, am I right that this set of text is not relevant to our setup?

Thank you,

John. Received on Wed Jul 23 2008 - 10:04:55 CDT