ITPub博客

首页 > 数据库 > Oracle > Oracle 11g RAC自动打GI PSU补丁

Oracle 11g RAC自动打GI PSU补丁

原创 Oracle 作者:pxbibm 时间:2018-08-02 11:11:34 0 删除 编辑

一、准备工作

1,数据库环境

操作系统版本  : RedHat 6.9 x64   

数据库版本    : Oracle 11.2.0.4 x64 RAC    

Grid          : 11.2.0.4     

Oracle database: 11.2.0.4

2,准备内容

GI PSU : p27967757_112040_Linux-x86-64.zip    
OPatch : p6880880_112000_Linux-x86-64.zip   
DB PSU : p27734982_112040_Linux-x86-64.zip 。

OPatch下载地址:   
https://updates.oracle.com/download/6880880.html

说明: GI PSU包括DB PSU,CPU。

二、更新 OPatch版本,必须要更新

说明:分别在两个节点更新 OPatch版本。

1. 更新OPatch版本,需要更新到11.2.0.3.10,OPatch直接压缩替换就可以了。

(1) 上传p6880880_112000_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限,也可以采用/tmp目录。   
(2) root用户下将原OPatch目录改名。

mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatchbk   
mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatchBK

2. grid目录OPatch替换

(1) root用户   
cd /u01/software/;chown grid:oinstall p6880880_112000_Linux-x86-64.zip

(2) grid用户

su - grid   
cd /u01/software/    
unzip p6880880_112000_Linux-x86-64.zip

(3) root用户

cd /u01/software/   
mv OPatch /u01/app/11.2.0/grid/

(4) grid用户测试

su - grid   
/u01/app/11.2.0/grid/OPatch/opatch version

OPatch Version: 11.2.0.3.11   
OPatch succeeded.

3. oracle目录OPatch替换

(1) root用户

cd /u01/software/;chown oracle:oinstall p6880880_112000_Linux-x86-64.zip

(2) oracle用户

su - oracle   
cd /u01/software/    
unzip p6880880_112000_Linux-x86-64.zip

(3) root用户

cd /u01/software/   
mv OPatch /u01/app/oracle/product/11.2.0/db_1/

(4) oracle用户测试

su - oracle

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.10   
OPatch succeeded.

三、分别在节点 1和节点2分别生成ocm.rsp文件。

# su - oracle

$ cd  /u01/software   
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp    
$ ls

ocm.rsp

  注意:这里需要使用不同的用户进行生成文件, grid 用户, oracle 用户分别生成。

 

四、开始升级 GI PSU软件包

  注意:需要一个节点一个节点按照顺序来。先节点1,再节点2.

1. grid用户下解决GI PSU补丁包

(1) root用户操作

cd /u01/software/;chown grid:oinstall p27967757_112040_Linux-x86-64.zip

(2) grid用户操作

su  - grid   
cd /u01/software/    
unzip p27967757_112040_Linux-x86-64.zip

 

2. 测试兼容性

su - grid

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/27967757/27441052 -oh $ORACLE_HOME    
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/ 27967757 /27734982 -oh $ORACLE_HOME     
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/ 27967757 /27959254 -oh $ORACLE_HOME

过程略过

3、开始升级GRID

root用户依次节点1,节点2上执行。

# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/software/ 27967757 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rsp

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 27967757 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2018-08-02_15-23-05.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:   
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto 2018-08-02_15-23 -05.report.log

2018-08-02 15:23 :05: Starting Clusterware Patch Setup   
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS...   
Stopped CRS successfully

patch /u01/software/ 27967757/27441052   apply successful for home  /u01/app/11.2.0/grid    
patch /u01/software/ 27967757 / 27734982   apply successful for home  /u01/app/11.2.0/grid     
patch /u01/software/ 27967757 / 27959254   apply successful for home  /u01/app/11.2.0/grid

Starting CRS...   
Installing Trace File Analyzer    
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.

 

4. 检查升级情况

# su - grid

$ /u01/app/11.2.0/grid/OPatch/opatch lsinv    
                                                    

Oracle Interim Patch Installer version 11.2.0.3.10

Copyright (c) 2018, 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.10

OUI version       : 11.2.0.4.0

Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-08-02_10-58-12AM_1.log


Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-08-02_10-58-12AM.txt


--------------------------------------------------------------------------------

Local Machine Information::

Hostname: dliddb1.xxxxxx.com.cn

ARU platform id: 226

ARU platform description:: Linux x86-64


Installed Top-level Products (1): 


Oracle Grid Infrastructure 11g                                       11.2.0.4.0

There are 1 products installed in this Oracle Home.



Interim patches (3) :


Patch  27959254     : applied on Wed Aug 01 17:12:22 CST 2018

Unique Patch ID:  22172315

Patch description:  "ACFS Patch Set Update : 11.2.0.4.180717 (27959254)"

   Created on 1 Jul 2018, 23:28:14 hrs PST8PDT

   Bugs fixed:

     16318126, 21369858, 19690653, 17203009, 17503605, 17359415, 20140148

     17611362, 25098392, 17164243, 17696547, 19053182, 17488768, 18168684

     21519796, 18143006, 21208140, 17428148, 17070158, 20438706, 17510275

     17172303, 18610307, 17376318, 17721778, 22198405, 17699423, 22810422

     18915417, 18155334, 18321597, 19919907, 18185024, 17636008, 17363999

     20681968, 17475946, 27463879


Patch  27441052     : applied on Wed Aug 01 17:11:45 CST 2018

Unique Patch ID:  22172315

Patch description:  "OCW PATCH SET UPDATE: 11.2.0.4.180417 (27441052)"

   Created on 5 Feb 2018, 01:05:22 hrs PST8PDT

   Bugs fixed:

     18328800, 19270660, 18691572, 18508710, 20038451, 21251192, 22162062

     20365005, 21232394, 17387214, 17750548, 17617807, 14497275, 20219458

     17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171

     20110156, 17843489, 17065496, 13991403, 21694632, 17273020, 22762046

     17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634

     17886392, 24422155, 20995001, 17039197, 16317771, 17947785, 10052729

     20340620, 22353346, 16237657, 20317221, 18199185, 15917869, 18399991

     20186278, 18024089, 17374271, 16849642, 20246071, 20746251, 14270845

     23621494, 20552947, 18414137, 18882642, 17001914, 17927970, 14378120

     16346413, 15986647, 18068871, 21222147, 16206997, 18143836, 21982225

     25490238, 19168690, 18343490, 20235511, 21875360, 16613232, 19276791

     17722664, 20440643, 12928658, 18226143, 18520351, 16249829, 18952577

     17172091, 18229842, 16076412, 18265482, 20676340, 17818075, 20091753

     18231837, 14373486, 17483479, 20136892, 20551654, 18120545, 18729166

     13843841, 17405302, 21225209, 18709496, 18330979, 18744838, 14525998

     18187697, 17087371, 20531190, 20598625, 14385860, 18348155, 19479503

     12928592, 17516024, 18370031, 17764053, 19272663, 17551223, 14671408

     18272135, 14207615, 21255373, 17500165, 18875012, 14769643, 25656952

     19558324, 18464784, 18848125, 19241857, 14851828, 17955615, 14693336

     20315294, 16284825, 17352230, 20014326, 17238586, 17089344, 17405605

     17531342, 21327402, 26546632, 19398098, 17159489, 17640316, 13823394

     16543190, 22024217, 17983675, 20795241, 17481314, 18346135, 17598201

     16281493, 15986311, 17208793, 19601468, 18999857, 18700935, 14076173

     18428146, 17435488, 18352845, 18352846, 20408163, 17592037, 19616601

     17387779, 17391726, 14777968, 15851860, 16206882, 20141091, 15832129

     17305100, 20175174, 21113068, 19885321, 16901346, 17985714, 25591658

     18536826, 17780903, 18752378, 18946768, 16876500, 16875342, 17769597

     19955755, 16429265, 18336452, 17273003, 17209968, 25484507, 16988311

     19319357, 20094984, 17046460, 17059927, 18053631, 16867761, 18774591

     21442094, 20235486, 19359787, 15869775, 17447588, 19642566, 21152052

     16798862, 15920201


Patch  27734982     : applied on Wed Aug 01 17:11:03 CST 2018

Unique Patch ID:  22229176

Patch description:  "Database Patch Set Update : 11.2.0.4.180717 (27734982)"

   Created on 31 May 2018, 01:37:49 hrs PST8PDT

Sub-patch  27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"

Sub-patch  26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"

Sub-patch  26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"

Sub-patch  26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"

Sub-patch  25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"

Sub-patch  24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"

Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"

Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"

Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"

Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"

Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"

Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"

Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"

Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"

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, 21051852, 24316947, 17811429, 17205719, 18607546, 25654936

     17816865, 20506699, 24835538, 25957038, 23330119, 17922254, 17754782

     13364795, 16934803, 17311728, 20387265, 17284817, 17441661, 20671094

     24560906, 16992075, 17446237, 14015842, 19972569, 21756677, 17375354

     21538558, 20925795, 17449815, 19463897, 26575788, 13866822, 17235750

     17982555, 17478514, 18317531, 14338435, 18235390, 19461270, 20803583

     13944971, 19475971, 20142975, 17811789, 16929165, 18704244, 24662775

     20506706, 17546973, 21422580, 20334344, 14054676, 25489607, 17088068

     17346091, 18264060, 17343514, 21538567, 19680952, 18471685, 19211724

     21132297, 13951456, 16315398, 21847223, 18744139, 16850630, 23177648

     19049453, 18090142, 18673304, 17883081, 19915271, 18641419, 18262334

     25600421, 17006183, 16065166, 18277454, 16833527, 10136473, 18051556

     17865671, 18554871, 17852463, 18774543, 17853498, 18334586, 19487147

     20879889, 17551709, 17588480, 19827973, 17344412, 17842825, 18828868

     20509482, 17025461, 13609098, 11883252, 17239687, 23007241, 17602269

     19197175, 22195457, 18316692, 17313525, 12611721, 21174504, 19544839

     20294666, 18964939, 17600719, 26667015, 18191164, 17571306, 19393542

     20777150, 18482502, 27086138, 19466309, 22243719, 17165204, 17040527

     18098207, 16785708, 17465741, 16180763, 17174582, 12982566, 16777840

     19463893, 22195465, 16875449, 22148226, 12816846, 17237521, 6599380

     19358317, 17811438, 25505394, 17811447, 21983325, 17945983, 18762750

     16912439, 17184721, 18061914, 20598042, 21380789, 17282229, 18948177

     18331850, 21142837, 18202441, 17082359, 18723434, 21972320, 21532755

     19554106, 25505371, 14034426, 18339044, 19458377, 17752995, 20448824

     17891943, 17767676, 17258090, 16668584, 18384391, 17040764, 17381384

     15913355, 18356166, 14084247, 20596234, 21641760, 20506715, 13853126

     21756661, 18203837, 14245531, 16043574, 21756699, 22195441, 17848897

     17877323, 21453153, 19272701, 20569094, 17468141, 17786518, 20861693

     17912217, 17037130, 16956380, 18155762, 17478145, 17394950, 18641461

     18189036, 18619917, 17027426, 21352646, 16268425, 24476274, 22195492

     19584068, 26544823, 18436307, 22507210, 17265217, 13498382, 17634921

     19469538, 21526048, 19258504, 23003979, 18043064, 19174430, 20004087

     17443671, 22195485, 18000422, 20004021, 22321756, 17571039, 27053456

     25897615, 21067387, 16832076, 22905130, 16344544, 21429602, 18009564

     14354737, 21286665, 18135678, 14521849, 18614015, 20441797, 18362222

     25655390, 16472716, 17835048, 17050888, 17936109, 14010183, 17325413

     18747196, 17761775, 16721594, 17082983, 20067212, 21179898, 17302277

     18084625, 20717359, 24624166, 15990359, 24842886, 26746894, 18203835

     23026585, 17297939, 17811456, 16731148, 22380919, 21168487, 14133975

     13829543, 17215560, 17694209, 17385178, 18091059, 8322815, 18259031

     19689979, 25165496, 17586955, 17201159, 17655634, 18331812, 19730508

     17648596, 18868646, 16220077, 16069901, 17393915, 17348614, 17957017

     17274537, 18096714, 17308789, 18436647, 14285317, 19289642, 14764829

     17622427, 18328509, 16943711, 22195477, 22502493, 14368995, 17346671

     18996843, 17783588, 18604493, 21343838, 16618694, 17672719, 18856999

     18783224, 17851160, 17546761, 22168163, 17798953, 18273830, 22092979

     16596890, 19972566, 20828947, 13871092, 26667023, 17726838, 16384983

     22296366, 17360606, 13645875, 22321741, 16542886, 18199537, 25879656

     21787056, 17889549, 21172913, 14565184, 27825893, 20475845, 17071721

     21281607, 18308268, 17610798, 20299015, 21343897, 22893153, 20657441

     17397545, 18230522, 16360112, 19769489, 12905058, 18641451, 12747740

     18430495, 25423453, 17016369, 17042658, 14602788, 17551063, 19972568

     21517440, 23725036, 19788842, 18508861, 14657740, 17332800, 13837378

     17186905, 19972564, 19699191, 18315328, 27441326, 17437634, 24570598

     22353199, 18093615, 19006849, 17392698, 19013183, 17296856, 18674024

     26569225, 17232014, 16855292, 21051840, 14692762, 17762296, 17705023

     23294548, 22351572, 22507234, 19121551, 20324049, 21330264, 26198926

     19854503, 23315889, 26910644, 26030218, 21868720, 19309466, 25764020

     18681862, 17365043, 17390160, 20031873, 20558005, 18554763, 24717859

     21795111, 18456514, 16306373, 13955826, 18139690, 17501491, 17752121

     17299889, 21668627, 23713236, 24652769, 17889583, 18673325, 22551446

     17242746, 19721304, 18293054, 19211433, 19888853, 24563422, 17951233

     18094246, 17649265, 19615136, 17011832, 17477958, 16870214, 18522509

     20631274, 16091637, 17323222, 16595641, 16524926, 18228645, 18282562

     17596908, 18031668, 17156148, 16494615, 22683225, 20869721, 17545847

     25093656, 17655240, 24528741, 17614134, 25427662, 13558557, 17341326

     22465352, 17891946, 17716305, 22657942, 27374796, 16392068, 18440095

     19271443, 21351877, 20513399, 18092127, 17614227, 18440047, 18849970

     16903536, 14106803, 18973907, 18673342, 17389192, 19032867, 25505382

     22809871, 17612828, 17006570, 16194160, 25369547, 25505407, 16685417

     17721717, 21354456, 17390431, 17570240, 16863422, 28100487, 18325460

     17008068, 19727057, 16422541, 17267114, 19972570, 18244962, 21538485

     18203838, 18765602, 16198143, 17246576, 14829250, 17835627, 20860659

     21629064, 18247991, 14458214, 21051862, 17786278, 16692232, 24348685

     17227277, 24476265, 16042673, 16314254, 19285025, 16228604, 16756406

     16837842, 20144308, 17393683, 23536835, 25823754, 18899974, 17787259

     24719736, 20331945, 19490948, 20074391, 15861775, 16399083, 25947799

     18018515, 22683212, 18260550, 21051858, 17080436, 16613964, 17036973

     16579084, 24433711, 18384537, 27870645, 18280813, 20296213, 16901385

     15979965, 23330124, 18441944, 16450169, 27534509, 9756271, 17892268

     11733603, 16285691, 17587063, 21343775, 18180390, 26474853, 16538760

     18193833, 21387964, 21051833, 17238511, 19777862, 17824637, 23065323

     17903598, 16571443, 18306996, 19578350, 14852021, 17853456, 18674047

     12364061, 24411921, 19207117, 22195448




Rac system comprising of multiple nodes

  Local node = dliddb1

  Remote node = dliddb2


--------------------------------------------------------------------------------


OPatch succeeded.

 

五、打 database PSU补丁

1. 准备工作

(1) Root用户下,重新给PSU补丁包赋予权限

cd /u01/software/;chown oracle:oinstall p27734982_112040_Linux-x86-64.zip  


(2) oracle用户

su - oracle   
cd /u01/software/    
unzip p27734982_112040_Linux-x86-64.zip  


2. Oracle用户下检查兼容性

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/27734982 -oh $ORACLE_HOME

Oracle Interim Patch Installer version 11.2.0.3.10

Copyright (c) 2018, Oracle Corporation.  All rights reserved.


PREREQ session


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.10

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-02_11-03-48AM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.


OPatch succeeded.


3. 手工打补丁,只在节点1上执行即可。

1. 停数据库,停监听器,停 em(emctl stop dbconsole)
ps -ef | grep ora 来检查是否还有遗留的进程, grid 的不用管

2. cd 27734982
opatch apply

以上操作只需在一个节点执行即可。会有提示,先 local remote


4. 检查升级情况

$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv    
                                                    

Oracle Interim Patch Installer version 11.2.0.3.10

Copyright (c) 2018, 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.10

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-02_11-09-57AM_1.log


Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-08-02_11-09-57AM.txt


--------------------------------------------------------------------------------

Local Machine Information::

Hostname: dlixxxxxxxm.cn

ARU platform id: 226

ARU platform description:: Linux x86-64


Installed Top-level Products (1): 


Oracle Database 11g                                                  11.2.0.4.0

There are 1 products installed in this Oracle Home.



Interim patches (1) :


Patch  27734982     : applied on Wed Aug 01 19:36:30 CST 2018

Unique Patch ID:  22229176

Patch description:  "Database Patch Set Update : 11.2.0.4.180717 (27734982)"

   Created on 31 May 2018, 01:37:49 hrs PST8PDT

Sub-patch  27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"

Sub-patch  26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"

Sub-patch  26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"

Sub-patch  26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"

Sub-patch  25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"

Sub-patch  24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"

Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"

Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"

Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"

Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"

Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"

Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"

Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"

Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"

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, 21051852, 24316947, 17811429, 17205719, 18607546, 25654936

     17816865, 20506699, 24835538, 25957038, 23330119, 17922254, 17754782

     13364795, 16934803, 17311728, 20387265, 17284817, 17441661, 20671094

     24560906, 16992075, 17446237, 14015842, 19972569, 21756677, 17375354

     21538558, 20925795, 17449815, 19463897, 26575788, 13866822, 17235750

     17982555, 17478514, 18317531, 14338435, 18235390, 19461270, 20803583

     13944971, 19475971, 20142975, 17811789, 16929165, 18704244, 24662775

     20506706, 17546973, 21422580, 20334344, 14054676, 25489607, 17088068

     17346091, 18264060, 17343514, 21538567, 19680952, 18471685, 19211724

     21132297, 13951456, 16315398, 21847223, 18744139, 16850630, 23177648

     19049453, 18090142, 18673304, 17883081, 19915271, 18641419, 18262334

     25600421, 17006183, 16065166, 18277454, 16833527, 10136473, 18051556

     17865671, 18554871, 17852463, 18774543, 17853498, 18334586, 19487147

     20879889, 17551709, 17588480, 19827973, 17344412, 17842825, 18828868

     20509482, 17025461, 13609098, 11883252, 17239687, 23007241, 17602269

     19197175, 22195457, 18316692, 17313525, 12611721, 21174504, 19544839

     20294666, 18964939, 17600719, 26667015, 18191164, 17571306, 19393542

     20777150, 18482502, 27086138, 19466309, 22243719, 17165204, 17040527

     18098207, 16785708, 17465741, 16180763, 17174582, 12982566, 16777840

     19463893, 22195465, 16875449, 22148226, 12816846, 17237521, 6599380

     19358317, 17811438, 25505394, 17811447, 21983325, 17945983, 18762750

     16912439, 17184721, 18061914, 20598042, 21380789, 17282229, 18948177

     18331850, 21142837, 18202441, 17082359, 18723434, 21972320, 21532755

     19554106, 25505371, 14034426, 18339044, 19458377, 17752995, 20448824

     17891943, 17767676, 17258090, 16668584, 18384391, 17040764, 17381384

     15913355, 18356166, 14084247, 20596234, 21641760, 20506715, 13853126

     21756661, 18203837, 14245531, 16043574, 21756699, 22195441, 17848897

     17877323, 21453153, 19272701, 20569094, 17468141, 17786518, 20861693

     17912217, 17037130, 16956380, 18155762, 17478145, 17394950, 18641461

     18189036, 18619917, 17027426, 21352646, 16268425, 24476274, 22195492

     19584068, 26544823, 18436307, 22507210, 17265217, 13498382, 17634921

     19469538, 21526048, 19258504, 23003979, 18043064, 19174430, 20004087

     17443671, 22195485, 18000422, 20004021, 22321756, 17571039, 27053456

     25897615, 21067387, 16832076, 22905130, 16344544, 21429602, 18009564

     14354737, 21286665, 18135678, 14521849, 18614015, 20441797, 18362222

     25655390, 16472716, 17835048, 17050888, 17936109, 14010183, 17325413

     18747196, 17761775, 16721594, 17082983, 20067212, 21179898, 17302277

     18084625, 20717359, 24624166, 15990359, 24842886, 26746894, 18203835

     23026585, 17297939, 17811456, 16731148, 22380919, 21168487, 14133975

     13829543, 17215560, 17694209, 17385178, 18091059, 8322815, 18259031

     19689979, 25165496, 17586955, 17201159, 17655634, 18331812, 19730508

     17648596, 18868646, 16220077, 16069901, 17393915, 17348614, 17957017

     17274537, 18096714, 17308789, 18436647, 14285317, 19289642, 14764829

     17622427, 18328509, 16943711, 22195477, 22502493, 14368995, 17346671

     18996843, 17783588, 18604493, 21343838, 16618694, 17672719, 18856999

     18783224, 17851160, 17546761, 22168163, 17798953, 18273830, 22092979

     16596890, 19972566, 20828947, 13871092, 26667023, 17726838, 16384983

     22296366, 17360606, 13645875, 22321741, 16542886, 18199537, 25879656

     21787056, 17889549, 21172913, 14565184, 27825893, 20475845, 17071721

     21281607, 18308268, 17610798, 20299015, 21343897, 22893153, 20657441

     17397545, 18230522, 16360112, 19769489, 12905058, 18641451, 12747740

     18430495, 25423453, 17016369, 17042658, 14602788, 17551063, 19972568

     21517440, 23725036, 19788842, 18508861, 14657740, 17332800, 13837378

     17186905, 19972564, 19699191, 18315328, 27441326, 17437634, 24570598

     22353199, 18093615, 19006849, 17392698, 19013183, 17296856, 18674024

     26569225, 17232014, 16855292, 21051840, 14692762, 17762296, 17705023

     23294548, 22351572, 22507234, 19121551, 20324049, 21330264, 26198926

     19854503, 23315889, 26910644, 26030218, 21868720, 19309466, 25764020

     18681862, 17365043, 17390160, 20031873, 20558005, 18554763, 24717859

     21795111, 18456514, 16306373, 13955826, 18139690, 17501491, 17752121

     17299889, 21668627, 23713236, 24652769, 17889583, 18673325, 22551446

     17242746, 19721304, 18293054, 19211433, 19888853, 24563422, 17951233

     18094246, 17649265, 19615136, 17011832, 17477958, 16870214, 18522509

     20631274, 16091637, 17323222, 16595641, 16524926, 18228645, 18282562

     17596908, 18031668, 17156148, 16494615, 22683225, 20869721, 17545847

     25093656, 17655240, 24528741, 17614134, 25427662, 13558557, 17341326

     22465352, 17891946, 17716305, 22657942, 27374796, 16392068, 18440095

     19271443, 21351877, 20513399, 18092127, 17614227, 18440047, 18849970

     16903536, 14106803, 18973907, 18673342, 17389192, 19032867, 25505382

     22809871, 17612828, 17006570, 16194160, 25369547, 25505407, 16685417

     17721717, 21354456, 17390431, 17570240, 16863422, 28100487, 18325460

     17008068, 19727057, 16422541, 17267114, 19972570, 18244962, 21538485

     18203838, 18765602, 16198143, 17246576, 14829250, 17835627, 20860659

     21629064, 18247991, 14458214, 21051862, 17786278, 16692232, 24348685

     17227277, 24476265, 16042673, 16314254, 19285025, 16228604, 16756406

     16837842, 20144308, 17393683, 23536835, 25823754, 18899974, 17787259

     24719736, 20331945, 19490948, 20074391, 15861775, 16399083, 25947799

     18018515, 22683212, 18260550, 21051858, 17080436, 16613964, 17036973

     16579084, 24433711, 18384537, 27870645, 18280813, 20296213, 16901385

     15979965, 23330124, 18441944, 16450169, 27534509, 9756271, 17892268

     11733603, 16285691, 17587063, 21343775, 18180390, 26474853, 16538760

     18193833, 21387964, 21051833, 17238511, 19777862, 17824637, 23065323

     17903598, 16571443, 18306996, 19578350, 14852021, 17853456, 18674047

     12364061, 24411921, 19207117, 22195448




Rac system comprising of multiple nodes

  Local node = dlxxxxxxdb1

  Remote node = dlixxxxdb2


--------------------------------------------------------------------------------

六、升级数据库数据字典

数据库启动,并加载修改 SQL Files到数据库

$ sqlplus / as sysdba   
  
SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 25 11:26:02 2015

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> select open_mode from v$database;

OPEN_MODE   
--------------------    
READ WRITE

SQL>    
SQL>

SQL> @?/rdbms/admin/catbundle.sql psu apply

SQL>    
执行完后我们可以查到 PSU更新信息:    
SQL>

set line 150   
col ACTION_TIME for a30    
col ACTION for a8    
col NAMESPACE for a8    
col VERSION for a10    
col BUNDLE_SERIES for a5    
col COMMENTS for a20    

SQL> select * from sys.registry$history;


ACTION_TIME                  ACTION                         NAMESPACE                      VERSION          ID COMMENTS                       BUNDLE_SERIES

---------------------------- ------------------------------ ------------------------------ -------- ---------- ------------------------------ ------------------------------

31-JUL-18 08.55.42.264974 PM APPLY                          SERVER                         11.2.0.4          0 Patchset 11.2.0.2.0            PSU

01-AUG-18 07.43.23.238156 PM APPLY                          SERVER                         11.2.0.4     180717 PSU 11.2.0.4.180717            PSU


2 rows selected.



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12798004/viewspace-2168945/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    240
  • 访问量
    2155578