Install PSU 11.2.0.3.11

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

Leave a Reply

Your email address will not be published. Required fields are marked *