Upgrade OracleRAC11.2.0.4 to 11.2.0.4.1.

Source: Internet
Author: User
Upgrade OracleRac11.2.0.4 to 11.2.0.4.1.

Upgrade Oracle Rac 11.2.0.4 to 11.2.0.4.1

1. Current database environment:
Dual-node Oracle linux 5.4 RAC
Grid software 11.2.0.4
Oracle software 11.2.0.4
OPatch Version 11.2.0.3.4


2. Download OPatch

Download 11.2.0.4.1 Patch: 17478514
P17478514_112040_Linux-x86-64.zip

According to the psu readme:
OPatch Utility
You must use the OPatch utility version 11.2.0.3.5 or later to apply this patch. oracle recommends that you use the latest released OPatch version for 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release.
Since OPatch Version 11.2.0.3.4, We need to update OPatch version and download OPatch: patch 6880880: OPatch patch of version 11.2.0.3.6 for Oracle software releases 11.2.0.x.
P6880880_112000_Linux-x86-64.zip

3. Update OPatch version/OCM configuration
Extract p6880880_112000_linux-x86-64.zip to each node DB home and GI home

Run grid and oracle on node 1 and 2 respectively.
Mv $ ORACLE_HOME/OPatch/$ ORACLE_HOME/OPatch. bak

Run grid and oracle on node 1 and 2 respectively.
Unzip/software/p6880880_112000_Linux-x86-64.zip-d $ ORACLE_HOME/

Run grid and oracle on node 1 and 2 respectively.
-- Execute the following command to create the file ocm. rsp in the current directory
Cd $ ORACLE_HOME/OPatch/
$ ORACLE_HOME/OPatch/ocm/bin/emocmrsp

Verify OPatch version updates

$ ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.6

OPatch succeeded.

4. Patch Conflict Detection and Resolution
Decompress the file:

Unzip p17478514_112040_Linux-x86-64.zip
Cd/software/17478514/

Conflict Detection:
Run grid and oracle on node 1 and 2 respectively.

$ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-ph ./

5. Instructions for Patching a Grid Infrastructure (GI) Home

Root User execution: (pay attention to permission issues. grid users Install patches. This patch is decompressed by grid, similar to oracle)
Install the grid patch
Export ORACLE_HOME =/arch/grid2
(Opatch auto -Oh -Ocmrf )
$ ORACLE_HOME/OPatch/opatch auto/software/opatch/-oh $ ORACLE_HOME/-ocmrf $ ORACLE_HOME/OPatch/ocm. rsp

[Root @ devnode1 opatch] # $ ORACLE_HOME/OPatch/opatch auto/software/opatch/-oh $ ORACLE_HOME/-ocmrf $ ORACLE_HOME/OPatch/ocm. rsp
Executing/arch/grid2/perl/bin/perl/arch/grid2/OPatch/crs/patch11203.pl-patchdir/software-patchn opatch-oh/arch/grid2/-ocmrf/arch/ grid2/OPatch/ocm. rsp-paramfile/arch/grid2/crs/install/crsconfig_params

This is the main log file:/arch/grid2/export toollogs/opatchauto2014-04-14_17-57-35.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/Arch/grid2/export toollogs/opatchauto2014-04-14_17-57-35.report.log

2014-04-14 17: 57: 35: Starting Clusterware Patch Setup
Using configuration parameter file:/arch/grid2/crs/install/crsconfig_params
Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no): yes
Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no): yes

Unable to determine if/arch/grid2 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are saved med to patch this shared home (yes/no): yes

Stopping CRS...
Stopped CRS successfully

Patch/software/opatch/17478514 apply successful for home/arch/grid2

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

Opatch auto succeeded.

Install oracle Patches
Export ORACLE_HOME =/arch/oracle/product/11.2.0/db_1
$ ORACLE_HOME/OPatch/opatch auto/software/opatch/-oh $ ORACLE_HOME/-ocmrf $ ORACLE_HOME/OPatch/ocm. rsp

[Root @ devnode1 software] # export ORACLE_HOME =/arch/oracle/product/11.2.0/db_1
[Root @ devnode1 software] # $ ORACLE_HOME/OPatch/opatch auto/software/opatch/-oh $ ORACLE_HOME/-ocmrf $ ORACLE_HOME/OPatch/ocm. rsp
Executing/arch/grid2/perl/bin/perl/arch/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl-patchdir/software-patchn opatch-oh/arch/oracle /product/11.2.0/db_1/-ocmrf/arch/oracle/product/11.2.0/db_1/OPatch/ocm. rsp-paramfile/arch/grid2/crs/install/crsconfig_params

This is the main log file:/arch/oracle/product/11.2.0/db_1/export toollogs/opatchauto2014-04-14_15-51-51.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/Arch/oracle/product/11.2.0/db_1/export toollogs/opatchauto2014-04-14_15-51-51.report.log

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.