Oracle 12c RAC如何安裝PSU

這篇文章給大家分享的是有關Oracle 12c RAC如何安裝PSU的內容。小編覺得挺實用的，因此分享給大家做個參考，一起跟隨小編過來看看吧。

一、準備工作

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/opatch3016-12-08_22-16-39下午_1.log

Patch: /u01/software/24412235/23854735  
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch3016-12-08_22-16-39下午_1.log

Patch: /u01/software/24412235/24006101  
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch3016-12-08_22-16-39下午_1.log

Patch: /u01/software/24412235/24007012  
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch3016-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/opatch3016-12-13_12-05-29下午_1.log

Patch: /u01/software/24412235/23854735  
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch3016-12-13_12-05-29下午_1.log

Patch: /u01/software/24412235/24006101  
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch3016-12-13_12-05-29下午_1.log

Patch: /u01/software/24412235/24007012  
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch3016-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/opatch3016-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/opatch3016-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/opatch3016-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/opatch3016-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/opatch3016-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  
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>

感謝各位的閱讀！關于“Oracle 12c RAC如何安裝PSU”這篇文章就分享到這里了，希望以上內容可以對大家有一定的幫助，讓大家可以學到更多知識，如果覺得文章不錯，可以把它分享出去讓更多的人看到吧！