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 <UNZIPPED_PATCH_LOCATION>-oh <GI_HOME>-ocmrf <ocm response file>)
$ 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
 

2014-04-14 15: 51: 51: 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
 

Stopping RAC/arch/oracle/product/11.2.0/db_1...
Stopped RAC/arch/oracle/product/11.2.0/db_1 successfully
 

Patch/software/opatch/17478514 apply successful for home/arch/oracle/product/11.2.0/db_1
 

Starting RAC/arch/oracle/product/11.2.0/db_1...
Started RAC/arch/oracle/product/11.2.0/db_1 successfully
 

Opatch auto succeeded.
 

6. Loading Modified SQL Files into the Database
Cd $ ORACLE_HOME/rdbms/admin
Sqlplus/as sysdba
SQL> @ catbundle. SQL psu apply
 

7. Verification
$ ORACLE_HOME/OPatch/opatch lspatches
Or
$ ORACLE_HOME/OPatch/opatch lsinventory-all