Overview
- There are no new Grid Infrastructure fixes. The GI component is the same content as 11.2.0.3.9 (Jan 2014) GI PSU (Bug 17735354)
- You realy should read and understand README : Oracle Grid Infrastructure Patch Set Update 11.2.0.3.11 (Includes Database PSU 11.2.0.3.11) – 18706488
- Section – Known Issues
- Section 3.1, “Possible Workaround Needed for Quality of Service Management (QoSM) Customers”
- Section 3.2, “Warnings May Be Returned During the Re-link Phase of 18522512”
Change qosadmin password ( only if needed – see PSU Section 3.1 )
grid@grac31 grid]$ env | grep GRID
GRID_HOME=/u01/app/11203/grid
[grid@grac31 grid]$ env | grep PATH
PATH=/u01/app/11203/grid/bin:.:/u01/app/11203/grid/bin:
Change qosadmin password
[grid@grac31 grid]$ qosctl qosadmin -setpasswd qosadmin oracle112 neworacle112
AbstractLoginModule password: <<< enter oracle112
Please re-enter the password entered on the command line above
Enter Password: <<< enter oracle112
[grid@grac31 grid]$ qosctl qosadmin -listusers
AbstractLoginModule password: <<< enter neworacle112
oc4jadmin
JtaAdmin
qosadmin
Install new OPatch version for users : grid, oracle
[grid@grac31 OPATCH_112036]$ cd /media/sf_kits/patches/OPATCH_112036
[grid@grac31 OPATCH_112036]$ unzip p6880880_112000_LINUX.zip -d $GRID_HOME
[grid@grac31 OPATCH_112036]$ $GRID_HOME/OPatch/opatch -version
Oracle Interim Patch Installer version 11.2.0.3.6
[oracle@grac31 ~]$ cd /media/sf_kits/patches/OPATCH_112036
[oracle@grac31 OPATCH_112036]$ unzip p6880880_112000_LINUX.zip -d $ORACLE_HOME
[oracle@grac31 OPATCH_112036]$ $ORACLE_HOME/OPatch/opatch -version
Oracle Interim Patch Installer version 11.2.0.3.6
Verify the OUI inventory and create response file ( user : grid, oracle )
[grid@grac31 OPATCH_112036]$ $GRID_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME
OPatch succeeded.
[oracle@grac31 OPATCH_112036]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
..
OPatch succeeded.
[grid@grac31 OPATCH_112036]$ cd $GRID_HOME/OPatch
[grid@grac31 OPATCH_112036]$ $GRID_HOME/OPatch/ocm/bin/emocmrsp
..
The OCM configuration response file (ocm.rsp) was successfully created.
Run opatch installation as user root
[root@grac31 ~]# $GRID_HOME/OPatch/opatch auto /media/sf_kits/patches/1120311/p18706488_112030_Linux-x86-64 -ocmrf $GRID_HOME/OPatch/ocm.rsp
ing configuration parameter file: /u01/app/11203/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11203/racdb ...
Stopped RAC /u01/app/oracle/product/11203/racdb successfully
patch /media/sf_kits/patches/1120311/p18706488_112030_Linux-x86-64/17592127/custom/server/17592127 apply successful for home /u01/app/oracle/product/11203/racdb
patch /media/sf_kits/patches/1120311/p18706488_112030_Linux-x86-64/18522512 apply successful for home /u01/app/oracle/product/11203/racdb
Stopping CRS...
Stopped CRS successfully
patch /media/sf_kits/patches/1120311/p18706488_112030_Linux-x86-64/17592127 apply successful for home /u01/app/11203/grid
patch /media/sf_kits/patches/1120311/p18706488_112030_Linux-x86-64/18522512 apply successful for home /u01/app/11203/grid
Starting CRS...
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11203/racdb ...
Started RAC /u01/app/oracle/product/11203/racdb successfully
opatch auto succeeded.
Repeat the opach auto comamnd on the remaining nodes !!
Execute post patch processing
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
Verify patch install
[oracle@grac31 admin]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Interim patches (2) :
Patch 18522512 : applied on Sat Sep 20 11:40:56 CEST 2014
Unique Patch ID: 17629436
Patch description: "Database Patch Set Update : 11.2.0.3.11 (18522512)"
Created on 11 Jun 2014, 05:48:32 hrs PST8PDT
Sub-patch 18031683; "Database Patch Set Update : 11.2.0.3.10 (18031683)"
Sub-patch 17540582; "Database Patch Set Update : 11.2.0.3.9 (17540582)"
Sub-patch 16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
..
Patch 17592127 : applied on Sat Sep 20 11:32:52 CEST 2014
Unique Patch ID: 16995168
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)"
Created on 9 Jan 2014, 07:26:53 hrs PST8PDT
[grid@grac31 OPatch]$ $GRID_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME
Interim patches (2) :
Patch 18522512 : applied on Sat Sep 20 11:58:55 CEST 2014
Unique Patch ID: 17629436
Patch description: "Database Patch Set Update : 11.2.0.3.11 (18522512)"
Created on 11 Jun 2014, 05:48:32 hrs PST8PDT
Sub-patch 18031683; "Database Patch Set Update : 11.2.0.3.10 (18031683)"
Sub-patch 17540582; "Database Patch Set Update : 11.2.0.3.9 (17540582)"
Sub-patch 16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
..
Patch 17592127 : applied on Sat Sep 20 11:51:17 CEST 2014
Unique Patch ID: 16995168
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)"
Created on 9 Jan 2014, 07:26:53 hrs PST8PDT