说明:
数据库 11.2.0.4 是数据库 11.2 的最终补丁集,Oracle
2014年10月14日发布了11.2.0.4.4的Patch包,
Oracle推荐的Patches见【Oracle Recommended Patches -- Oracle Database (文档 ID 756671.1)】的下面部分:
11.2.0.4 Current Recommended Patches
Patch Set Updates
Document Description Rolling RAC Patch Download Note:19791364.8 Combo of 11.2.0.4.1 OJVM PSU and 11.2.0.4.4 DB PSU (Oct 2014) No Patch:19791364 Note:19282021.8 Oracle JavaVM Component 11.2.0.4.1 Database PSU (Oct 2014) (OJVM PSU) No Patch:19282021 Note:19121551.8 11.2.0.4.4 (Oct 2014) Database Patch Set Update (DB PSU) Yes Patch:19121551
Grid Infrastructure
Also see:
Document Description Rolling RAC Patch Download Note:19791420.8 Combo of 11.2.0.4.1 OJVM PSU and 11.2.0.4.4 GI PSU (Oct 2014) No Patch:19791420 Note:19380115.8 11.2.0.4.4 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:19380115
- Note:1645862.1 Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results
如果是RAC环境,直接打
Patch:19380115就可以,该patch包含集群和数据库的patch
The GI PSU patch includes updates for both the Clusterware home and Database home that can be applied in a rolling fashion.
整个PSU过程参考了19380115patch包中的README.html文档。
下面开始PSU的步骤:
1,OPatch Utility Information
1.1下载
opatch的版本要求11.2.0.3.6以及以上版本,我的版本是11.2.0.3.4,因此要从MOS上 patch 6880880
中选择11.2.0.0.0 下载即可。
1.2 每个rac节点的ORACLE_HOME和GI_HOME都要patch
将p6880880_112000_Linux-x86-64.zip解压并覆盖各个节点databases home 和 GI home
- [oracle@rac1 backup]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME/
- [oracle@rac1 backup]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version
- OPatch Version: 11.2.0.3.6
- OPatch succeeded.
- [oracle@rac1 backup]$
1.3 OCM Configuration
- The OPatch utility will prompt for your OCM (Oracle Configuration Manager) response file when it is run. You should enter a complete path of OCM response file if you already have created this in your environment. OCM response file is required and is not optional.
- If you do not have the OCM response file (ocm.rsp), see the following My Oracle Support Document 966023.1 How To Create An OCM Response File For Opatch Silent Installation.
ocm的作用就是当你在安装patch的时候,如果没有ocm.rsp这个文件的话,安装会不断的停下来让用户输入信息,而ocm就解决了这个问题,静默安装,
用户无需干预。而且从上面可以看到ocm.rsp是必须的,所以还要以grid或oracle用户到两个节点的对应目录下去生成 OCM response file.
- [grid@rac2 bin]$ $ORACLE_HOME/OPatch/ocm/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@rac2 bin]$ ls
- emocmrsp ocm.rsp
或者你可以指定生成文件的目录及文件名,只要方便你下面使用就可以
- [oracle@rac1 ocm]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /backup/file.rsp
- 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 (/backup/file.rsp) was successfully created.
- [oracle@rac1 ocm]$
- [oracle@rac1 ocm]$ cd /backup/
- [oracle@rac1 backup]$ ls
- 19380115 file.rsp lost+found p19380115_112040_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip PatchSearch.xml pfile_std.ora zhang.dmp
- [oracle@rac1 backup]$
1.4 Validation of Oracle Inventory
开始安装patch之前,运行下面的命令检查database和grid的Inventory信息的一致性。
- [oracle@rac1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
- Oracle Interim Patch Installer version 11.2.0.3.6
- Copyright (c) 2012, Oracle Corporation. All rights reserved.
- Oracle Home : /u01/app/oracle/product/11.2.0/db_1
- Central Inventory : /u01/app/oraInventory
- from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
- OPatch version : 11.2.0.3.6
- OUI version : 11.2.0.4.0
- Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-10-27_18-05-04PM_1.log
- Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-27_18-05-04PM.txt
- --------------------------------------------------------------------------------
- Installed Top-level Products (1):
- Oracle Database 11g 11.2.0.4.0
- There are 1 products installed in this Oracle Home.
- Installed Products (136):
- Agent Required Support Files 10.2.0.4.5
- Assistant Common Files 11.2.0.4.0
- Bali Share 1.1.18.0.0
- Buildtools Common Files 11.2.0.4.0
- Character Set Migration Utility 11.2.0.4.0
- Cluster Verification Utility Common Files 11.2.0.4.0
- Database Configuration and Upgrade Assistants 11.2.0.4.0
- Database SQL Scripts 11.2.0.4.0
- Database Workspace Manager 11.2.0.4.0
- Deinstallation Tool 11.2.0.4.0
- Enterprise Edition Options 11.2.0.4.0
- Enterprise Manager Agent 10.2.0.4.5
- Enterprise Manager Agent Core Files 10.2.0.4.5
- Enterprise Manager Common Core Files 10.2.0.4.5
- Enterprise Manager Common Files 10.2.0.4.5
- Enterprise Manager Database Plugin -- Agent Support 11.2.0.4.0
- Enterprise Manager Database Plugin -- Repository Support 11.2.0.4.0
- Enterprise Manager Grid Control Core Files 10.2.0.4.5
- Enterprise Manager plugin Common Files 11.2.0.4.0
- Enterprise Manager Repository Core Files 10.2.0.4.5
- Exadata Storage Server 11.2.0.1.0
- Expat libraries 2.0.1.0.1
- Generic Connectivity Common Files 11.2.0.4.0
- HAS Common Files 11.2.0.4.0
- HAS Files for DB 11.2.0.4.0
- Installation Common Files 11.2.0.4.0
- Installation Plugin Files 11.2.0.4.0
- Installer SDK Component 11.2.0.4.0
- JAccelerator (COMPANION) 11.2.0.4.0
- Java Development Kit 1.5.0.51.10
- LDAP Required Support Files 11.2.0.4.0
- OLAP SQL Scripts 11.2.0.4.0
- Oracle 11g Warehouse Builder Required Files 11.2.0.4.0
- Oracle Advanced Security 11.2.0.4.0
- Oracle Application Express 11.2.0.4.0
- Oracle Call Interface (OCI) 11.2.0.4.0
- Oracle Clusterware RDBMS Files 11.2.0.4.0
- Oracle Code Editor 1.2.1.0.0I
- Oracle Configuration Manager 10.3.8.1.0
- 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.4.0
- Oracle Core Required Support Files 11.2.0.4.0
- Oracle Data Mining RDBMS Files 11.2.0.4.0
- Oracle Database 11g 11.2.0.4.0
- Oracle Database 11g 11.2.0.4.0
- Oracle Database 11g Multimedia Files 11.2.0.4.0
- Oracle Database Deconfiguration 11.2.0.4.0
- Oracle Database Gateway for ODBC 11.2.0.4.0
- Oracle Database User Interface 2.2.13.0.0
- Oracle Database Utilities 11.2.0.4.0
- Oracle Database Vault J2EE Application 11.2.0.4.0
- Oracle Database Vault option 11.2.0.4.0
- Oracle DBCA Deconfiguration 11.2.0.4.0
- Oracle Display Fonts 9.0.2.0.0
- Oracle Enterprise Manager Console DB 11.2.0.4.0
- Oracle Extended Windowing Toolkit 3.4.47.0.0
- Oracle Globalization Support 11.2.0.4.0
- Oracle Globalization Support 11.2.0.4.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.4.0
- Oracle Java Client 11.2.0.4.0
- Oracle JDBC Server Support Package 11.2.0.4.0
- Oracle JDBC/OCI Instant Client 11.2.0.4.0
- Oracle JDBC/THIN Interfaces 11.2.0.4.0
- Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
- Oracle JVM 11.2.0.4.0
- Oracle Label Security 11.2.0.4.0
- Oracle LDAP administration 11.2.0.4.0
- Oracle Locale Builder 11.2.0.4.0
- Oracle Message Gateway Common Files 11.2.0.4.0
- Oracle Multimedia 11.2.0.4.0
- Oracle Multimedia Annotator 11.2.0.4.0
- Oracle Multimedia Client Option 11.2.0.4.0
- Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
- Oracle Multimedia Locator 11.2.0.4.0
- Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
- Oracle Net 11.2.0.4.0
- Oracle Net Listener 11.2.0.4.0
- Oracle Net Required Support Files 11.2.0.4.0
- Oracle Net Services 11.2.0.4.0
- Oracle Netca Client 11.2.0.4.0
- Oracle Notification Service 11.2.0.3.0
- Oracle Notification Service (eONS) 11.2.0.4.0
- Oracle ODBC Driver 11.2.0.4.0
- Oracle ODBC Driverfor Instant Client 11.2.0.4.0
- Oracle OLAP 11.2.0.4.0
- Oracle OLAP API 11.2.0.4.0
- Oracle OLAP RDBMS Files 11.2.0.4.0
- Oracle One-Off Patch Installer 11.2.0.3.4
- Oracle Partitioning 11.2.0.4.0
- Oracle Programmer 11.2.0.4.0
- Oracle Quality of Service Management (Client) 11.2.0.4.0
- Oracle RAC Deconfiguration 11.2.0.4.0
- Oracle RAC Required Support Files-HAS 11.2.0.4.0
- Oracle Real Application Testing 11.2.0.4.0
- Oracle Recovery Manager 11.2.0.4.0
- Oracle Security Developer Tools 11.2.0.4.0
- Oracle Spatial 11.2.0.4.0
- Oracle SQL Developer 11.2.0.4.0
- Oracle Starter Database 11.2.0.4.0
- Oracle Text 11.2.0.4.0
- Oracle Text Required Support Files 11.2.0.4.0
- Oracle UIX 2.2.24.6.0
- Oracle Universal Connection Pool 11.2.0.4.0
- Oracle Universal Installer 11.2.0.4.0
- Oracle USM Deconfiguration 11.2.0.4.0
- Oracle Wallet Manager 11.2.0.4.0
- Oracle XML Development Kit 11.2.0.4.0
- Oracle XML Query 11.2.0.4.0
- Parser Generator Required Support Files 11.2.0.4.0
- Perl Interpreter 5.10.0.0.2
- Perl Modules 5.10.0.0.1
- PL/SQL 11.2.0.4.0
- PL/SQL Embedded Gateway 11.2.0.4.0
- Platform Required Support Files 11.2.0.4.0
- Precompiler Common Files 11.2.0.4.0
- Precompiler Required Support Files 11.2.0.4.0
- Provisioning Advisor Framework 10.2.0.4.3
- RDBMS Required Support Files 11.2.0.4.0
- RDBMS Required Support Files for Instant Client 11.2.0.4.0
- RDBMS Required Support Files Runtime 11.2.0.4.0
- regexp 2.1.9.0.0
- Required Support Files 11.2.0.4.0
- Sample Schema Data 11.2.0.4.0
- Secure Socket Layer 11.2.0.4.0
- SQL*Plus 11.2.0.4.0
- SQL*Plus Files for Instant Client 11.2.0.4.0
- SQL*Plus Required Support Files 11.2.0.4.0
- SQLJ Runtime 11.2.0.4.0
- SSL Required Support Files for InstantClient 11.2.0.4.0
- XDK Required Support Files 11.2.0.4.0
- XML Parser for Java 11.2.0.4.0
- XML Parser for Oracle JVM 11.2.0.4.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 = rac1
- Remote node = rac2
- --------------------------------------------------------------------------------
- OPatch succeeded.
1.5 Download and Unzip the Patch
下载 Patch:19380115 并解压,解压后要把解压目录的属主修改一下,否则patch的时候可能会失败。
- $ cd <UNZIPPED_PATCH_LOCATION>
- Check that the directory is empty.
- $ ls
- Unzip the patch as grid home owner.
- $ unzip p19380115_112040_<platform>.zip
- $ chown -R grid:oinstall 19380115
1.6 One-off Patch Conflict Detection and Resolution
用ORACLE_HOME和GI_HOME下的opatch做最后安装前的冲突检查,此步骤也可以略过,因此在patch的时候会自动做冲突检测。
- [grid@rac1 19380115]$ $GI_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/19380115
- Oracle Interim Patch Installer version 11.2.0.3.6
- Copyright (c) 2013, Oracle Corporation. All rights reserved.
- PREREQ session
- Oracle Home : /u01/app/11.2.0/grid
- Central Inventory : /u01/app/oraInventory
- from : /u01/app/11.2.0/grid/oraInst.loc
- OPatch version : 11.2.0.3.6
- OUI version : 11.2.0.4.0
- Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2014-10-27_21-29-02PM_1.log
- Invoking prereq "checkconflictagainstohwithdetail"
- Prereq "checkConflictAgainstOHWithDetail" passed.
- OPatch succeeded.
2 Patch Installation 安装
- The patch instructions will differ based on the configuration of the Grid infrastructure and the Oracle RAC database homes. Patching instructions for Oracle RAC Database Homes and GI together are listed below.
- The most common configurations are listed as follows:
- Case 1: GI Home and the Database Homes that are not shared and ACFS file system is not configured.
- Case 2: GI Home is not shared, Database Home is shared, ACFS may be used.
简单说,oracle认为patch的时候大多数就2中情况,一种是GI Home和DB HOME是各自独立的目录而且ACFS没有配置;
另一种情况是GI Home是独立的目录,而DB Home是共享的,ACFS可能配置了。我的环境属于第一种情况,
如果你的环境属于第二种可以参考readme中的方法,下面开始执行安装命令。
节点1
- [root@rac1 ~]# $ORACLE_HOME/OPatch/opatch auto /backup/19380115 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
- Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /backup -patchn 19380115 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
- This is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-10-27_22-36-23.log
- This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
- /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-10-27_22-36-23.report.log
- 2014-10-27 22:36:23: Starting Clusterware Patch Setup
- Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
- Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
- Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
- patch /backup/19380115/19121551 apply successful for home /u01/app/oracle/product/11.2.0/db_1
- patch /backup/19380115/19121549/custom/server/19121549 apply successful for home /u01/app/oracle/product/11.2.0/db_1
- Stopping CRS...
- Stopped CRS successfully
- patch /backup/19380115/19121551 apply successful for home /u01/app/11.2.0/grid
- patch /backup/19380115/19121549 apply failed for home /u01/app/11.2.0/grid
- Starting CRS...
- Installing Trace File Analyzer
- CRS-4123: Oracle High Availability Services has been started.
- Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
- Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
- opatch auto succeeded.
- [root@rac1 ~]#
节点2
- [root@rac2 ~]# $ORACLE_HOME/OPatch/opatch auto /backup/19380115 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
- Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /backup -patchn 19380115 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
- This is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-10-27_22-48-16.log
- This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
- /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-10-27_22-48-16.report.log
- 2014-10-27 22:48:16: Starting Clusterware Patch Setup
- Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
- Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
- Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
- patch /backup/19380115/19121551 apply successful for home /u01/app/oracle/product/11.2.0/db_1
- patch /backup/19380115/19121549/custom/server/19121549 apply successful for home /u01/app/oracle/product/11.2.0/db_1
- Stopping CRS...
- Stopped CRS successfully
- patch /backup/19380115/19121551 apply successful for home /u01/app/11.2.0/grid
- patch /backup/19380115/19121549 apply failed for home /u01/app/11.2.0/grid
- Starting CRS...
- Installing Trace File Analyzer
- CRS-4123: Oracle High Availability Services has been started.
- Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
- Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
- opatch auto succeeded.
3 Loading Modified SQL Files into the Database 在数据库中应用PSU
在每个数据库实例上运行:
- [root@rac1 ~]# su - oracle
- [oracle@rac1 ~]$ sqlplus / as sysdba
- SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 27 22:15:33 2014
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
- Data Mining and Real Application Testing options
- SQL> @?/rdbms/admin/catbundle.sql psu apply
4 验证
4.1 节点1的DB PSU安装验证
- [oracle@rac1 19380115]$ cd $ORACLE_HOME/OPatch
- [oracle@rac1 OPatch]$ ./opatch lsinventory
- Oracle Interim Patch Installer version 11.2.0.3.6
- Copyright (c) 2013, Oracle Corporation. All rights reserved.
- Oracle Home : /u01/app/oracle/product/11.2.0/db_1
- Central Inventory : /u01/app/oraInventory
- from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
- OPatch version : 11.2.0.3.6
- OUI version : 11.2.0.4.0
- Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-10-28_09-04-45AM_1.log
- Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-28_09-04-45AM.txt
- --------------------------------------------------------------------------------
- Installed Top-level Products (1):
- Oracle Database 11g 11.2.0.4.0
- There are 1 product(s) installed in this Oracle Home.
- Interim patches (2) :
- Patch 19121549 : applied on Mon Oct 27 22:39:54 CST 2014
- Unique Patch ID: 18065664
- Patch description: "OCW Patch Set Update : 11.2.0.4.4 (19121549)"
- Created on 6 Oct 2014, 03:26:54 hrs PST8PDT
- Bugs fixed:
- 18328800, 18691572, 14525998, 18187697, 18348155, 17516024, 17387214
- 17750548, 17617807, 17551223, 14671408, 14207615, 18272135, 18180541
- 17292250, 17378618, 17500165, 18875012, 18464784, 17065496, 18848125
- 13991403, 17955615, 14693336, 17273020, 17238586, 17089344, 17405605
- 17531342, 17155238, 17159489, 18053580, 16543190, 17039197, 16317771
- 17947785, 10052729, 16281493, 18346135, 17481314, 18199185, 18399991
- 18024089, 18428146, 18352845, 18352846, 17391726, 18414137, 17001914
- 17927970, 14378120, 16346413, 17305100, 15832129, 15986647, 16901346
- 18068871, 17985714, 18536826, 16206997, 18752378, 16876500, 16429265
- 18343490, 18336452, 16613232, 17273003, 19276791, 12928658, 18226143
- 17172091, 18229842, 18053631, 16867761, 18231837, 15869775, 17483479
- 18729166, 17405302, 15920201, 18709496
- Patch 19121551 : applied on Mon Oct 27 22:38:36 CST 2014
- Unique Patch ID: 17949166
- Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)"
- Created on 6 Oct 2014, 10:07:57 hrs PST8PDT
- Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
- 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)"
- Bugs fixed:
- 17288409, 17205719, 17811429, 17754782, 17726838, 13364795, 17311728
- 17284817, 17441661, 13645875, 18199537, 16992075, 16542886, 17446237
- 14565184, 17071721, 17610798, 17375354, 17449815, 17397545, 19463897
- 18230522, 17235750, 16360112, 13866822, 17982555, 17478514, 12905058
- 14338435, 13944971, 16929165, 12747740, 17546973, 14054676, 17088068
- 18264060, 17343514, 17016369, 17042658, 14602788, 14657740, 17332800
- 19211724, 13951456, 16315398, 17186905, 18744139, 16850630, 17437634
- 19049453, 18673304, 17883081, 18641419, 17296856, 18262334, 17006183
- 18277454, 17232014, 16855292, 10136473, 17705023, 17865671, 18554871
- 19121551, 17588480, 17551709, 17344412, 17842825, 18681862, 17390160
- 13955826, 13609098, 18139690, 17501491, 17239687, 17752121, 17299889
- 17602269, 18673325, 17313525, 17242746, 19544839, 17600719, 18191164
- 17571306, 19466309, 17951233, 18094246, 17165204, 17011832, 17040527
- 16785708, 16180763, 17477958, 17174582, 17465741, 18522509, 17323222
- 19463893, 16875449, 16524926, 17237521, 17596908, 17811438, 17811447
- 18031668, 16912439, 16494615, 18061914, 17545847, 17082359, 19554106
- 17614134, 17341326, 17891946, 19458377, 17716305, 17752995, 16392068
- 19271443, 17767676, 17614227, 17040764, 17381384, 18973907, 18673342
- 14084247, 17389192, 17006570, 17612828, 17721717, 13853126, 18203837
- 17390431, 17570240, 14245531, 16043574, 16863422, 19727057, 17468141
- 17786518, 17037130, 17267114, 18203838, 16198143, 16956380, 17478145
- 14829250, 17394950, 17027426, 16268425, 18247991, 19584068, 14458214
- 18436307, 17265217, 13498382, 16692232, 17786278, 17227277, 16042673
- 16314254, 17443671, 16228604, 16837842, 17393683, 17787259, 18009564
- 15861775, 16399083, 18018515, 16472716, 17050888, 14010183, 17325413
- 16613964, 17080436, 17036973, 17761775, 16721594, 18280813, 15979965
- 18203835, 17297939, 16731148, 17811456, 14133975, 17385178, 17586955
- 16450169, 17655634, 9756271, 17892268, 17648596, 16220077, 16069901
- 11733603, 16285691, 17587063, 18180390, 17393915, 18096714, 17238511
- 17824637, 14285317, 19289642, 14764829, 18328509, 17622427, 16943711
- 17346671, 18996843, 14852021, 17783588, 16618694, 17672719, 17546761
- Rac system comprising of multiple nodes
- Local node = rac1
- Remote node = rac2
- --------------------------------------------------------------------------------
- OPatch succeeded.
- [oracle@rac1 OPatch]$
4.2 节点1的GRID PSU验证
- [oracle@rac1 OPatch]$ su - grid
- Password:
- [grid@rac1 ~]$ cd $GI_HOME/OPatch
- [grid@rac1 OPatch]$ ./opatch lsinventory
- Oracle Interim Patch Installer version 11.2.0.3.6
- Copyright (c) 2013, Oracle Corporation. All rights reserved.
- Oracle Home : /u01/app/11.2.0/grid
- Central Inventory : /u01/app/oraInventory
- from : /u01/app/11.2.0/grid/oraInst.loc
- OPatch version : 11.2.0.3.6
- OUI version : 11.2.0.4.0
- Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2014-10-28_09-08-45AM_1.log
- Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2014-10-28_09-08-45AM.txt
- --------------------------------------------------------------------------------
- Installed Top-level Products (1):
- Oracle Grid Infrastructure 11g 11.2.0.4.0
- There are 1 product(s) installed in this Oracle Home.
- Interim patches (1) :
- Patch 19121551 : applied on Mon Oct 27 22:43:28 CST 2014
- Unique Patch ID: 17949166
- Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)"
- Created on 6 Oct 2014, 10:07:57 hrs PST8PDT
- Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
- 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)"
- Bugs fixed:
- 17288409, 17205719, 17811429, 17754782, 17726838, 13364795, 17311728
- 17284817, 17441661, 13645875, 18199537, 16992075, 16542886, 17446237
- 14565184, 17071721, 17610798, 17375354, 17449815, 17397545, 19463897
- 18230522, 17235750, 16360112, 13866822, 17982555, 17478514, 12905058
- 14338435, 13944971, 16929165, 12747740, 17546973, 14054676, 17088068
- 18264060, 17343514, 17016369, 17042658, 14602788, 14657740, 17332800
- 19211724, 13951456, 16315398, 17186905, 18744139, 16850630, 17437634
- 19049453, 18673304, 17883081, 18641419, 17296856, 18262334, 17006183
- 18277454, 17232014, 16855292, 10136473, 17705023, 17865671, 18554871
- 19121551, 17588480, 17551709, 17344412, 17842825, 18681862, 17390160
- 13955826, 13609098, 18139690, 17501491, 17239687, 17752121, 17299889
- 17602269, 18673325, 17313525, 17242746, 19544839, 17600719, 18191164
- 17571306, 19466309, 17951233, 18094246, 17165204, 17011832, 17040527
- 16785708, 16180763, 17477958, 17174582, 17465741, 18522509, 17323222
- 19463893, 16875449, 16524926, 17237521, 17596908, 17811438, 17811447
- 18031668, 16912439, 16494615, 18061914, 17545847, 17082359, 19554106
- 17614134, 17341326, 17891946, 19458377, 17716305, 17752995, 16392068
- 19271443, 17767676, 17614227, 17040764, 17381384, 18973907, 18673342
- 14084247, 17389192, 17006570, 17612828, 17721717, 13853126, 18203837
- 17390431, 17570240, 14245531, 16043574, 16863422, 19727057, 17468141
- 17786518, 17037130, 17267114, 18203838, 16198143, 16956380, 17478145
- 14829250, 17394950, 17027426, 16268425, 18247991, 19584068, 14458214
- 18436307, 17265217, 13498382, 16692232, 17786278, 17227277, 16042673
- 16314254, 17443671, 16228604, 16837842, 17393683, 17787259, 18009564
- 15861775, 16399083, 18018515, 16472716, 17050888, 14010183, 17325413
- 16613964, 17080436, 17036973, 17761775, 16721594, 18280813, 15979965
- 18203835, 17297939, 16731148, 17811456, 14133975, 17385178, 17586955
- 16450169, 17655634, 9756271, 17892268, 17648596, 16220077, 16069901
- 11733603, 16285691, 17587063, 18180390, 17393915, 18096714, 17238511
- 17824637, 14285317, 19289642, 14764829, 18328509, 17622427, 16943711
- 17346671, 18996843, 14852021, 17783588, 16618694, 17672719, 17546761
- Rac system comprising of multiple nodes
- Local node = rac1
- Remote node = rac2
- --------------------------------------------------------------------------------
- OPatch succeeded.
- [grid@rac1 OPatch]$
4.3 节点2的DB PSU安装验证
- [root@rac2 ~]# su - oracle
- [oracle@rac2 ~]$ cd $ORACLE_HOME/OPatch
- [oracle@rac2 OPatch]$ ./opatch lsinventory
- Oracle Interim Patch Installer version 11.2.0.3.6
- Copyright (c) 2013, Oracle Corporation. All rights reserved.
- Oracle Home : /u01/app/oracle/product/11.2.0/db_1
- Central Inventory : /u01/app/oraInventory
- from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
- OPatch version : 11.2.0.3.6
- OUI version : 11.2.0.4.0
- Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-10-28_09-11-01AM_1.log
- Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-28_09-11-01AM.txt
- --------------------------------------------------------------------------------
- Installed Top-level Products (1):
- Oracle Database 11g 11.2.0.4.0
- There are 1 product(s) installed in this Oracle Home.
- Interim patches (2) :
- Patch 19121549 : applied on Mon Oct 27 22:52:28 CST 2014
- Unique Patch ID: 18065664
- Patch description: "OCW Patch Set Update : 11.2.0.4.4 (19121549)"
- Created on 6 Oct 2014, 03:26:54 hrs PST8PDT
- Bugs fixed:
- 18328800, 18691572, 14525998, 18187697, 18348155, 17516024, 17387214
- 17750548, 17617807, 17551223, 14671408, 14207615, 18272135, 18180541
- 17292250, 17378618, 17500165, 18875012, 18464784, 17065496, 18848125
- 13991403, 17955615, 14693336, 17273020, 17238586, 17089344, 17405605
- 17531342, 17155238, 17159489, 18053580, 16543190, 17039197, 16317771
- 17947785, 10052729, 16281493, 18346135, 17481314, 18199185, 18399991
- 18024089, 18428146, 18352845, 18352846, 17391726, 18414137, 17001914
- 17927970, 14378120, 16346413, 17305100, 15832129, 15986647, 16901346
- 18068871, 17985714, 18536826, 16206997, 18752378, 16876500, 16429265
- 18343490, 18336452, 16613232, 17273003, 19276791, 12928658, 18226143
- 17172091, 18229842, 18053631, 16867761, 18231837, 15869775, 17483479
- 18729166, 17405302, 15920201, 18709496
- Patch 19121551 : applied on Mon Oct 27 22:51:07 CST 2014
- Unique Patch ID: 17949166
- Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)"
- Created on 6 Oct 2014, 10:07:57 hrs PST8PDT
- Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
- 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)"
- Bugs fixed:
- 17288409, 17205719, 17811429, 17754782, 17726838, 13364795, 17311728
- 17284817, 17441661, 13645875, 18199537, 16992075, 16542886, 17446237
- 14565184, 17071721, 17610798, 17375354, 17449815, 17397545, 19463897
- 18230522, 17235750, 16360112, 13866822, 17982555, 17478514, 12905058
- 14338435, 13944971, 16929165, 12747740, 17546973, 14054676, 17088068
- 18264060, 17343514, 17016369, 17042658, 14602788, 14657740, 17332800
- 19211724, 13951456, 16315398, 17186905, 18744139, 16850630, 17437634
- 19049453, 18673304, 17883081, 18641419, 17296856, 18262334, 17006183
- 18277454, 17232014, 16855292, 10136473, 17705023, 17865671, 18554871
- 19121551, 17588480, 17551709, 17344412, 17842825, 18681862, 17390160
- 13955826, 13609098, 18139690, 17501491, 17239687, 17752121, 17299889
- 17602269, 18673325, 17313525, 17242746, 19544839, 17600719, 18191164
- 17571306, 19466309, 17951233, 18094246, 17165204, 17011832, 17040527
- 16785708, 16180763, 17477958, 17174582, 17465741, 18522509, 17323222
- 19463893, 16875449, 16524926, 17237521, 17596908, 17811438, 17811447
- 18031668, 16912439, 16494615, 18061914, 17545847, 17082359, 19554106
- 17614134, 17341326, 17891946, 19458377, 17716305, 17752995, 16392068
- 19271443, 17767676, 17614227, 17040764, 17381384, 18973907, 18673342
- 14084247, 17389192, 17006570, 17612828, 17721717, 13853126, 18203837
- 17390431, 17570240, 14245531, 16043574, 16863422, 19727057, 17468141
- 17786518, 17037130, 17267114, 18203838, 16198143, 16956380, 17478145
- 14829250, 17394950, 17027426, 16268425, 18247991, 19584068, 14458214
- 18436307, 17265217, 13498382, 16692232, 17786278, 17227277, 16042673
- 16314254, 17443671, 16228604, 16837842, 17393683, 17787259, 18009564
- 15861775, 16399083, 18018515, 16472716, 17050888, 14010183, 17325413
- 16613964, 17080436, 17036973, 17761775, 16721594, 18280813, 15979965
- 18203835, 17297939, 16731148, 17811456, 14133975, 17385178, 17586955
- 16450169, 17655634, 9756271, 17892268, 17648596, 16220077, 16069901
- 11733603, 16285691, 17587063, 18180390, 17393915, 18096714, 17238511
- 17824637, 14285317, 19289642, 14764829, 18328509, 17622427, 16943711
- 17346671, 18996843, 14852021, 17783588, 16618694, 17672719, 17546761
- --------------------------------------------------------------------------------
- OPatch succeeded.
- [oracle@rac2 OPatch]$
4.4 节点2的GRID PSU验证
- [oracle@rac2 OPatch]$ su - grid
- Password:
- [grid@rac2 ~]$ cd $GI_HOME/OPatch
- [grid@rac2 OPatch]$ ./opatch lsinventory
- Oracle Interim Patch Installer version 11.2.0.3.6
- Copyright (c) 2013, Oracle Corporation. All rights reserved.
- Oracle Home : /u01/app/11.2.0/grid
- Central Inventory : /u01/app/oraInventory
- from : /u01/app/11.2.0/grid/oraInst.loc
- OPatch version : 11.2.0.3.6
- OUI version : 11.2.0.4.0
- Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2014-10-28_09-12-26AM_1.log
- Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2014-10-28_09-12-26AM.txt
- --------------------------------------------------------------------------------
- Installed Top-level Products (1):
- Oracle Grid Infrastructure 11g 11.2.0.4.0
- There are 1 product(s) installed in this Oracle Home.
- Interim patches (1) :
- Patch 19121551 : applied on Mon Oct 27 22:56:43 CST 2014
- Unique Patch ID: 17949166
- Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)"
- Created on 6 Oct 2014, 10:07:57 hrs PST8PDT
- Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
- 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)"
- Bugs fixed:
- 17288409, 17205719, 17811429, 17754782, 17726838, 13364795, 17311728
- 17284817, 17441661, 13645875, 18199537, 16992075, 16542886, 17446237
- 14565184, 17071721, 17610798, 17375354, 17449815, 17397545, 19463897
- 18230522, 17235750, 16360112, 13866822, 17982555, 17478514, 12905058
- 14338435, 13944971, 16929165, 12747740, 17546973, 14054676, 17088068
- 18264060, 17343514, 17016369, 17042658, 14602788, 14657740, 17332800
- 19211724, 13951456, 16315398, 17186905, 18744139, 16850630, 17437634
- 19049453, 18673304, 17883081, 18641419, 17296856, 18262334, 17006183
- 18277454, 17232014, 16855292, 10136473, 17705023, 17865671, 18554871
- 19121551, 17588480, 17551709, 17344412, 17842825, 18681862, 17390160
- 13955826, 13609098, 18139690, 17501491, 17239687, 17752121, 17299889
- 17602269, 18673325, 17313525, 17242746, 19544839, 17600719, 18191164
- 17571306, 19466309, 17951233, 18094246, 17165204, 17011832, 17040527
- 16785708, 16180763, 17477958, 17174582, 17465741, 18522509, 17323222
- 19463893, 16875449, 16524926, 17237521, 17596908, 17811438, 17811447
- 18031668, 16912439, 16494615, 18061914, 17545847, 17082359, 19554106
- 17614134, 17341326, 17891946, 19458377, 17716305, 17752995, 16392068
- 19271443, 17767676, 17614227, 17040764, 17381384, 18973907, 18673342
- 14084247, 17389192, 17006570, 17612828, 17721717, 13853126, 18203837
- 17390431, 17570240, 14245531, 16043574, 16863422, 19727057, 17468141
- 17786518, 17037130, 17267114, 18203838, 16198143, 16956380, 17478145
- 14829250, 17394950, 17027426, 16268425, 18247991, 19584068, 14458214
- 18436307, 17265217, 13498382, 16692232, 17786278, 17227277, 16042673
- 16314254, 17443671, 16228604, 16837842, 17393683, 17787259, 18009564
- 15861775, 16399083, 18018515, 16472716, 17050888, 14010183, 17325413
- 16613964, 17080436, 17036973, 17761775, 16721594, 18280813, 15979965
- 18203835, 17297939, 16731148, 17811456, 14133975, 17385178, 17586955
- 16450169, 17655634, 9756271, 17892268, 17648596, 16220077, 16069901
- 11733603, 16285691, 17587063, 18180390, 17393915, 18096714, 17238511
- 17824637, 14285317, 19289642, 14764829, 18328509, 17622427, 16943711
- 17346671, 18996843, 14852021, 17783588, 16618694, 17672719, 17546761
- Rac system comprising of multiple nodes
- Local node = rac2
- Remote node = rac1
- --------------------------------------------------------------------------------
- OPatch succeeded.
- [grid@rac2 OPatch]$
4.5 数据库实例PSU验证
- col action format a15
- col comments format a30
- select action ,comments from registry$history;
- ACTION COMMENTS
- --------------- ------------------------------
- APPLY Patchset 11.2.0.2.0
- APPLY Patchset 11.2.0.2.0
- APPLY Patchset 11.2.0.2.0
- APPLY Patchset 11.2.0.2.0
- APPLY PSU 11.2.0.4.4
- APPLY PSU 11.2.0.4.4
- 1: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /backup/19380115/19121551 -oh /u01/app/oracle/product/11.2.0/db_1
- 2: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /backup/19380115/19121549/custom/server/19121549 -oh /u01/app/oracle/product/11.2.0/db_1
- 3: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /backup/19380115/19121551 -oh /u01/app/oracle/product/11.2.0/db_1
- 4: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /backup/19380115/19121549/custom/server/19121549 -oh /u01/app/oracle/product/11.2.0/db_1
- 5: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /backup/19380115/19121551 -oh /u01/app/11.2.0/grid
- 6: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /backup/19380115/19121549 -oh /u01/app/11.2.0/grid
- 7: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /backup/19380115/19121552 -oh /u01/app/11.2.0/grid
- 8: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /backup/19380115/19121551 -oh /u01/app/11.2.0/grid
- 9: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /backup/19380115/19121549 -oh /u01/app/11.2.0/grid
- 10: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /backup/19380115/19121552 -oh /u01/app/11.2.0/grid
- 11: /u01/app/oracle/product/11.2.0/db_1/bin/emctl stop dbconsole
- 12: /u01/app/oracle/product/11.2.0/db_1/bin/emctl stop agent
- 13: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /backup/19380115/19121551 -oh /u01/app/oracle/product/11.2.0/db_1
- 14: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /backup/19380115/19121549/custom/server/19121549 -oh /u01/app/oracle/product/11.2.0/db_1
- 15: /u01/app/oracle/product/11.2.0/db_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s /u01/app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n rac1
- 16: /backup/19380115/19121549/custom/server/19121549/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1
- 17: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply /backup/19380115/19121551 -local -silent -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1 -invPtrLoc /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
- 18: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply /backup/19380115/19121549/custom/server/19121549 -local -silent -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1 -invPtrLoc /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
- 19: /backup/19380115/19121549/custom/server/19121549/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1
- 20: /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock : run as root
- 21: /sbin/fuser -k /u01/app/11.2.0/grid/bin/crsctl.bin : run as root
- 22: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /backup/19380115/19121551 -oh /u01/app/11.2.0/grid
- 23: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /backup/19380115/19121549 -oh /u01/app/11.2.0/grid
- 24: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /backup/19380115/19121552 -oh /u01/app/11.2.0/grid
- 25: /u01/app/11.2.0/grid/OPatch/opatch napply /backup/19380115/19121551 -local -silent -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc
- 26: /u01/app/11.2.0/grid/OPatch/opatch napply /backup/19380115/19121549 -local -silent -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc
- 27: /u01/app/11.2.0/grid/bin/emctl start dbconsole
- 28: /u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh : run as root
- 29: /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch : run as root
- 30: /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole
- 31: /u01/app/oracle/product/11.2.0/db_1/bin/emctl start agent
- 32: /u01/app/oracle/product/11.2.0/db_1/bin/srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s /u01/app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n rac1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25462274/viewspace-2124930/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25462274/viewspace-2124930/