Oracle 12c RAC安装PSU(12.1.0.2.161018)

9iiooi

一、准备工作1，数据库环境操作系统版本   : Redhat 6.8 x64   
数据库版本     : Oracle 12.1.0.2 x64 RAC   
Grid           : 12.1.0.2     
Oracle database: 12.1.0.2

2，准备内容GI PSU : p24412235_121020_Linux-x86-64.zip   
OPatch : p6880880_122010_Linux-x86-64.zip   
DB PSU : p24006101_121020_Linux-x86-64.zip 仅oracle12c单机使用。
OPatch下载地址：   
https://updates.oracle.com/download/6880880.html
升级过程及说明：   
(1) GI PSU包括DB PSU,CPU。   
(2) 先升级节点1 grid，再升级节点2 grid，再升级节点1 database,后升级节点2 database。

二、更新OPatch说明：分别在两个节点更新database以及grid OPatch版本。
1. 更新OPatch版本，OPatch直接压缩替换就可以了。(1) 上传p6880880_122010_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限。   
(2) root用户下将原OPatch目录改名。
mv /u01/app/12.1.0/grid/OPatch /u01/app/12.1.0/grid/OPatchbk   
mv /u01/app/oracle/product/12.1.0/db_1/OPatch /u01/app/oracle/product/12.1.0/db_1/OPatchBK
2. grid目录OPatch替换(1) root用户   
cd /u01/software/;chown grid:oinstall p6880880_122010_Linux-x86-64.zip
(2) grid用户   
cd /u01/software/; unzip p6880880_122010_Linux-x86-64.zip
(3) root用户   
cd /u01/software/ ;mv OPatch /u01/app/12.1.0/grid/
(4) grid用户测试
su - grid
/u01/app/12.1.0/grid/OPatch/opatch version
OPatch Version: 12.2.0.1.8   
OPatch succeeded.

3. oracle目录OPatch替换(1) root用户
cd /u01/software/;chown oracle:oinstall p6880880_122010_Linux-x86-64.zip
(2) oracle用户
cd /u01/software/ ; unzip p6880880_122010_Linux-x86-64.zip
(3) root用户
cd /u01/software/; mv OPatch /u01/app/oracle/product/12.1.0/db_1/
(4) oracle用户测试
su - oracle   
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatch version
OPatch Version: 12.2.0.1.8   
OPatch succeeded.

三、开始升级GI PSU说明:   
(1) 升级过程会自动关闭和启动集群。   
(2) 先升级节点1 grid，再升级节点2 grid。
1. grid用户下解决GI PSU补丁包(1) root用户操作
cd /u01/software/;chown grid:oinstall p24412235_121020_Linux-x86-64.zip
(2) grid用户操作
# su - grid   
$ cd /u01/software/;unzip p24412235_121020_Linux-x86-64.zip

2. root用户下使用-analyze命令预安装psu，测试兼容性(必须要在root用户下，否则报错)/u01/app/12.1.0/grid/OPatch/opatchauto apply  /u01/software/24412235  -oh /u01/app/12.1.0/grid  -analyze过程如下:   
----------------------------------------------------------------------   
OPatchauto session is initiated at Thu Dec  8 22:16:11 2016
System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-12-08_10-16-15PM.log.
会话日志文件是/u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2016-12-08_10-16-31PM.log   
此会话的 ID 为 DH2L
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid
Patch applicablity verified successfully on home /u01/app/12.1.0/grid

Verifying patch inventory on home /u01/app/12.1.0/grid   
Patch inventory verified successfully on home /u01/app/12.1.0/grid
OPatchAuto 成功。
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:db1   
CRS Home:/u01/app/12.1.0/grid

==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/software/24412235/21436941   
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-08_22-16-39下午_1.log
Patch: /u01/software/24412235/23854735   
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-08_22-16-39下午_1.log
Patch: /u01/software/24412235/24006101   
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-08_22-16-39下午_1.log
Patch: /u01/software/24412235/24007012   
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-08_22-16-39下午_1.log
OPatchauto session completed at Thu Dec  8 22:18:36 2016   
Time taken to complete the session 2 minutes, 26 seconds
----------------------------------------------------------------------
3. root用户下安装grid psu/u01/app/12.1.0/grid/OPatch/opatchauto apply  /u01/software/24412235  -oh /u01/app/12.1.0/grid过程如下:   
----------------------------------------------------------------------   
OPatchauto session is initiated at Tue Dec 13 11:59:50 2016
System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-12-13_11-59-56AM.log.
会话日志文件是/u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2016-12-13_12-00-19PM.log   
此会话的 ID 为 UUNB
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid   
Patch applicablity verified successfully on home /u01/app/12.1.0/grid
Verifying patch inventory on home /u01/app/12.1.0/grid   
Patch inventory verified successfully on home /u01/app/12.1.0/grid
Bringing down CRS service on home /u01/app/12.1.0/grid   
Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_db1_2016-12-13_12-03-32AM.log   
CRS service brought down successfully on home /u01/app/12.1.0/grid
Start applying binary patch on home /u01/app/12.1.0/grid   
Binary patch applied successfully on home /u01/app/12.1.0/grid

Starting CRS service on home /u01/app/12.1.0/grid   
Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_db1_2016-12-13_12-19-53AM.log   
CRS service started successfully on home /u01/app/12.1.0/grid
Verifying patches applied on home /u01/app/12.1.0/grid   
Patch verification completed with warning on home /u01/app/12.1.0/grid
OPatchAuto 成功。   
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:db1   
CRS Home:/u01/app/12.1.0/grid   
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/software/24412235/21436941   
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_12-05-29下午_1.log
Patch: /u01/software/24412235/23854735   
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_12-05-29下午_1.log
Patch: /u01/software/24412235/24006101   
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_12-05-29下午_1.log
Patch: /u01/software/24412235/24007012   
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_12-05-29下午_1.log
OPatchauto session completed at Tue Dec 13 12:31:24 2016   
Time taken to complete the session 31 minutes, 34 seconds   
----------------------------------------------------------------------

4. 两节点检查升级情况# su - grid
$ORACLE_HOME/OPatch/opatch lsinv
-----------------------------------------------   
记录略..
Patch level status of Cluster nodes :
Patching Level                  Nodes   
--------------                  -----   
2919480821                      db1,db2   
-----------------------------------------------

$ORACLE_HOME/OPatch/opatch lspatches
24007012;ACFS Patch Set Update : 12.1.0.2.161018 (24007012)   
24006101;Database Patch Set Update : 12.1.0.2.161018 (24006101)   
23854735;OCW Patch Set Update : 12.1.0.2.161018 (23854735)   
21436941;WLM Patch Set Update: 12.1.0.2.5 (21436941)
OPatch succeeded.   

四、开始升级database说明:   
(1) 升级过程会自动关闭和启动集群。   
(2) 先升级节点1 database，再升级节点2 database。
1. root用户操作用户升级GI PSU补丁包cd /u01/software/;chown -R oracle:oinstall 24412235
2. root用户下使用-analyze命令预安装psu，测试兼容性/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply  /u01/software/24412235  -oh /u01/app/oracle/product/12.1.0/db_1 -analyze过程如下:   
----------------------------------------------------------------------   
OPatchauto session is initiated at Tue Dec 13 14:38:33 2016
System initialization log file is /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchautodb/systemconfig2016-12-13_02-38-40PM.log.
会话日志文件是/u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/opatchauto2016-12-13_02-39-17PM.log   
此会话的 ID 为 ZHB2
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/db_1   
Patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying patch inventory on home /u01/app/oracle/product/12.1.0/db_1   
Patch inventory verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying SQL patch applicablity on home /u01/app/oracle/product/12.1.0/db_1   
SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0/db_1
OPatchAuto 成功。
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:db1   
RAC Home:/u01/app/oracle/product/12.1.0/db_1
==Following patches were SKIPPED:
Patch: /u01/software/24412235/21436941   
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/software/24412235/24007012   
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/software/24412235/23854735   
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_14-39-32下午_1.log
Patch: /u01/software/24412235/24006101   
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_14-39-32下午_1.log
OPatchauto session completed at Tue Dec 13 14:41:16 2016   
Time taken to complete the session 2 minutes, 44 seconds   
----------------------------------------------------------------------

3. root用户下安装 database psu/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply  /u01/software/24412235  -oh /u01/app/oracle/product/12.1.0/db_1过程如下:   
----------------------------------------------------------------------   
OPatchauto session is initiated at Tue Dec 13 14:47:31 2016
System initialization log file is /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchautodb/systemconfig2016-12-13_02-47-36PM.log.
会话日志文件是/u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/opatchauto2016-12-13_02-47-57PM.log   
此会话的 ID 为 VR4U
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/db_1   
Patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying patch inventory on home /u01/app/oracle/product/12.1.0/db_1   
Patch inventory verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying SQL patch applicablity on home /u01/app/oracle/product/12.1.0/db_1   
SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0/db_1
Preparing to bring down database service on home /u01/app/oracle/product/12.1.0/db_1   
Successfully prepared home /u01/app/oracle/product/12.1.0/db_1 to bring down database service
Bringing down database service on home /u01/app/oracle/product/12.1.0/db_1   
Following database(s) and/or service(s) are stopped and will be restarted later during the session: orcl   
Database service successfully brought down on home /u01/app/oracle/product/12.1.0/db_1
Performing prepatch operation on home /u01/app/oracle/product/12.1.0/db_1   
Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/db_1
Start applying binary patch on home /u01/app/oracle/product/12.1.0/db_1   
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0/db_1
Performing postpatch operation on home /u01/app/oracle/product/12.1.0/db_1   
Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/db_1
Starting database service on home /u01/app/oracle/product/12.1.0/db_1   
Database service successfully started on home /u01/app/oracle/product/12.1.0/db_1
Preparing home /u01/app/oracle/product/12.1.0/db_1 after database service restarted   
No step execution required.........   
Prepared home /u01/app/oracle/product/12.1.0/db_1 successfully after database service restarted
Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0/db_1   
SQL patch applied successfully on home /u01/app/oracle/product/12.1.0/db_1
Verifying patches applied on home /u01/app/oracle/product/12.1.0/db_1   
Patch verification completed with warning on home /u01/app/oracle/product/12.1.0/db_1
OPatchAuto 成功。   
--------------------------------Summary--------------------------------   
Patching is completed successfully. Please find the summary as follows:
Host:db1   
RAC Home:/u01/app/oracle/product/12.1.0/db_1   
Summary:
==Following patches were SKIPPED:
Patch: /u01/software/24412235/21436941   
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/software/24412235/24007012   
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/software/24412235/23854735   
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_14-50-30下午_1.log
Patch: /u01/software/24412235/24006101   
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-12-13_14-50-30下午_1.log
OPatchauto session completed at Tue Dec 13 15:00:23 2016   
Time taken to complete the session 12 minutes, 53 seconds   
----------------------------------------------------------------------

4. 两节点检查升级情况# su - oracle
$ORACLE_HOME/OPatch/opatch lsinv
-----------------------------------------------   
Oracle Interim Patch Installer version 12.2.0.1.8   
Copyright (c) 2016, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/12.1.0/db_1   
Central Inventory : /u01/app/oraInventory   
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc   
OPatch version    : 12.2.0.1.8   
OUI version       : 12.1.0.2.0   
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-12-13_15-05-33PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-13_15-05-33PM.txt
--------------------------------------------------------------------------------   
Local Machine Information::   
Hostname: db1   
ARU platform id: 226   
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.2.0   
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch  24006101     : applied on Tue Dec 13 14:54:11 CST 2016   
Unique Patch ID:  20683584   
Patch description:  "Database Patch Set Update : 12.1.0.2.161018 (24006101)"   
   Created on 1 Oct 2016, 12:33:50 hrs PST8PDT   
Sub-patch  23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"   
Sub-patch  22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"   
Sub-patch  21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"   
Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"   
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"   
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"   
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"   
   Bugs fixed:   
     21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345   
     19791273, 19243521, 20951038, 19908836, 21281532, 19238590, 24577566   
     21184223, 19134173, 20387265, 19149990, 21263635, 18886413, 17551063   
     22160989, 22507210, 19703301, 19366375, 19001390, 18202441, 20267166   
     19358317, 19706965, 18549238, 19068970, 18797519, 22148226, 20825533   
     19649152, 19670108, 18940497, 18948177, 18964978, 19035573, 19176326   
     20413820, 19176223, 20904530, 20134339, 19074147, 20868862, 18411216   
     21322887, 22507234, 20425790, 18966843, 21329301, 19333670, 19468991   
     20124446, 19883092, 19658708, 19591608, 19402853, 20618595, 21787056   
     22380919, 21266085, 17835294, 19721304, 19791377, 19068610, 22178855   
     22173980, 20746251, 20048359, 20898391, 19185876, 20281121, 20907061   
     6599380, 19577410, 22092979, 20603378, 19001359, 19490948, 21387964   
     20832516, 17532734, 19309466, 19081128, 20627866, 20844426, 21188532   
     18791688, 21442094, 20890311, 20596234, 18973548, 21296029, 19303936   
     19461270, 21479753, 20936905, 20235511, 21220620, 18964939, 19430401   
     22296366, 21153266, 19409212, 22657942, 20657441, 19879746, 19684504   
     20528052, 19024808, 20977794, 18799993, 20466322, 18740837, 19662635   
     20228093, 19065556, 20212067, 19524384, 17722075, 20446883, 18952989   
     16870214, 19928926, 19835133, 21629064, 20466628, 24386767, 19931709   
     19730508, 18819908, 23124895, 19188927, 20074391, 20356733, 14643995   
     19547370, 19065677, 21960504, 21225209, 20397490, 18967382, 19174430   
     21241829, 19536415, 19171086, 22465352, 22168163, 19335438, 20447445   
     18856999, 20471920, 19869255, 21620471, 18990693, 17890099, 18990023   
     20101006, 21300341, 20848335, 21744290, 20897759, 21668627, 19304354   
     19052488, 20794034, 23260854, 18681056, 20952966, 19896336, 18618122   
     20328248, 20440930, 18456643, 19699191, 19201867, 22865673, 18743542   
     20798891, 20347562, 22551446, 19777862, 19687159, 21373076, 19174942   
     20424899, 21899588, 18899974, 20598042, 19032777, 19058490, 22815955   
     19399918, 19434529, 21273804, 19018447, 22757364, 18851894, 19284031   
     19022470, 18043064, 20173897, 22062026, 20475845, 17274537, 19440586   
     16887946, 22374754, 17319928, 20708701, 17655240, 16439813, 19805359   
     19155797, 20859910, 19393542, 22024071, 17210525, 21847223, 19189525   
     21649497, 19075256, 22762046, 22075064, 19280225, 18845653, 20560611   
     19248799, 21756699, 18988834, 20245930, 18921743, 18799063, 20373598   
     20476175, 19571367, 20925795, 19018206, 20509482, 20711718, 20588502   
     18849537, 19183343, 21917884, 19189317, 19644859, 19390567, 19279273   
     20669434, 16863642, 22528741, 19619732, 18607546, 20348653, 19315691   
     19676905, 20165574, 17867700, 20558005, 20734332, 19532017, 20922010   
     19450314, 22353346, 20361671, 20009833, 22366558, 20294666, 18191823   
     19307662, 19371175, 19195895, 20043616, 19154375, 18914624, 20139391   
     21291274, 19174521, 19520602, 19382851, 21875360, 19676012, 19326908   
     20217801, 20093776, 21097043, 21246723, 21665897, 19143550, 20428621   
     19627012, 14283239, 19518079, 18610915, 18674024, 18306996, 19524158   
     19915271, 20122715, 20284155, 20017509, 19363645, 19597439, 21239530   
     19888853, 20880215, 21756677, 19534363, 19354335, 19044962, 19639483   
     22353199, 22243719, 22916353, 20378086, 21756661, 21260431, 22923409   
     20877664, 19028800, 20879889, 19723336, 19077215, 21421886, 19604659   
     19308965, 19048007, 18288842, 19689979, 21526048, 19180770, 19197175   
     19902195, 20318889, 19013183, 19012119, 20464614, 19067244, 21632821   
     19512341, 19841800, 20331945, 19587324, 24316947, 19578350, 19637186   
     18674047, 19054077, 20898997, 19708632, 21091431, 19289642, 20869721   
     19258504, 17365043, 19468347, 21373473, 16359751, 19439759, 19769480   
     19272708, 19978542, 20402832, 19329654, 19873610, 23229229, 21517440   
     13542050, 19291380, 21915719, 19076343, 19561643, 19990037, 19487147   
     18909599, 20831538, 18250893, 19016730, 16619249, 18354830, 21188584   
     19989009, 17414008, 20688221, 20704450, 20441797, 19157754, 18885870   
     21785691, 21450666, 18893947, 18705806, 22223463, 16923858, 18417036   
     20919320, 20474192, 22046677, 19385656, 19501299, 20920911, 20899461   
     21387128, 21315084, 18122373, 20581111, 19606174, 18436647, 19023822   
     19178851, 19124589, 19597583, 18499088, 19050649
Patch  23854735     : applied on Tue Dec 13 14:51:03 CST 2016   
Unique Patch ID:  20511532   
Patch description:  "OCW Patch Set Update : 12.1.0.2.161018 (23854735)"   
   Created on 29 Sep 2016, 23:50:00 hrs PST8PDT   
   Bugs fixed:   
     21339083, 18589889, 20768643, 19061429, 19133945, 19341538, 19521169   
     20011424, 19361757, 19187207, 19302350, 19130141, 19530755, 19699720   
     19620918, 19168690, 18899171, 19244316, 19653795, 18634372, 19471722   
     19536337, 19184188, 19131709, 20160490, 20995001, 21131037, 19380733   
     20985167, 18943696, 20552947, 19591984, 18135723, 18461246, 20014326   
     19524857, 18890943, 19154753, 19499021, 19046190, 20923930, 20028666   
     19051385, 19050688, 19682695, 19831611, 21607972, 18922918, 21087799   
     18956780, 19683886, 23757020, 19026993, 20110156, 21269977, 18261648   
     18362971, 19558324, 22651583, 20185476, 18882642, 19478119, 19414274   
     17447588, 19262534, 20752167, 19147513, 22475834, 21242118, 19514085   
     20758997, 19659885, 19319904, 18703978, 23079844, 19700256, 19703246   
     20467806, 19192901, 21527118, 19479503, 19147751, 18901356, 21232394   
     18964974, 22162062, 18835366, 19013789, 19207286, 18950232, 22583325   
     19148791, 19556820, 16505171, 22261732, 22135419, 19449737, 21878613   
     21646169, 19187515, 19230771, 20795241, 19453778, 19853036, 18843572   
     18520351, 21430567, 19185148, 19232454, 21220597, 18541110, 18834955   
     19204743, 20175174, 19140891, 18747335, 20676340, 19270660, 19325701   
     20877003, 19222693, 19662663, 19684131, 19010177, 19272663, 18910576   
     18907170, 19426384, 9372680, 20737462, 19700294, 20289828, 19331454   
     22568500, 20278216, 20827053, 20119857, 19703199, 22456393, 20588164   
     18955644, 20991879, 18508710, 19908346, 19589221, 18952857, 19537762   
     21152052, 16286734, 20669114, 18762843, 18945249, 19184799, 19205086   
     19351363, 20091753, 19031737, 19079087, 19148367, 18968981, 19150517   
     20231741, 19217019, 18730096, 18975620, 19067804, 21259359, 19054979   
     19209951, 19318983, 18747382, 19154673, 18752378, 22905714, 19150088   
     19013444, 19234177, 18999857, 19075747, 19367276, 19612597, 19874047   
     19677813, 23049292, 19427050, 18910443, 20033787, 19148982, 19777496   
     20730170, 18523468, 19277814, 20562133, 19071526, 21420753, 18850051   
     20433932, 20061168, 19370739, 20822591, 19609388, 18776786, 20136892   
     18989446, 19148793, 19585454, 18317489, 19955755, 19059053, 19807548   
     19124972, 22229116, 18910748, 19147509, 18849896, 19617592, 19398098   
     22840085, 19076165, 19498411, 19704993, 21294273, 19459023, 20634511   
     21229744, 21474380, 21484367, 20276459, 17208793, 19234907, 19538714   
     22867050, 19383028, 19513969, 22195657, 23111368, 19986391, 19314048   
     18834934, 19473851, 19458082, 18894342, 19522067, 18116578, 19241857   
     19076778, 19066699, 19068003, 18937186, 20267877, 19916737, 19770543   
     22863466, 19635215, 19613533, 21057239, 20783416, 19315522, 19141785   
     19163887, 19885321, 18715868, 18852058, 19701617, 19280860, 19139608   
     21453435, 18946768, 19135521, 18604143, 19627476, 20568884, 20317221   
     20177779, 19266658, 24522717, 18330979, 19027351, 21227730, 18707416   
     21118157, 21113068, 19925992, 20235486, 20006646, 15922206, 18439295   
     18991776, 21245437, 23170839, 19163425, 19550195, 18849021, 18861196   
     17940721, 18524834, 19287706, 19522313, 18835283, 18748932, 19184765   
     21639478, 14851828, 20598625, 19226141, 19053891, 18871287, 18998228   
     18980002, 19682778, 19325604, 18777835, 17338864, 18945906, 19513650   
     19702758, 18952577, 19473088, 19178517, 18729269, 19529729, 19455563   
     20877072, 23275930, 20340620, 18536826, 19292605, 22264951, 20920711   
     20660273, 20011635, 17592037, 18935857, 22989069, 19029647, 19179158   
     22302421, 23076471, 19140712, 20012766, 23049301, 19184276, 20510208   
     20001507, 20079414, 19680763, 19259765, 18962892, 19513888, 14661880   
     21519340, 21222147, 20218012, 19551830, 21616278, 19068333, 18945435   
     20775015, 19319192, 20839581, 19178629, 21694237, 19304104, 19284357   
     22594310, 20725084, 19457575, 21297657, 19069755, 19021575, 18715884   
     19584688, 18798573, 19812592, 19018001, 19292272, 19270956, 21967791   
     21794779, 23055224, 18700893, 21276514, 20467377, 18406774, 20607821   
     21976167, 21082737, 21694632, 20115586, 20883009, 19164099, 18283792   
     19155350, 19884033, 19146822, 18798432, 21123424, 19471836, 20936562   
     18750781, 19045143, 22483804, 19146980, 19601003, 20099624, 21378016   
     19537547, 19281106, 18862203, 19954372, 18235274, 19205617, 19513351   
     20219458, 19150313, 18843054, 18708349, 19332386, 18953639, 21423055   
     19371270, 19203996, 20038431, 19370846, 21053036, 18998379, 20157569   
     21357522, 19273577, 24709351, 22113170, 19632437, 18990354, 19288396   
     20620581, 19557558, 19127078, 21792881, 20900588, 20053557, 22088198   
     22664609, 19315567, 19444471, 19154933, 20953798, 18290252, 18813323   
     19915945, 19500293, 18643483, 19134098, 23034352, 18965694, 19226858   
     19591356, 19602208, 22884308, 20069197, 18417590, 18920408, 18636884   
     22289350, 19043795, 20746507, 18260170, 18919682, 18678829, 19319357   
     19273758, 18953878, 18999195, 18759724, 19066844, 13843841, 20290467   
     22934855, 19649640, 19062675, 21924910, 18859710, 20862812, 19504641   
     23101611, 19341481, 20293730, 19343245, 18304090, 19241655, 19470791   
     18242738, 20649573, 18372060, 18953889, 18827679, 19140711, 19023430   
     19259290, 19045388, 20186278, 19522571, 19709663, 18875012, 18861564   
     19273760, 19225265, 15885689, 20853464, 21696068, 18819158, 21394146   
     19049721, 19368917, 21255373, 22393909, 20408163, 20579351, 18868829   
     20350915, 21327402, 22024217, 23101338, 19820247, 20363708, 19538241   
     19804032
Rac system comprising of multiple nodes   
  Local node = db1   
  Remote node = db2
--------------------------------------------------------------------------------   
OPatch succeeded.   
-----------------------------------------------

$ORACLE_HOME/OPatch/opatch lspatches
24006101;Database Patch Set Update : 12.1.0.2.161018 (24006101)   
23854735;OCW Patch Set Update : 12.1.0.2.161018 (23854735)
OPatch succeeded.   

五、注册PSU信息到数据库
1. 注册PSU到数据库[iyunv@db1 ~]# su - oracle   
[oracle@db1 ~]$ cd /u01/app/oracle/product/12.1.0/db_1/OPatch   
[oracle@db1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Tue Dec 13 15:37:19 2016   
Copyright (c) 2016, Oracle.  All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17776_2016_12_13_15_37_19/sqlpatch_invocation.log
Connecting to database...OK   
Bootstrapping registry and package to current versions...done   
Determining current state...done
Current state of SQL patches:   
Bundle series PSU:   
  ID 161018 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks...   
Installation queue:   
  Nothing to roll back   
  The following patches will be applied:   
    24006101 (Database Patch Set Update : 12.1.0.2.161018 (24006101))
Installing patches...   
Patch installation complete.  Total patches installed: 1
Validating logfiles...   
Patch 24006101 apply: SUCCESS   
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24006101/20683584/24006101_apply_HIGOV_2016Dec13_15_37_36.log (no errors)   
SQL Patching tool complete on Fri Dec  13 15:37:04 2016

2. 查看数据库补丁记录oracle12c(12.1.0.2起采用dba_registry_sqlpatch如下方式查看数据库补丁记录)
SQL> set linesize 300   
SQL> col DESCRIPTION for a30   
SQL> col ACTION_TIME for a30   
SQL> select PATCH_ID, PATCH_UID,VERSION,ACTION, STATUS,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch;
  PATCH_ID  PATCH_UID VERSION              ACTION          STATUS          ACTION_TIME                    DESCRIPTION   
---------- ---------- -------------------- --------------- --------------- ------------------------------ ------------------------------   
  24006101   20683584 12.1.0.2             APPLY           SUCCESS         13-DEC-16 03.25.58.300240 PM   Database Patch Set Update : 12.1.0.2.161018 (24006101)   
SQL>