Oracle 11gR2 单机打补丁PSU 11.2.0.4.180717

上传补丁包，修改权限

su -Oracle

mdir /tmp/psu

mv p6880880_112319_Linux-x86-64.zip /tmp/psu/

mv databasepsu180717_112040_Linux-x86-64.zip /tmp/psu

su - root

chown oracle.oinstall /tmp/psu -R

查看当前数据库的补丁情况

[oracle@localhost ~]$ $ORACLE_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.4

把OPatch替换原ORACLE_HOME里的OPatch目录，配置OPatch的环境变量

[oracle@localhost ~]$ cd $ORACLE_HOME

[oracle@localhost db_1]$ mv OPatch OPatchbak

[oracle@localhost db_1]$ mv  /tmp/psu/OPatch/ ./

[oracle@localhost db_1]$ OPatch/opatch version

OPatch Version: 11.2.0.3.19

OPatch succeeded.

[oracle@localhost db_1]$ vi ~/.bash_profile

export PATH=$ORACLE_HOME/bin/:$PATH:$ORACLE_HOME/OPatch

[oracle@localhost db_1]$ source ~/.bash_profile

[oracle@localhost db_1]$ which  opatch

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

查看当前数据库的补丁情况

[oracle@localhost db_1]$ opatch lsinventory

Oracle 中间补丁程序安装程序版本 11.2.0.3.19

版权所有 (c) 2018, Oracle Corporation。保留所有权利。

Oracle Home      : /u01/app/oracle/product/db_1

Central Inventory : /u01/app

from          : /u01/app/oracle/product/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/db_1/cfgtoollogs/opatch/opatch2018-11-08_11-29-25上午_1.log

Lsinventory Output file location : /u01/app/oracle/product/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-11-08_11-29-25上午.txt

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

Local Machine Information::

Hostname: localhost

ARU platform id: 226

ARU platform description:: Linux x86-64

已安装的顶级产品 (1):

Oracle Database 11g                                                  11.2.0.4.0

此 Oracle 主目录中已安装 1 个产品。

此 Oracle 主目录中未安装任何中间补丁程序。

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

OPatch succeeded.

升级前检查是否有冲突

[oracle@localhost db_1]$ cd /tmp/psu/27734982/

[oracle@localhost 27734982]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle 中间补丁程序安装程序版本 11.2.0.3.19

版权所有 (c) 2018, Oracle Corporation。保留所有权利。

PREREQ session

Oracle Home      : /u01/app/oracle/product/db_1

Central Inventory : /u01/app

from          : /u01/app/oracle/product/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/db_1/cfgtoollogs/opatch/opatch2018-11-08_11-30-54上午_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

保证数据库及监听都关闭，开始安装Patch包

[oracle@localhost 27734982]$ opatch apply

Oracle 中间补丁程序安装程序版本 11.2.0.3.19

版权所有 (c) 2018, Oracle Corporation。保留所有权利。

Oracle Home      : /u01/app/oracle/product/db_1

Central Inventory : /u01/app

from          : /u01/app/oracle/product/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/db_1/cfgtoollogs/opatch/opatch2018-11-08_11-33-06上午_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:  17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111  24732075  25869727  26609445  26392168  26925576  27338049  27734982 

是否继续? [y|n]

y

User Responded with: Y

All checks passed.

提供电子邮件地址以用于接收有关安全问题的通知, 安装 Oracle Configuration Manager 并启动它。如果您使用 My Oracle

Support 电子邮件地址/用户名, 操作将更简单。

有关详细信息, 请访问 http://www.oracle.com/support/policies.html。

电子邮件地址/用户名:

尚未提供电子邮件地址以接收有关安全问题的通知。

是否不希望收到有关安全问题 (是 [Y], 否 [N]) [N] 的通知:  y

请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。

(Oracle 主目录 = '/u01/app/oracle/product/db_1')

本地系统是否已准备打补丁? [y|n]

y

User Responded with: Y

Backing up files...

Applying sub-patch '17478514' to OH '/u01/app/oracle/product/db_1'

......

Composite patch 27734982 successfully applied.

Log file location: /u01/app/oracle/product/db_1/cfgtoollogs/opatch/opatch2018-11-08_11-33-06上午_1.log

OPatch succeeded.

升级数据字典并重新编译无效对象

[oracle@localhost 27734982]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 8 11:37:04 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

idle>startup

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

检查日志没有报错

编译失效对象

sys@YDTEST>@?/rdbms/admin/utlrp.sql

检查升级情况

sys@YDTEST> select * from dba_registry_history

ACTION_TIME                                    ACTION              NAMESPACE

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

VERSION                    ID BUNDLE_SERIES

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

COMMENTS

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

24-AUG-13 12.03.45.119862 PM                            APPLY              SERVER

11.2.0.4                0 PSU

Patchset 11.2.0.2.0

17-JUL-18 09.35.53.845994 AM                            APPLY              SERVER

11.2.0.4                0 PSU

Patchset 11.2.0.2.0

08-NOV-18 11.38.31.692426 AM                            APPLY              SERVER

11.2.0.4              180717 PSU

PSU 11.2.0.4.180717

[oracle@localhost 27734982]$ opatch lsinventory

Oracle 中间补丁程序安装程序版本 11.2.0.3.19

版权所有 (c) 2018, Oracle Corporation。保留所有权利。

Oracle Home      : /u01/app/oracle/product/db_1

Central Inventory : /u01/app

from          : /u01/app/oracle/product/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/db_1/cfgtoollogs/opatch/opatch2018-11-08_11-42-25上午_1.log

Lsinventory Output file location : /u01/app/oracle/product/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-11-08_11-42-25上午.txt

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

Local Machine Information::

Hostname: localhost

ARU platform id: 226

ARU platform description:: Linux x86-64

已安装的顶级产品 (1):

Oracle Database 11g                                                  11.2.0.4.0

此 Oracle 主目录中已安装 1 个产品。

中间补丁程序 (1) :

Patch  27734982    : applied on Thu Nov 08 11:36:07 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:

21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965

20671094, 16731148, 16314254, 13837378, 18441944, 17835048, 13558557

17008068, 17201159, 25427662, 17853498, 20717359, 17246576, 18356166

18681862, 18440047, 20569094, 20031873, 16875449, 20387265, 19788842

17296856, 21330264, 14010183, 17648596, 17551063, 17025461, 24719736

17267114, 22507210, 17912217, 17889583, 18202441, 17040764, 17478145

16524926, 25655390, 19358317, 22148226, 18747196, 26544823, 18641419

17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 16618694

8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092

24624166, 24348685, 17848897, 17441661, 14034426, 17465741, 16596890

17437634, 21343897, 20506706, 21453153, 18339044, 17951233, 22321741

21795111, 18430495, 21787056, 22380919, 19469538, 20506715, 17811429

19721304, 17903598, 18230522, 19554106, 19458377, 21281607, 17612828

6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740

13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390

26474853, 18849970, 17889549, 19309466, 16472716, 20596234, 18331850

18641451, 17344412, 21179898, 19461270, 17546761, 24842886, 14521849

18203835, 18203838, 18964939, 18203837, 17313525, 22195457, 18139690

16837842, 22296366, 14106803, 17842825, 21352646, 22657942, 16360112

20657441, 22195441, 17389192, 26198926, 14565184, 17205719, 18440095

14764829, 22195448, 14354737, 13944971, 16571443, 21868720, 17186905

17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568

20144308, 19972566, 17282229, 19972564, 16870214, 21629064, 19615136

21354456, 17390431, 18762750, 23007241, 16613964, 17957017, 18098207

18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719

18317531, 17852463, 17596908, 17655634, 16228604, 27053456, 20074391

19972570, 18090142, 18996843, 19854503, 16042673, 17835627, 20334344

17393683, 20861693, 18000422, 17551709, 26575788, 23315889, 20506699

19006849, 18277454, 18456514, 19174430, 17258090, 17174582, 25654936

17242746, 16399083, 17824637, 21132297, 22465352, 17762296, 22168163

17397545, 16450169, 12364061, 20067212, 18856999, 19211724, 19463893

19463897, 21343775, 17853456, 18673304, 20004021, 26030218, 21668627

16194160, 17477958, 16538760, 12982566, 24570598, 20828947, 18259031

20296213, 18293054, 17610798, 19699191, 23065323, 17311728, 18135678

18774543, 23294548, 16785708, 10136473, 24560906, 22551446, 19777862

17786518, 18315328, 18334586, 12747740, 18096714, 19032867, 21641760

17390160, 18899974, 17232014, 20598042, 18673325, 16422541, 18155762

14015842, 19827973, 22683225, 17726838, 18554871, 23177648, 18051556

20803583, 21972320, 15990359, 17922254, 18282562, 16855292, 16668584

21343838, 20299015, 17446237, 18093615, 18043064, 23713236, 17694209

17288409, 18308268, 20475845, 17274537, 13955826, 16934803, 17634921

17501491, 16315398, 23725036, 22683212, 17006183, 13829543, 18191164

17655240, 26746894, 22809871, 18384391, 19393542, 21538567, 16198143

21847223, 25823754, 17892268, 20142975, 19584068, 17165204, 25165496

18604493, 21756699, 18508861, 16901385, 18554763, 21532755, 18189036

17443671, 17385178, 14829250, 17936109, 20925795, 20509482, 17478514

27441326, 16850630, 13951456, 16595641, 14054676, 15861775, 21142837

16912439, 17299889, 17297939, 23003979, 18619917, 16833527, 17798953

17816865, 18607546, 17571306, 21286665, 17341326, 26910644, 17851160

20558005, 17586955, 19049453, 21051840, 17587063, 16956380, 18328509

25423453, 14133975, 18061914, 18522509, 21051833, 20294666, 18765602

20860659, 20324049, 18199537, 17332800, 13609098, 22502493, 18384537

14338435, 17945983, 16392068, 21067387, 17752995, 21051862, 16863422

25505382, 17237521, 18244962, 19544839, 24433711, 24717859, 17156148

18973907, 23026585, 17877323, 17449815, 18180390, 17088068, 17037130

20004087, 21422580, 19466309, 11733603, 25505371, 21051858, 18084625

18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259

18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762

18614015, 17346091, 18228645, 17721717, 18436307, 21756677, 19888853

11883252, 17891943, 19475971, 22353199, 16384983, 19121551, 27825893

12816846, 17982555, 17761775, 22243719, 17265217, 25505394, 17071721

16721594, 18262334, 21756661, 17891946, 15913355, 17672719, 17602269

17239687, 17042658, 17238511, 17811456, 17284817, 17752121, 20879889

21380789, 17394950, 17011832, 16579084, 22195465, 14602788, 18325460

24476265, 26569225, 24476274, 12611721, 16903536, 17006570, 19689979

16043574, 18783224, 24662775, 16494615, 21526048, 17392698, 19197175

16069901, 17811447, 27870645, 17308789, 22195477, 24835538, 17865671

17343514, 19013183, 17325413, 18316692, 16180763, 17348614, 14368995

21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 17705023

24316947, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840

19727057, 14852021, 18744139, 18674047, 17716305, 19285025, 18482502

27534509, 17622427, 19289642, 22195492, 25947799, 14458214, 20869721

21172913, 17767676, 18723434, 25505407, 17786278, 19258504, 17082983

21351877, 17365043, 13498382, 18331812, 16065166, 25489607, 16685417

18031668, 22893153, 16943711, 19272701, 21517440, 25897615, 17649265

13866822, 18094246, 24528741, 17783588, 14245531, 17082359, 18280813

20448824, 23330119, 16268425, 19487147, 25600421, 18018515, 17302277

17215560, 24411921, 19271443, 25764020, 17016369, 20777150, 23330124

16756406, 20441797, 19769489, 28100487, 17545847, 25093656, 18260550

13853126, 17227277, 23536835, 25957038, 24652769, 19207117, 9756271

18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015

17050888, 18828868, 18273830, 17360606, 16992075, 24563422, 17375354

12905058, 18362222, 21429602, 27086138, 17571039, 17468141, 18436647

17235750, 21168487, 16220077, 16929165

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

OPatch succeeded.

7、升级失败回滚

opatch rollback -id 27734982

更多Oracle相关信息见 Oracle 专题页面 https://www.linuxidc.com/topicnews.aspx?tid=12

Linux公社的RSS地址 ： https://www.linuxidc.com/rssFeed.aspx

本文永久更新链接地址： https://www.linuxidc.com/Linux/2019-01/156323.htm