Re: Upgrade issues 11.2.0.3 to 11.2.0.4?
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Tue, 31 Mar 2015 13:07:38 +0100
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@xxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
