Re: Upgrade issues 11.2.0.3 to 11.2.0.4?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 31 Mar 2015 13:07:38 +0100
Message-ID: <CABe10sZmd9xYJUNbXFx1mY60kM2UvH0oy2A-D1vX+Rrio1wUEQ_at_mail.gmail.com>

I've seen a lot of the replies that concentrate on the optimizer changes. Of those Jonathan's looks the most helpful. I'd add a few things.

• Given that you are moving O/S platform from a ten year old Windows O/S to a current Linux O/S there will be a bunch of admin changes that will likely cause you some pain.
• You don't say if a hardware upgrade is involved, but that seems likely. If so then this will quite possibly change bottlenecks for some processes from CPU to disk.
• The Optimizer changes from 11.2.0.3 to 11.2.0.4 are relatively small, if however your *old* database is using an OPTIMIZER_FEATURES_ENABLE setting then that might make the jump unexpectedly large.
• https://blogs.oracle.com/UPGRADE/ is an extremely useful resource for upgrades and migrations and covers both Optimizer and cross platform changes.
• After you have upgraded run orachk's post upgrade checks (unfortunately you won't be able to run the pre-upgrade checks on Windows). orachk -u - o post (See 1268927.2)

On Mon, Mar 30, 2015 at 9:22 PM, Schauss, Peter (ESS) <peter.schauss_at_ngc.com
> wrote:

> We are getting ready to migrate some databases from 11.2.0.3 (Windows
> 2003) to 11.2.0.4 (Linux - Redhat 6.6). Are there any major changes in the
> optimizer that we should be concerned about?
>
> Thanks,
> Peter
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 31 2015 - 14:07:38 CEST