Oracle 12c RAC安装PSU(12.1.0.2.161018)-白红宇

一、准备工作

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下载地址：

升级过程及说明：

(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

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到数据库

[root@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

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>

本文转自 koumm 51CTO博客，原文链接：http://blog.51cto.com/koumm/1882307，如需转载请自行联系原作者