Follow the Readme.html or .txt for each Patch:
* Update Opatch
* Patch 12311357 – 11.2.0.2.2 GI Patch Set Update (Includes Database PSU 11.2.0.2.2)
* Patch for Bug# 12431716 for Linux x86-64 Platforms; mutex patch
You can find below the steps we followed to patch both grid infrastructure and database homes for RAC 4 nodes on Redhat Linux:
FOR EACH NODE DO THE FOLLOWING: The cluster should be up and running to apply the patch.
For all nodes of the cluster:
- Make a copy of the old optach directory to optach.OLD for database homes and grid homes.
- Copy the new version of the opatch to database homes OPtach and grid homes OPtach.
unzip
The version output of the previous command should be 11.2.0.1.5 or later.
[grid@db01 bin]$ su grid
[grid@db01 bin]$ cd /opt/11.2.0/grid/OPatch/ocm/bin
[grid@db01 bin]$ ./emocmrsp
OCM Installation Response Generator 10.3.4.0.0 - Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM configuration response file (ocm.rsp) was successfully created.
[grid@db01 bin]$
[grid@db01 OPatch]$ cd /opt/11.2.0/grid/OPatch
[grid@db01 OPatch]$ ./opatch lsinventory -detail -oh /opt/11.2.0/grid
Invoking OPatch 11.2.0.1.5
Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /opt/11.2.0/grid
Central Inventory : /opt/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.5
OUI version : 11.2.0.2.0
OUI location : /opt/11.2.0/grid/oui
Log file location : /opt/11.2.0/grid/cfgtoollogs/opatch/opatch2011-06-08_18-20-55PM.log
Patch history file: /opt/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2011-06-08_18-20-55PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure 11.2.0.2.0
There are 1 products installed in this Oracle Home.
Installed Products (88):
Agent Required Support Files 10.2.0.4.3
Assistant Common Files 11.2.0.2.0
Automatic Storage Management Assistant 11.2.0.2.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.2.0
Character Set Migration Utility 11.2.0.2.0
Cluster Ready Services Files 11.2.0.2.0
Cluster Verification Utility Common Files 11.2.0.2.0
Cluster Verification Utility Files 11.2.0.2.0
Database SQL Scripts 11.2.0.2.0
Deinstallation Tool 11.2.0.2.0
Enterprise Manager Common Core Files 10.2.0.4.3
Enterprise Manager Common Files 10.2.0.4.3
Enterprise Manager plugin Common Files 11.2.0.2.0
Expat libraries 2.0.1.0.1
HAS Common Files 11.2.0.2.0
HAS Files for DB 11.2.0.2.0
Installation Common Files 11.2.0.2.0
Installation Plugin Files 11.2.0.2.0
Installer SDK Component 11.2.0.2.0
LDAP Required Support Files 11.2.0.2.0
OLAP SQL Scripts 11.2.0.2.0
Oracle Clusterware RDBMS Files 11.2.0.2.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.2.0
Oracle Core Required Support Files 11.2.0.2.0
Oracle Database 11g 11.2.0.2.0
Oracle Database 11g Multimedia Files 11.2.0.2.0
Oracle Database Deconfiguration 11.2.0.2.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.2.0
Oracle DBCA Deconfiguration 11.2.0.2.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.2.0
Oracle Globalization Support 11.2.0.2.0
Oracle Grid Infrastructure 11.2.0.2.0
Oracle Help For Java 4.2.9.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.2.0
Oracle Java Client 11.2.0.2.0
Oracle JDBC/OCI Instant Client 11.2.0.2.0
Oracle JDBC/THIN Interfaces 11.2.0.2.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.2.0
Oracle LDAP administration 11.2.0.2.0
Oracle Locale Builder 11.2.0.2.0
Oracle Multimedia 11.2.0.2.0
Oracle Multimedia Client Option 11.2.0.2.0
Oracle Multimedia Java Advanced Imaging 11.2.0.2.0
Oracle Multimedia Locator 11.2.0.2.0
Oracle Multimedia Locator RDBMS Files 11.2.0.2.0
Oracle Net 11.2.0.2.0
Oracle Net Listener 11.2.0.2.0
Oracle Net Required Support Files 11.2.0.2.0
Oracle Netca Client 11.2.0.2.0
Oracle Notification Service 11.2.0.2.0
Oracle Notification Service (eONS) 11.2.0.2.0
Oracle One-Off Patch Installer 11.2.0.0.2
Oracle Quality of Service Management (Client) 11.2.0.2.0
Oracle Quality of Service Management (Server) 11.2.0.2.0
Oracle RAC Deconfiguration 11.2.0.2.0
Oracle RAC Required Support Files-HAS 11.2.0.2.0
Oracle Recovery Manager 11.2.0.2.0
Oracle Security Developer Tools 11.2.0.2.0
Oracle Text Required Support Files 11.2.0.2.0
Oracle Universal Installer 11.2.0.2.0
Oracle USM Deconfiguration 11.2.0.2.0
Oracle Wallet Manager 11.2.0.2.0
Parser Generator Required Support Files 11.2.0.2.0
Perl Interpreter 5.10.0.0.1
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.2.0
PL/SQL Embedded Gateway 11.2.0.2.0
Platform Required Support Files 11.2.0.2.0
Precompiler Required Support Files 11.2.0.2.0
RDBMS Required Support Files 11.2.0.2.0
RDBMS Required Support Files for Instant Client 11.2.0.2.0
RDBMS Required Support Files Runtime 11.2.0.2.0
Required Support Files 11.2.0.2.0
Secure Socket Layer 11.2.0.2.0
SQL*Plus 11.2.0.2.0
SQL*Plus Files for Instant Client 11.2.0.2.0
SQL*Plus Required Support Files 11.2.0.2.0
SSL Required Support Files for InstantClient 11.2.0.2.0
Sun JDK 1.5.0.24.08
Universal Storage Manager Files 11.2.0.2.0
XDK Required Support Files 11.2.0.2.0
XML Parser for Java 11.2.0.2.0
There are 88 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = db01
Remote node = db02
Remote node = db03
Remote node = db04
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@db01 OPatch]$
[oracle@db01 OPatch]$ ./opatch lsinventory -detail -oh /opt/app/oracle/product/11.2.0/db_1
Invoking OPatch 11.2.0.1.5
Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /opt/app/oracle/product/11.2.0/db_1
Central Inventory : /opt/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.5
OUI version : 11.2.0.2.0
OUI location : /opt/app/oracle/product/11.2.0/db_1/oui
Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-06-08_18-25-06PM.log
Patch history file: /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2011-06-08_18-25-06PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.2.0
There are 1 products installed in this Oracle Home.
Installed Products (136):
Agent Required Support Files 10.2.0.4.3
Assistant Common Files 11.2.0.2.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.2.0
Character Set Migration Utility 11.2.0.2.0
Cluster Verification Utility Common Files 11.2.0.2.0
Database Configuration and Upgrade Assistants 11.2.0.2.0
Database SQL Scripts 11.2.0.2.0
Database Workspace Manager 11.2.0.2.0
Deinstallation Tool 11.2.0.2.0
Enterprise Edition Options 11.2.0.2.0
Enterprise Manager Agent 10.2.0.4.3
Enterprise Manager Agent Core Files 10.2.0.4.3
Enterprise Manager Common Core Files 10.2.0.4.3
Enterprise Manager Common Files 10.2.0.4.3
Enterprise Manager Database Plugin -- Agent Support 11.2.0.2.0
Enterprise Manager Database Plugin -- Repository Support 11.2.0.2.0
Enterprise Manager Grid Control Core Files 10.2.0.4.3
Enterprise Manager plugin Common Files 11.2.0.2.0
Enterprise Manager Repository Core Files 10.2.0.4.3
Exadata Storage Server 11.2.0.1.0
Expat libraries 2.0.1.0.1
Generic Connectivity Common Files 11.2.0.2.0
HAS Common Files 11.2.0.2.0
HAS Files for DB 11.2.0.2.0
Installation Common Files 11.2.0.2.0
Installation Plugin Files 11.2.0.2.0
Installer SDK Component 11.2.0.2.0
JAccelerator (COMPANION) 11.2.0.2.0
LDAP Required Support Files 11.2.0.2.0
OLAP SQL Scripts 11.2.0.2.0
Oracle 11g Warehouse Builder Required Files 11.2.0.2.0
Oracle Advanced Security 11.2.0.2.0
Oracle Application Express 11.2.0.2.0
Oracle Call Interface (OCI) 11.2.0.2.0
Oracle Clusterware RDBMS Files 11.2.0.2.0
Oracle Code Editor 1.2.1.0.0I
Oracle Configuration Manager 10.3.3.1.1
Oracle Configuration Manager Client 10.3.2.1.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.2.0
Oracle Core Required Support Files 11.2.0.2.0
Oracle Data Mining RDBMS Files 11.2.0.2.0
Oracle Database 11g 11.2.0.2.0
Oracle Database 11g 11.2.0.2.0
Oracle Database 11g Multimedia Files 11.2.0.2.0
Oracle Database Deconfiguration 11.2.0.2.0
Oracle Database Gateway for ODBC 11.2.0.2.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.2.0
Oracle Database Vault J2EE Application 11.2.0.2.0
Oracle Database Vault option 11.2.0.2.0
Oracle DBCA Deconfiguration 11.2.0.2.0
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager Console DB 11.2.0.2.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.2.0
Oracle Globalization Support 11.2.0.2.0
Oracle Help For Java 4.2.9.0.0
Oracle Help for the Web 2.0.14.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.2.0
Oracle Java Client 11.2.0.2.0
Oracle JDBC Server Support Package 11.2.0.2.0
Oracle JDBC/OCI Instant Client 11.2.0.2.0
Oracle JDBC/THIN Interfaces 11.2.0.2.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.2.0
Oracle Label Security 11.2.0.2.0
Oracle LDAP administration 11.2.0.2.0
Oracle Locale Builder 11.2.0.2.0
Oracle Message Gateway Common Files 11.2.0.2.0
Oracle Multimedia 11.2.0.2.0
Oracle Multimedia Annotator 11.2.0.2.0
Oracle Multimedia Client Option 11.2.0.2.0
Oracle Multimedia Java Advanced Imaging 11.2.0.2.0
Oracle Multimedia Locator 11.2.0.2.0
Oracle Multimedia Locator RDBMS Files 11.2.0.2.0
Oracle Net 11.2.0.2.0
Oracle Net Listener 11.2.0.2.0
Oracle Net Required Support Files 11.2.0.2.0
Oracle Net Services 11.2.0.2.0
Oracle Netca Client 11.2.0.2.0
Oracle Notification Service 11.2.0.2.0
Oracle Notification Service (eONS) 11.2.0.2.0
Oracle ODBC Driver 11.2.0.2.0
Oracle ODBC Driverfor Instant Client 11.2.0.2.0
Oracle OLAP 11.2.0.2.0
Oracle OLAP API 11.2.0.2.0
Oracle OLAP RDBMS Files 11.2.0.2.0
Oracle One-Off Patch Installer 11.2.0.0.2
Oracle Partitioning 11.2.0.2.0
Oracle Programmer 11.2.0.2.0
Oracle Quality of Service Management (Client) 11.2.0.2.0
Oracle RAC Deconfiguration 11.2.0.2.0
Oracle RAC Required Support Files-HAS 11.2.0.2.0
Oracle Real Application Testing 11.2.0.2.0
Oracle Recovery Manager 11.2.0.2.0
Oracle Security Developer Tools 11.2.0.2.0
Oracle Spatial 11.2.0.2.0
Oracle SQL Developer 11.2.0.2.0
Oracle Starter Database 11.2.0.2.0
Oracle Text 11.2.0.2.0
Oracle Text Required Support Files 11.2.0.2.0
Oracle UIX 2.2.24.6.0
Oracle Universal Connection Pool 11.2.0.2.0
Oracle Universal Installer 11.2.0.2.0
Oracle USM Deconfiguration 11.2.0.2.0
Oracle Wallet Manager 11.2.0.2.0
Oracle XML Development Kit 11.2.0.2.0
Oracle XML Query 11.2.0.2.0
Parser Generator Required Support Files 11.2.0.2.0
Perl Interpreter 5.10.0.0.1
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.2.0
PL/SQL Embedded Gateway 11.2.0.2.0
Platform Required Support Files 11.2.0.2.0
Precompiler Common Files 11.2.0.2.0
Precompiler Required Support Files 11.2.0.2.0
Provisioning Advisor Framework 10.2.0.4.3
RDBMS Required Support Files 11.2.0.2.0
RDBMS Required Support Files for Instant Client 11.2.0.2.0
RDBMS Required Support Files Runtime 11.2.0.2.0
regexp 2.1.9.0.0
Required Support Files 11.2.0.2.0
Sample Schema Data 11.2.0.2.0
Secure Socket Layer 11.2.0.2.0
SQL*Plus 11.2.0.2.0
SQL*Plus Files for Instant Client 11.2.0.2.0
SQL*Plus Required Support Files 11.2.0.2.0
SQLJ Runtime 11.2.0.2.0
SSL Required Support Files for InstantClient 11.2.0.2.0
Sun JDK 1.5.0.24.08
XDK Required Support Files 11.2.0.2.0
XML Parser for Java 11.2.0.2.0
XML Parser for Oracle JVM 11.2.0.2.0
There are 136 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = db01
Remote node = db02
Remote node = db03
Remote node = db04
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@db01 OPatch]$
[root@db04 opt]# mkdir patches
[root@db04 opt]#
[root@db04 opt]# chown grid:oinstall /opt/patches
[root@db04 opt]#
scp /opt/patches/grid/p12311357_112020_Linux-x86-64.zip grid@db03.example.com:/opt/patches/
unzip p12311357_112020_Linux-x86-64.zip
Problems:
[root@db01 OPatch]# ./opatch auto /opt/patches/grid/
Executing /usr/bin/perl ./crs/patch112.pl -patchdir /opt/patches -patchn grid -paramfile /opt/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /opt/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-06-09_09-38-04.log
Detected Oracle Clusterware install
Using configuration parameter file: /opt/11.2.0/grid/crs/install/crsconfig_params
OPatch is bundled with OCM, Enter the absolute OCM response file path:
/opt/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Clusterware is either not running or not configured. You have the following 2 options
1. Configure and Start the Clusterware on this node and re-run the tool
2. or Run the tool with the -och <CRS_HOME_PATH> option and then invoke tool with -oh <comma seperated ORACLE_HOME_LIST> to patch the RDBMS home
As a root user
[root@db01 grid]# su -
[root@db03 ~]# cd /opt/11.2.0/grid/OPatch
[root@db01 OPatch]# ls
crs docs emdpatch.pl fmw jlib ocm opatch opatch.bat opatch.ini opatch.pl opatchprereqs README.txt
[root@db01 OPatch]# ./opatch auto /opt/patches/
Executing /usr/bin/perl ./crs/patch112.pl -patchdir /opt/patches -patchn grid -paramfile /opt/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /opt/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-06-09_09-56-11.log
Detected Oracle Clusterware install
Using configuration parameter file: /opt/11.2.0/grid/crs/install/crsconfig_params
OPatch is bundled with OCM, Enter the absolute OCM response file path:
/opt/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
patch /opt/patches/grid/12311357/custom/server/12311357 apply successful for home /opt/app/oracle/product/11.2.0/db_1
patch /opt/patches/grid/11724916 apply successful for home /opt/app/oracle/product/11.2.0/db_1
Successfully unlock /opt/11.2.0/grid
patch /opt/patches/grid/12311357 apply successful for home /opt/11.2.0/grid
patch /opt/patches/grid/11724916 apply successful for home /opt/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@db01 OPatch]#
from only one node:
[oracle@db01 OPatch]$ cd $ORACLE_HOME/rdbms/admin
[oracle@db01 admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jun 9 11:17:39 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 1.4965E+10 bytes
Fixed Size 2241040 bytes
Variable Size 2046823920 bytes
Database Buffers 1.2885E+10 bytes
Redo Buffers 31297536 bytes
Database mounted.
Database opened.
SQL> @catbundle.sql psu apply
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Generating apply and rollback scripts...
Check the following file for errors:
/opt/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_mydb_GENERATE_2011Jun09_11_18_28.log
Apply script: /opt/app/oracle/product/11.2.0/db_1/rdbms/admin/catbundle_PSU_mydb_APPLY.sql
Rollback script: /opt/app/oracle/product/11.2.0/db_1/rdbms/admin/catbundle_PSU_mydb_ROLLBACK.sql
PL/SQL procedure successfully completed.
Executing script file...
SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/opt/app/oracle/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;
SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')
PL/SQL procedure successfully completed.
SQL> PROMPT Skipping Oracle Database Vault because it is not installed or versions mismatch...
Skipping Oracle Database Vault because it is not installed or versions mismatch...
SQL> ALTER SESSION SET current_schema = SYS;
Session altered.
SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
2 (action_time, action,
3 namespace, version, id,
4 bundle_series, comments)
5 VALUES
6 (SYSTIMESTAMP, 'APPLY',
7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
8 '11.2.0.2',
9 2,
10 'PSU',
11 'PSU 11.2.0.2.2');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/opt/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_mydb_APPLY_2011Jun09_11_18_29.log
SQL>
NOW MUTEX PATCH:
[grid@db01 Linux_x86_64_11202]$ cp p12431716_112022_Linux-x86-64.zip /opt/patches/mutex/
[grid@db01 Linux_x86_64_11202]$ cd /opt/patches/mutex/
[grid@db01 mutex]$ unzip p12431716_112022_Linux-x86-64.zip
Archive: p12431716_112022_Linux-x86-64.zip
creating: 12431716/
creating: 12431716/files/
creating: 12431716/files/lib/
creating: 12431716/files/lib/libgeneric11.a/
inflating: 12431716/files/lib/libgeneric11.a/kgx.o
creating: 12431716/etc/
creating: 12431716/etc/config/
inflating: 12431716/etc/config/inventory.xml
inflating: 12431716/etc/config/actions.xml
inflating: 12431716/etc/config/deploy.xml
creating: 12431716/etc/xml/
inflating: 12431716/etc/xml/GenericActions.xml
inflating: 12431716/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 12431716/README.txt
[grid@db01 mutex]$ ls -rtl
total 24
drwxrwxr-x 4 grid oinstall 4096 May 6 06:52 12431716
-rw-r--r-- 1 grid oinstall 17165 Jun 9 10:56 p12431716_112022_Linux-x86-64.zip
[grid@db01 mutex]$ cd 12431716/
[grid@db01 12431716]$ ls
etc files README.txt
[grid@db01 12431716]$ cd ..
[grid@db01 mutex]$
[grid@db01 mutex]$
[grid@db01 mutex]$
[grid@db01 mutex]$ scp p12431716_112022_Linux-x86-64.zip grid@db02.example.com:/opt/patches/mutex/
p12431716_112022_Linux-x86-64.zip 100% 17KB 16.8KB/s 00:00
[grid@db01 mutex]$ scp p12431716_112022_Linux-x86-64.zip grid@db03.example.com:/opt/patches/mutex/
p12431716_112022_Linux-x86-64.zip 100% 17KB 16.8KB/s 00:00
[grid@db01 mutex]$ scp p12431716_112022_Linux-x86-64.zip grid@db04.example.com:/opt/patches/mutex/
p12431716_112022_Linux-x86-64.zip 100% 17KB 16.8KB/s 00:00
[grid@db01 mutex]$ pwd
/opt/patches/mutex
[grid@db01 mutex]$
For Every Node:
[oracle@db02 bin]$ source /home/oracle/.bash_profile
[oracle@db02 bin]$ $ORACLE_HOME/bin/srvctl stop instance -d mydb -n db02
PRCC-1017 : mydb was already stopped on db02
[oracle@db02 bin]$
[root@db01 install]# su -
[root@db01 install]# cd /opt/11.2.0/grid/crs/install
[root@db01 install]# pwd
/opt/11.2.0/grid/crs/install
[root@db01 install]# ./rootcrs.pl -unlock
Using configuration parameter file: ./crsconfig_params
Successfully unlock /opt/11.2.0/grid
[root@db01 install]#
[grid@db01 OPatch]$ su grid
[grid@db01 OPatch]$ source /home/grid/.bash_profile
[grid@db01 OPatch]$ echo $GRID_HOME
/opt/11.2.0/grid
[grid@db01 OPatch]$ cd /opt/11.2.0/grid/OPatch
[grid@db01 OPatch]$ ./opatch apply -oh /opt/11.2.0/grid -local /opt/patches/mutex/12431716
Invoking OPatch 11.2.0.1.5
Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /opt/11.2.0/grid
Central Inventory : /opt/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.5
OUI version : 11.2.0.2.0
OUI location : /opt/11.2.0/grid/oui
Log file location : /opt/11.2.0/grid/cfgtoollogs/opatch/opatch2011-06-09_11-47-42AM.log
Patch history file: /opt/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '12431716' to OH '/opt/11.2.0/grid'
Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
You selected -local option, hence OPatch will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/11.2.0/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '12431716' for restore. This might take a while...
Backing up files affected by the patch '12431716' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Updating archive file "/opt/11.2.0/grid/lib/libgeneric11.a" with "lib/libgeneric11.a/kgx.o"
Running make for target ioracle
Running make for target irenamedg
Running make for target client_sharedlib
ApplySession adding interim patch '12431716' to inventory
Verifying the update...
Inventory check OK: Patch ID 12431716 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 12431716 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[grid@db01 OPatch]$
As a root user:
[root@db01 install]# cd /opt/11.2.0/grid/crs/install
[root@db01 install]# ./rootcrs.pl -patch
Using configuration parameter file: ./crsconfig_params
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@db01 install]#
----------
Patch Oracle RDBMS Homes:
[root@db01 bin]# su oracle
[oracle@db01 bin]$ source /home/oracle/.bash_profile
[oracle@db01 grid]$ cd /opt/app/oracle/product/11.2.0/db_1/OPatch
[oracle@db01 OPatch]$ echo $ORACLE_HOME
/opt/app/oracle/product/11.2.0/db_1
[oracle@db01 OPatch]$ ./opatch apply -oh /opt/app/oracle/product/11.2.0/db_1 -local /opt/patches/mutex/12431716
Invoking OPatch 11.2.0.1.5
Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /opt/app/oracle/product/11.2.0/db_1
Central Inventory : /opt/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.5
OUI version : 11.2.0.2.0
OUI location : /opt/app/oracle/product/11.2.0/db_1/oui
Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-06-09_14-22-41PM.log
Patch history file: /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '12431716' to OH '/opt/app/oracle/product/11.2.0/db_1'
Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
You selected -local option, hence OPatch will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/app/oracle/product/11.2.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '12431716' for restore. This might take a while...
Backing up files affected by the patch '12431716' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Updating archive file "/opt/app/oracle/product/11.2.0/db_1/lib/libgeneric11.a" with "lib/libgeneric11.a/kgx.o"
Running make for target ioracle
Running make for target irenamedg
Running make for target client_sharedlib
ApplySession adding interim patch '12431716' to inventory
Verifying the update...
Inventory check OK: Patch ID 12431716 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 12431716 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@db01 OPatch]$
------------
On every nodes:
[root@db01 bin]# cd /opt/11.2.0/grid/bin
[root@db01 bin]# ./srvctl start instance -d mydb -n db01
My check:
SQL> select VERSION, COMMENTS from registry$history;
VERSION
------------------------------
COMMENTS
--------------------------------------------------------------------------------
11.2.0.2
Patchset 11.2.0.2.0
11.2.0.2
PSU 11.2.0.2.2
SQL>
-----------------------
Hope it helps!
Wissem
Blog's RSS Feed
Loading ...
Just the scripts I posted above