安装PSU 基于Linux x86_64的11g RAC 11.2.0.4.0 PSU到11.2.0.4.4
来源:互联网 发布:windows 重启tomcat 编辑:程序博客网 时间:2024/05/09 19:36
说明:
数据库 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
DocumentDescriptionRolling RACPatch DownloadNote:19791364.8Combo of 11.2.0.4.1 OJVM PSU and 11.2.0.4.4 DB PSU (Oct 2014)NoPatch:19791364Note:19282021.8Oracle JavaVM Component 11.2.0.4.1 Database PSU (Oct 2014) (OJVM PSU)NoPatch:19282021Note:19121551.811.2.0.4.4 (Oct 2014) Database Patch Set Update (DB PSU)YesPatch:19121551
Grid Infrastructure
DocumentDescriptionRolling RACPatch DownloadNote:19791420.8Combo of 11.2.0.4.1 OJVM PSU and 11.2.0.4.4 GI PSU (Oct 2014)NoPatch:19791420Note:19380115.811.2.0.4.4 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU)YesPatch:19380115Also see:
- 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 versionOPatch Version: 11.2.0.3.6OPatch 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/emocmrspOCM Installation Response Generator 10.3.4.0.0 - ProductionCopyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved.Provide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. Easier for you if you use your MyOracle 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]: YThe OCM configuration response file (ocm.rsp) was successfully created.[grid@rac2 bin]$ lsemocmrsp ocm.rsp
或者你可以指定生成文件的目录及文件名,只要方便你下面使用就可以
[oracle@rac1 ocm]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /backup/file.rspProvide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. Easier for you if you use your MyOracle 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]: YThe OCM configuration response file (/backup/file.rsp) was successfully created.[oracle@rac1 ocm]$ [oracle@rac1 ocm]$ cd /backup/[oracle@rac1 backup]$ ls19380115 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_HOMEOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2012, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.locOPatch version : 11.2.0.3.6OUI version : 11.2.0.4.0Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-10-27_18-05-04PM_1.logLsinventory 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.0There are 1 products installed in this Oracle Home.Installed Products (136): Agent Required Support Files 10.2.0.4.5Assistant Common Files 11.2.0.4.0Bali Share 1.1.18.0.0Buildtools Common Files 11.2.0.4.0Character Set Migration Utility 11.2.0.4.0Cluster Verification Utility Common Files 11.2.0.4.0Database Configuration and Upgrade Assistants 11.2.0.4.0Database SQL Scripts 11.2.0.4.0Database Workspace Manager 11.2.0.4.0Deinstallation Tool 11.2.0.4.0Enterprise Edition Options 11.2.0.4.0Enterprise Manager Agent 10.2.0.4.5Enterprise Manager Agent Core Files 10.2.0.4.5Enterprise Manager Common Core Files 10.2.0.4.5Enterprise Manager Common Files 10.2.0.4.5Enterprise Manager Database Plugin -- Agent Support 11.2.0.4.0Enterprise Manager Database Plugin -- Repository Support 11.2.0.4.0Enterprise Manager Grid Control Core Files 10.2.0.4.5Enterprise Manager plugin Common Files 11.2.0.4.0Enterprise Manager Repository Core Files 10.2.0.4.5Exadata Storage Server 11.2.0.1.0Expat libraries 2.0.1.0.1Generic Connectivity Common Files 11.2.0.4.0HAS Common Files 11.2.0.4.0HAS Files for DB 11.2.0.4.0Installation Common Files 11.2.0.4.0Installation Plugin Files 11.2.0.4.0Installer SDK Component 11.2.0.4.0JAccelerator (COMPANION) 11.2.0.4.0Java Development Kit 1.5.0.51.10LDAP Required Support Files 11.2.0.4.0OLAP SQL Scripts 11.2.0.4.0Oracle 11g Warehouse Builder Required Files 11.2.0.4.0Oracle Advanced Security 11.2.0.4.0Oracle Application Express 11.2.0.4.0Oracle Call Interface (OCI) 11.2.0.4.0Oracle Clusterware RDBMS Files 11.2.0.4.0Oracle Code Editor 1.2.1.0.0IOracle Configuration Manager 10.3.8.1.0Oracle Configuration Manager Client 10.3.2.1.0Oracle Configuration Manager Deconfiguration 10.3.1.0.0Oracle Containers for Java 11.2.0.4.0Oracle Core Required Support Files 11.2.0.4.0Oracle Data Mining RDBMS Files 11.2.0.4.0Oracle Database 11g 11.2.0.4.0Oracle Database 11g 11.2.0.4.0Oracle Database 11g Multimedia Files 11.2.0.4.0Oracle Database Deconfiguration 11.2.0.4.0Oracle Database Gateway for ODBC 11.2.0.4.0Oracle Database User Interface 2.2.13.0.0Oracle Database Utilities 11.2.0.4.0Oracle Database Vault J2EE Application 11.2.0.4.0Oracle Database Vault option 11.2.0.4.0Oracle DBCA Deconfiguration 11.2.0.4.0Oracle Display Fonts 9.0.2.0.0Oracle Enterprise Manager Console DB 11.2.0.4.0Oracle Extended Windowing Toolkit 3.4.47.0.0Oracle Globalization Support 11.2.0.4.0Oracle Globalization Support 11.2.0.4.0Oracle Help For Java 4.2.9.0.0Oracle Help for the Web 2.0.14.0.0Oracle Ice Browser 5.2.3.6.0Oracle Internet Directory Client 11.2.0.4.0Oracle Java Client 11.2.0.4.0Oracle JDBC Server Support Package 11.2.0.4.0Oracle JDBC/OCI Instant Client 11.2.0.4.0Oracle JDBC/THIN Interfaces 11.2.0.4.0Oracle JFC Extended Windowing Toolkit 4.2.36.0.0Oracle JVM 11.2.0.4.0Oracle Label Security 11.2.0.4.0Oracle LDAP administration 11.2.0.4.0Oracle Locale Builder 11.2.0.4.0Oracle Message Gateway Common Files 11.2.0.4.0Oracle Multimedia 11.2.0.4.0Oracle Multimedia Annotator 11.2.0.4.0Oracle Multimedia Client Option 11.2.0.4.0Oracle Multimedia Java Advanced Imaging 11.2.0.4.0Oracle Multimedia Locator 11.2.0.4.0Oracle Multimedia Locator RDBMS Files 11.2.0.4.0Oracle Net 11.2.0.4.0Oracle Net Listener 11.2.0.4.0Oracle Net Required Support Files 11.2.0.4.0Oracle Net Services 11.2.0.4.0Oracle Netca Client 11.2.0.4.0Oracle Notification Service 11.2.0.3.0Oracle Notification Service (eONS) 11.2.0.4.0Oracle ODBC Driver 11.2.0.4.0Oracle ODBC Driverfor Instant Client 11.2.0.4.0Oracle OLAP 11.2.0.4.0Oracle OLAP API 11.2.0.4.0Oracle OLAP RDBMS Files 11.2.0.4.0Oracle One-Off Patch Installer 11.2.0.3.4Oracle Partitioning 11.2.0.4.0Oracle Programmer 11.2.0.4.0Oracle Quality of Service Management (Client) 11.2.0.4.0Oracle RAC Deconfiguration 11.2.0.4.0Oracle RAC Required Support Files-HAS 11.2.0.4.0Oracle Real Application Testing 11.2.0.4.0Oracle Recovery Manager 11.2.0.4.0Oracle Security Developer Tools 11.2.0.4.0Oracle Spatial 11.2.0.4.0Oracle SQL Developer 11.2.0.4.0Oracle Starter Database 11.2.0.4.0Oracle Text 11.2.0.4.0Oracle Text Required Support Files 11.2.0.4.0Oracle UIX 2.2.24.6.0Oracle Universal Connection Pool 11.2.0.4.0Oracle Universal Installer 11.2.0.4.0Oracle USM Deconfiguration 11.2.0.4.0Oracle Wallet Manager 11.2.0.4.0Oracle XML Development Kit 11.2.0.4.0Oracle XML Query 11.2.0.4.0Parser Generator Required Support Files 11.2.0.4.0Perl Interpreter 5.10.0.0.2Perl Modules 5.10.0.0.1PL/SQL 11.2.0.4.0PL/SQL Embedded Gateway 11.2.0.4.0Platform Required Support Files 11.2.0.4.0Precompiler Common Files 11.2.0.4.0Precompiler Required Support Files 11.2.0.4.0Provisioning Advisor Framework 10.2.0.4.3RDBMS Required Support Files 11.2.0.4.0RDBMS Required Support Files for Instant Client 11.2.0.4.0RDBMS Required Support Files Runtime 11.2.0.4.0regexp 2.1.9.0.0Required Support Files 11.2.0.4.0Sample Schema Data 11.2.0.4.0Secure Socket Layer 11.2.0.4.0SQL*Plus 11.2.0.4.0SQL*Plus Files for Instant Client 11.2.0.4.0SQL*Plus Required Support Files 11.2.0.4.0SQLJ Runtime 11.2.0.4.0SSL Required Support Files for InstantClient 11.2.0.4.0XDK Required Support Files 11.2.0.4.0XML Parser for Java 11.2.0.4.0XML Parser for Oracle JVM 11.2.0.4.0There 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.$ lsUnzip 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/19380115Oracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.PREREQ sessionOracle Home : /u01/app/11.2.0/gridCentral Inventory : /u01/app/oraInventory from : /u01/app/11.2.0/grid/oraInst.locOPatch version : 11.2.0.3.6OUI version : 11.2.0.4.0Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2014-10-27_21-29-02PM_1.logInvoking 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_paramsThis is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-10-27_22-36-23.logThis 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.log2014-10-27 22:36:23: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsStopping RAC /u01/app/oracle/product/11.2.0/db_1 ...Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfullypatch /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 successfullypatch /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/gridStarting CRS...Installing Trace File AnalyzerCRS-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 successfullyopatch 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_paramsThis is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-10-27_22-48-16.logThis 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.log2014-10-27 22:48:16: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsStopping RAC /u01/app/oracle/product/11.2.0/db_1 ...Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfullypatch /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 successfullypatch /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/gridStarting CRS...Installing Trace File AnalyzerCRS-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 successfullyopatch auto succeeded.
3 Loading Modified SQL Files into the Database 在数据库中应用PSU
在每个数据库实例上运行:
[root@rac1 ~]# su - oracle[oracle@rac1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 27 22:15:33 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSQL> @?/rdbms/admin/catbundle.sql psu apply
4 验证
4.1 节点1的DB PSU安装验证
[oracle@rac1 19380115]$ cd $ORACLE_HOME/OPatch[oracle@rac1 OPatch]$ ./opatch lsinventoryOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.locOPatch version : 11.2.0.3.6OUI version : 11.2.0.4.0Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-10-28_09-04-45AM_1.logLsinventory 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.0There are 1 product(s) installed in this Oracle Home.Interim patches (2) :Patch 19121549 : applied on Mon Oct 27 22:39:54 CST 2014Unique Patch ID: 18065664Patch 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, 18709496Patch 19121551 : applied on Mon Oct 27 22:38:36 CST 2014Unique Patch ID: 17949166Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)" Created on 6 Oct 2014, 10:07:57 hrs PST8PDTSub-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, 17546761Rac 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 - gridPassword: [grid@rac1 ~]$ cd $GI_HOME/OPatch[grid@rac1 OPatch]$ ./opatch lsinventoryOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/11.2.0/gridCentral Inventory : /u01/app/oraInventory from : /u01/app/11.2.0/grid/oraInst.locOPatch version : 11.2.0.3.6OUI version : 11.2.0.4.0Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2014-10-28_09-08-45AM_1.logLsinventory 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.0There are 1 product(s) installed in this Oracle Home.Interim patches (1) :Patch 19121551 : applied on Mon Oct 27 22:43:28 CST 2014Unique Patch ID: 17949166Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)" Created on 6 Oct 2014, 10:07:57 hrs PST8PDTSub-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, 17546761Rac 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 lsinventoryOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.locOPatch version : 11.2.0.3.6OUI version : 11.2.0.4.0Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-10-28_09-11-01AM_1.logLsinventory 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.0There are 1 product(s) installed in this Oracle Home.Interim patches (2) :Patch 19121549 : applied on Mon Oct 27 22:52:28 CST 2014Unique Patch ID: 18065664Patch 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, 18709496Patch 19121551 : applied on Mon Oct 27 22:51:07 CST 2014Unique Patch ID: 17949166Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)" Created on 6 Oct 2014, 10:07:57 hrs PST8PDTSub-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 - gridPassword: [grid@rac2 ~]$ cd $GI_HOME/OPatch[grid@rac2 OPatch]$ ./opatch lsinventoryOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/11.2.0/gridCentral Inventory : /u01/app/oraInventory from : /u01/app/11.2.0/grid/oraInst.locOPatch version : 11.2.0.3.6OUI version : 11.2.0.4.0Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2014-10-28_09-12-26AM_1.logLsinventory 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.0There are 1 product(s) installed in this Oracle Home.Interim patches (1) :Patch 19121551 : applied on Mon Oct 27 22:56:43 CST 2014Unique Patch ID: 17949166Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)" Created on 6 Oct 2014, 10:07:57 hrs PST8PDTSub-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, 17546761Rac system comprising of multiple nodes Local node = rac2 Remote node = rac1--------------------------------------------------------------------------------OPatch succeeded.[grid@rac2 OPatch]$
4.5 数据库实例PSU验证
col action format a15col comments format a30select action ,comments from registry$history;ACTION COMMENTS--------------- ------------------------------APPLY Patchset 11.2.0.2.0APPLY Patchset 11.2.0.2.0APPLY Patchset 11.2.0.2.0APPLY Patchset 11.2.0.2.0APPLY PSU 11.2.0.4.4APPLY 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_12: /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_13: /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_14: /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_15: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /backup/19380115/19121551 -oh /u01/app/11.2.0/grid6: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /backup/19380115/19121549 -oh /u01/app/11.2.0/grid7: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /backup/19380115/19121552 -oh /u01/app/11.2.0/grid8: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /backup/19380115/19121551 -oh /u01/app/11.2.0/grid9: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /backup/19380115/19121549 -oh /u01/app/11.2.0/grid10: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /backup/19380115/19121552 -oh /u01/app/11.2.0/grid11: /u01/app/oracle/product/11.2.0/db_1/bin/emctl stop dbconsole12: /u01/app/oracle/product/11.2.0/db_1/bin/emctl stop agent13: /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_114: /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_115: /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 rac116: /backup/19380115/19121549/custom/server/19121549/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_117: /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.loc18: /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.loc19: /backup/19380115/19121549/custom/server/19121549/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_120: /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock : run as root21: /sbin/fuser -k /u01/app/11.2.0/grid/bin/crsctl.bin : run as root22: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /backup/19380115/19121551 -oh /u01/app/11.2.0/grid23: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /backup/19380115/19121549 -oh /u01/app/11.2.0/grid24: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /backup/19380115/19121552 -oh /u01/app/11.2.0/grid25: /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.loc26: /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.loc27: /u01/app/11.2.0/grid/bin/emctl start dbconsole28: /u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh : run as root29: /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch : run as root30: /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole31: /u01/app/oracle/product/11.2.0/db_1/bin/emctl start agent32: /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
0 0
- 安装PSU 基于Linux x86_64的11g RAC 11.2.0.4.0 PSU到11.2.0.4.4
- 安装PSU 11g RAC 11.2.0.3.0 到11.2.0.3.1
- PSU-11g RAC 11.2.0.3.0 升级到11.2.0.3.1
- PSU 安装11g RAC 11.2.0.3.0 to 11.2.0.3.1
- Oracle RAC 11.2.0.4打PSU
- 11g R2 RAC打最新11.2.0.4.8 PSU补丁记录
- 11.2 rac psu 补丁
- 如何如何打PSU补丁(11g RAC 升级11.2.0.2.1到最新的PSU11.2.0.2.4)
- 11.2.0.4 RAC加载PSU及JVM补丁
- 11.2.0.4双节点RAC打PSU 170814 步骤
- 基于11GR2的PSU补丁安装
- Oracle 11.2.0.4.3 PSU For 11.2.0.4 RAC LINUX X86-64 installation
- 安装PSU 11.2
- Linux平台安装Oracle 11.2.0.4.4 GI PSU补丁程序
- Oracle_RAC数据库GI的PSU升级(11.2.0.4.0到11.2.0.4.8)
- 11g r2 rac 11.2.0.2升级11.2.0.2.3 [PSU patch 12419353]
- 安装11.2.0.3最新的PSU补丁
- 11.2.0.3.0单机PSU到11.2.0.3.11
- hdu 1491(Octorber 21st)(模拟水题)
- 总结_1027
- 人间佳句
- Mac OX其实已经默认装好了vim了。不需要再安装Macvim
- UVA 11423 - Cache Simulator (树状数组)
- 安装PSU 基于Linux x86_64的11g RAC 11.2.0.4.0 PSU到11.2.0.4.4
- JAVA 工程中相对路径的写法
- 解决方法: LINK : fatal error LNK1123: 转换到 COFF 期间失败
- 2014第一篇
- armv6, armv7, armv7s和i386
- eclipse配置GitHub
- 设计模式六大原则(5):迪米特法则
- 面向对象--封装
- 交易对方同意甲方的太阳镜