Table of Contents
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
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.