Steps for upgrading Oracle11gR2 to a single machine

Source: Internet
Author: User
If Oracle11gR2 adopts a single file system: Step: directly upgrade DBSOFT, data dictionary, install PSU, and install one-offpatch. If the single machine uses GRID + ASM:

If Oracle 11g R2 is a single-host file system: Step: directly upgrade db soft, data dictionary, install PSU, and install one-off patch. If the single machine uses GRID + ASM:

If Oracle 11g R2 is a single-host file system:
Steps:
Directly upgrade db soft, data dictionary, install PSU, and install one-off patch.
If the single machine uses GRID + ASM:
Steps:
Install patches, upgrade GI, upgrade db soft, data dictionary, install PSU, and install one-off patches before the upgrade.

Patch installed before Upgrade:
For the base version 11.2.0.1, the installed patch is PATCH 9413827 Or PATCH 9706490 if on AIX, Solaris or HP.
For the base version 11.2.0.2, the installed patch is PATCH 12539000.

One-off patch to be installed:

Patches relevant for all platforms:
Patch: 13656236
Merge patch fixing the following two bugs:
Document: 13004894.8 Wrong results with SQL _TRACE/10046
? Document: 13370330.8 ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column
Patch: 13705338
Wrong results on iot secondary index through join

Patch: 13831007
Merge patch fixing the following bugs:
? Unpublished Bug 12797420: MUTEX X WAITS WITH TWO JVMS
? Document: 13588248.8 Library cache mutex contention for objects with very upload library cache locks
NB: This merge can be used on either11.2.0.3.0 or 11.2.0.3.1. We are hoping to have the fixes encoded in the 11.2.0.3.2 PSU.
Patches specific to ibm aix:
Patch: 12412983
AIX: "asynch descriptor resize" wait not necessary on AIX

Patch: 12596494
Generally higher cpu usage IN11.2.0.2 THAN 10.2.0.4

Patch: 13443029
Memory leak fix for online patching/HOT PATCHING
This operation CES memory usage associated with the online patching feature.
? AIX 6.1 TL7 or above (such as AIX 7.1) must be installed before either installing the patch or relinking the Oracle binary for it to be without tive. if you are on an earlier version of AIX, then you may wish to consider installingPatch: 10190759 instead, but keep in mind that doing so will disable online patching.
Please see Document: 1260095.1 for more information.

For more information about Oracle, see the Oracle topic page? Tid = 12

,
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.