Install PSU 11.2.0.4.3

Overview

  •  You must use the OPatch utility version 11.2.0.3.6 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.
  • Download 11.2.0.4.3 GRID patch – Verify size of GRID 11.2.0.4.3 ( Note don’t install the 11.2.0.4.3 RDBMS patch – it will not patch your GRID_HOME !! )

[grid@grac41 PATCHES]$ ls -l /media/sf_Kits/11.2.0.4.3/p18706472_112040_Linux-x86-64.zip
-rwxrwx—. 1 root vboxsf 540426116 Jul 21 09:38 /media/sf_Kits/11.2.0.4.3/p18706472_112040_Linux-x86-64.zip

Unzip and prepare patch install

[grid@grac41 PATCHES]$  unzip /media/sf_Kits/11.2.0.4.3/p18706472_112040_Linux-x86-64.zip -d /PATCHES/Patch112043
[grid@grac41 PATCHES]$ ls -l /PATCHES/Patch112043
total 44
drwxr-xr-x. 5 grid oinstall  4096 Jul  3 11:17 18706472
-rw-rw-r--. 1 grid oinstall 37636 Jul 15 13:59 PatchSearch.xml  
--> Perpare NFS mount of /PATCHES to all cluster nodes

Install newest Opatch version for user grid and oracle and create response file

Install Opatch for RDBMS instance
$ unzip /tmp/p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11203/racdb
$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.6

Install Opatch for GRID instance
$ id
uid=501(grid) gid=54321(oinstall) groups=54321(oinstall),500(vboxsf),504(asmadmin),506(asmdba),507(asmoper),54322(dba)
$ unzip /tmp/p6880880_112000_Linux-x86-64.zip -d /u01/app/11203/grid
$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.6

Create response file and copy to the remaining RAC nodes 
[grid@grac41 OPatch]$ $GRID_HOME/OPatch/ocm/bin/emocmrsp 
..
[grid@grac41 OPatch]$ scp ocm.rsp grac42:/u01/app/11204/grid/OPatch
ocm.rsp                                                                 100%  621     0.6KB/s   00:00    
[grid@grac41 OPatch]$ scp ocm.rsp grac43:/u01/app/11204/grid/OPatch
ocm.rsp                                                                 100%  621     0.6KB/s   00:00

Run opatch auto as user root

[root@grac41 ~]#   $GRID_HOME/OPatch/opatch auto /PATCHES/Patch112043/18706472 -ocmrf  $GRID_HOME/OPatch/ocm.rsp
Executing /u01/app/11204/grid/perl/bin/perl /u01/app/11204/grid/OPatch/crs/patch11203.pl -patchdir /PATCHES/Patch112043 -patchn 18706472
    -ocmrf /u01/app/11204/grid/OPatch/ocm.rsp -paramfile /u01/app/11204/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11204/grid/cfgtoollogs/opatchauto2014-07-21_11-38-08.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11204/grid/cfgtoollogs/opatchauto2014-07-21_11-38-08.report.log

2014-07-21 11:38:08: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11204/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11204/racdb ...
Stopped RAC /u01/app/oracle/product/11204/racdb successfully

patch /PATCHES/Patch112043/18706472/18522509  apply successful for home  /u01/app/oracle/product/11204/racdb 
patch /PATCHES/Patch112043/18706472/18522515/custom/server/18522515  apply successful for home  /u01/app/oracle/product/11204/racdb 

Stopping CRS...
Stopped CRS successfully

patch /PATCHES/Patch112043/18706472/18522509  apply successful for home  /u01/app/11204/grid 
patch /PATCHES/Patch112043/18706472/18522515  apply successful for home  /u01/app/11204/grid 
patch /PATCHES/Patch112043/18706472/18522514  apply successful for home  /u01/app/11204/grid 

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11204/racdb ...
Started RAC /u01/app/oracle/product/11204/racdb successfully

opatch auto succeeded.

Rerun above opatch auto command on the remaining nodes !

Load catbundle.sql ( only one per RAC database )

The following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node.
For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. 
Connect as SYSDBA and run the catbundle.sql script as follows:
    cd $ORACLE_HOME/rdbms/admin
    sqlplus /nolog
    SQL> CONNECT / AS SYSDBA
    SQL> STARTUP
    SQL> @catbundle.sql psu apply
    SQL> QUIT
    The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series PSU.
    For information about the catbundle.sql script, see My Oracle Support 
       Document 605795.1 Introduction to Oracle Database catbundle.sql.
    Check the following log files in $ORACLE_BASE/cfgtoollogs/catbundle for any errors:
    catbundle_PSU__APPLY_.log
    catbundle_PSU__GENERATE_.log
    where TIMESTAMP is of the form YYYYMMMDD_HH_MM_SS. If there are errors, see Section 3, "Known Issues". a

Verify patch installation

[grid@grac41 OPatch]$ crsctl query crs softwareversion -all
 crsctl query crs releaseversion
Oracle Clusterware version on node [grac41] is [11.2.0.4.0]
Oracle Clusterware version on node [grac42] is [11.2.0.4.0]
Oracle Clusterware version on node [grac43] is [11.2.0.4.0]
[grid@grac41 OPatch]$  crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
[grid@grac41 OPatch]$  crsctl query crs  activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]

Checking Patch installation status 
GRID_HOME:                                                         
grid@grac41 ~]$   $GRID_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.6
Oracle Home       : /u01/app/11204/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11204/grid/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/11204/grid/cfgtoollogs/opatch/opatch2014-07-21_11-58-01AM_1.log
Lsinventory Output file location : /u01/app/11204/grid/cfgtoollogs/opatch/lsinv/lsinventory2014-07-21_11-58-01AM.txt
--------------------------------------------------------------------------------
Oracle Grid Infrastructure 11g                                       11.2.0.4.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (3) :
Patch  18522514     : applied on Mon Jul 21 11:52:27 CEST 2014
Unique Patch ID:  17612330
Patch description:  "ACFS PATCH SET UPDATE : 11.2.0.4.3 (18522514)"
   Created on 6 May 2014, 01:05:19 hrs PST8PDT

Patch  18522515     : applied on Mon Jul 21 11:47:55 CEST 2014
Unique Patch ID:  17612330
Patch description:  "OCW Patch Set Update : 11.2.0.4.3 (18522515)"
   Created on 16 Jun 2014, 08:05:14 hrs PST8PDT

Patch  18522509     : applied on Mon Jul 21 11:44:50 CEST 2014
Unique Patch ID:  17604597
Patch description:  "Database Patch Set Update : 11.2.0.4.3 (18522509)"
   Created on 30 Jun 2014, 08:14:42 hrs PST8PDT
Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"

ORACLE_HOME
[oracle@grac41 ~]$   $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.6
Oracle Home       : /u01/app/oracle/product/11204/racdb
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11204/racdb/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11204/racdb/cfgtoollogs/opatch/opatch2014-07-21_12-02-30PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11204/racdb/cfgtoollogs/opatch/lsinv/lsinventory2014-07-21_12-02-30PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (3): 
Oracle Client 11g                                                    11.2.0.4.0
Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g Examples                                         11.2.0.4.0
There are 3 product(s) installed in this Oracle Home.
Interim patches (2) :
Patch  18522515     : applied on Mon Jul 21 10:27:10 CEST 2014
Unique Patch ID:  17612330
Patch description:  "OCW Patch Set Update : 11.2.0.4.3 (18522515)"
   Created on 16 Jun 2014, 08:05:07 hrs PST8PDT
   Bugs fixed:

Patch  18522509     : applied on Mon Jul 21 07:32:27 CEST 2014
Unique Patch ID:  17604597
Patch description:  "Database Patch Set Update : 11.2.0.4.3 (18522509)"
   Created on 30 Jun 2014, 08:14:42 hrs PST8PDT
Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"

[root@grac41 Desktop]# olsnodes -s -t
grac41    Active    Unpinned
grac42    Active    Unpinned
grac43    Active    Unpinned

 

Reference

One thought on “Install PSU 11.2.0.4.3”

  1. Hi Helmut,

    Excellent article with steps mentioned clearly and in a linear manner,for patching GI. However, I have doubt regarding applying PSU on a non-RAC standalone DB on a single-node having the same version as the above GI, as to what should be the sequence of steps. If you could elaborate on that or direct to a article containing detailed steps, that would be very helpful.

    Thanks.

Leave a Reply to CuriousDBA Cancel reply

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