说明:
数据库 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
Grid Infrastructure
Also see:
-
Note:1645862.1 Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results
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信息的一致性。
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
下面是psu的日志,里面记录了psu之前自动进行的冲突检测
-
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博客 ” ,链接:https://blog.itpub.net/25462274/viewspace-2124930/
,如需转载,请注明出处,否则将追究法律责任。