Re: Upgrade Question on 10g

From: joel garry <>
Date: Wed, 23 Jul 2008 14:10:57 -0700 (PDT)
Message-ID: <>

On Jul 23, 8:04 am, Mtek <> wrote:
> Hi,
> We are running Oracle  We want to upgrade to the latest
> patchset,
> 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, 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
> patchset.
> Item 1 says a "lower 10.2 release".  I believe this is not us because
> we are on  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.

I admit, I thought this did not apply to my situation, but what I missed was the java sdk is used by the dbconsole to time jobs. So the patch fixes everything - except the sdk. Then the jobs and email alert times are off. Be sure about which sdk version you path.

I also had issues with the dbconsole not shutting down easily, not patching, apparently patching with a reapply of the patch, but actually getting worse, then much worse as support follows metalink notes. That may or may not be platform specific (I'm on hp-ux and don't know about others, but I think I've seen similar problems posted by others). So be sure you really have all processes shut down when you think you do during the patch. If it wasn't for that, I'd think this was the easiest patch ever.


-- is bogus.
Rice-cracker quarter:
Received on Wed Jul 23 2008 - 16:10:57 CDT

Original text of this message