RAC安装补丁的方法

最新推荐文章于 2024-05-31 10:46:10 发布

cuimiehu1945

最新推荐文章于 2024-05-31 10:46:10 发布

阅读量180

点赞数

文章标签： java 数据库操作系统

RAC安装补丁的方法

Rolling Patch - OPatch Support for RAC (文档 ID 244241.1)

All-Node Patch

. Shutdown all Oracle instances on all nodes

. Apply the patch to the RAC home on all nodes

. Bring all instances up

Minimum downtime

. Shutdown all the Oracle instances on node 1

. Apply the patch to the RAC home on node 1

. Shutdown all the Oracle instances on node 2

. Apply the patch to the RAC home on node 2

. Shutdown all the Oracle instances on node 3

. At this point, instances on nodes 1 and 2 can be brought up

. Apply the patch to the RAC home on node 3

. Startup all the Oracle instances on node 3

Rolling patch (no downtime)

. Shutdown all the Oracle instances on node 1

. Apply the patch to the RAC home on node 1

. Start all the Oracle instances on node 1

. Shutdown all the Oracle instances on node 2

. Apply the patch to the RAC home on node 2

. Start all the Oracle instances on node 2

. Shutdown all the Oracle instances on node 3

. Apply the patch to the RAC home on node 3

. Start all the Oracle instances on node 3

这里我采取第一种方法

一：查看当前操作系统版本并关闭数据库实例

[oracle@lzl Opatch]$ ./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

[grid@yq ~]$ srvctl stop database -d orcl

二：解压psu安装包

unzip -q p24732075_112040_Linux-x86-64.zip

三：检查补丁是否冲突

[oracle@lzl 24732075]$ /u01/app/oracle/product/11.2.0/db_1/Opatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 11.2.0.3.4

PREREQ session

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

Central Inventory : /u01/11.2.0/oraInventory

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

OPatch version : 11.2.0.3.4

OUI version : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-05-08_18-43-55PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@lzl 24732075]$

四：升级补丁

根据官方文档README.html要求，opatch不能低于11.2.0.3.6

OPatch Utility

You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release.

4.1：对当前opatch做备份

mv Opatch/ Opatch.bak

4.2：解压更新p6880880

unzip -q p6880880_112000_Linux-x86-64.zip

可以看到当前路径下生成了一个新的Opatch文件

drwxr-x--- 15 oracle oinstall 4096 Aug 24 2016 OPatch

4.3：查看opatch的版本

[oracle@yq db_1]$ cd OPatch

[oracle@yq OPatch]$

[oracle@yq OPatch]$ opatch version

OPatch Version: 11.2.0.3.15

OPatch succeeded.

4.4：安装补丁

[oracle@yq 24732075]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.15

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

Central Inventory : /u01/11.2.0/oraInventory

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

OPatch version : 11.2.0.3.15

OUI version : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-05-08_20-25-07PM_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

Do you want to proceed? [y|n]

User Responded with: Y

All checks passed.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

This node is part of an Oracle Real Application Cluster.

Remote nodes: 'lzl'

Local node: 'yq'

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/11.2.0/db_1')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

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

Patching component oracle.rdbms, 11.2.0.4.0...

中间部分省略

The node 'lzl' will be patched next.

这里将要远程安装另外一个节点的补丁，要求远程的节点的实例时关闭的。

Please shutdown Oracle instances running out of this ORACLE_HOME on 'lzl'.

(Oracle Home = '/u01/app/oracle/product/11.2.0/db_1')

Is the node ready for patching? [y|n]

User Responded with: Y

Updating nodes 'lzl'

Apply-related files are:

FP = "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/NApply/2017-05-08_20-25-07PM/rac/copy_files.txt"

DP = "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/NApply/2017-05-08_20-25-07PM/rac/copy_dirs.txt"

MP = "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/NApply/2017-05-08_20-25-07PM/rac/make_cmds.txt"

RC = "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/NApply/2017-05-08_20-25-07PM/rac/remote_cmds.txt"

中间部分省略

The node 'lzl' has been patched. You can restart Oracle instances on it.

Finished patching in rolling mode.

Composite patch 24732075 successfully applied.

Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-05-08_20-25-07PM_1.log

OPatch succeeded.

4.5：查看补丁

[oracle@yq OPatch]$ opatch lsinv

Oracle Interim Patch Installer version 11.2.0.3.15

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

Central Inventory : /u01/11.2.0/oraInventory

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

OPatch version : 11.2.0.3.15

OUI version : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-05-08_23-08-12PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-08_23-08-12PM.txt

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

Local Machine Information::

Hostname: yq

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 24732075 : applied on Mon May 08 20:44:03 CST 2017

Unique Patch ID: 21176096

Patch description: "Database Patch Set Update : 11.2.0.4.170418 (24732075)"

Created on 22 Feb 2017, 21:40:49 hrs PST8PDT

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:

17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944

13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498

17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856

21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210

17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317

22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886

18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240

17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706

21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056

22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377

17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461

14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549

19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898

24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525

22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942

21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719

18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720

17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568

19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750

16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060

17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634

16228604, 20074391, 19972570, 18996843, 19854503, 16042673, 17835627

20334344, 18000422, 20861693, 17393683, 17551709, 20506699, 19006849

18456514, 18277454, 17258090, 17174582, 17242746, 16399083, 17824637

17762296, 17397545, 16450169, 12364061, 20067212, 18856999, 19211724

19463893, 21343775, 19463897, 17853456, 18673304, 20004021, 21668627

16194160, 17477958, 16538760, 12982566, 20296213, 18293054, 17610798

19699191, 18135678, 17311728, 16785708, 10136473, 24560906, 17786518

18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014

16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838

18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320

18282562, 16855292, 16668584, 21343838, 20299015, 17446237, 18093615

17694209, 17288409, 17274537, 13955826, 16934803, 17634921, 17501491

16315398, 22683212, 17006183, 13829543, 18191164, 17655240, 19393542

18384391, 21538567, 16198143, 21847223, 17892268, 20142975, 19584068

17165204, 18508861, 21756699, 16901385, 18554763, 18189036, 17443671

17385178, 17936109, 14829250, 20925795, 17478514, 16850630, 13951456

16595641, 15861775, 14054676, 16912439, 17299889, 17297939, 18619917

16833527, 17798953, 17816865, 18607546, 17571306, 21286665, 17341326

17851160, 20558005, 17586955, 19049453, 21051840, 17587063, 16956380

18328509, 14133975, 18061914, 21051833, 18522509, 18765602, 18199537

17332800, 13609098, 18384537, 22502493, 14338435, 17945983, 21067387

16392068, 17752995, 21051862, 25505382, 17237521, 16863422, 18244962

19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390

17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625

21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996

19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015

17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943

22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719

25505394, 17265217, 17071721, 16721594, 21756661, 18262334, 15913355

17891946, 17672719, 17602269, 17239687, 17042658, 17238511, 17811456

17284817, 17752121, 17394950, 16579084, 17011832, 22195465, 14602788

18325460, 24476265, 24476274, 12611721, 16903536, 17006570, 16043574

18783224, 16494615, 21526048, 19197175, 16069901, 17811447, 17308789

22195477, 17865671, 19013183, 17343514, 18316692, 17325413, 16180763

17348614, 14368995, 21983325, 17393915, 16285691, 20331945, 17883081

24316947, 17705023, 17614227, 22195485, 14084247, 13645875, 16777840

19727057, 14852021, 18744139, 18674047, 17716305, 18482502, 17622427

19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 19258504

17786278, 17082983, 21351877, 13498382, 18331812, 16065166, 18031668

22893153, 16943711, 21517440, 17649265, 13866822, 18094246, 24528741

14245531, 17783588, 17082359, 20448824, 18280813, 23330119, 16268425

17302277, 18018515, 17215560, 24411921, 19271443, 17016369, 20777150

23330124, 20441797, 19769489, 25093656, 17545847, 18260550, 13853126

23536835, 17227277, 9756271, 18868646, 17614134, 17546973, 19680952

18704244, 18828868, 18273830, 17050888, 17360606, 16992075, 17375354

12905058, 18362222, 17571039, 17468141, 18436647, 17235750, 21168487

16220077, 16929165

Rac system comprising of multiple nodes

Local node = yq

Remote node = lzl

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

OPatch succeeded.

五、打开数据库

[oracle@yq OPatch]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/

[grid@yq ~]$ srvctl start database -d orcl

[oracle@yq admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 8 23:19:04 2017

SQL> conn / as sysdba

Connected.

SQL> @catbundle.sql psu apply

SQL> QUIT

The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series PSU.

For information about the catbundle.sql script, see My Oracle Support Document 605795.1 Introduction to Oracle Database catbundle.sql.

If the OJVM PSU was applied for a previous PSU patch, you may see invalid Java classes after execution of the catbundle.sql script in the previous step. If this is the case, run utlrp.sql to re-validate these Java classes.

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @utlrp.sql

Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle for any errors:

catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log

catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log

where TIMESTAMP is of the form YYYYMMMDD_HH_MM_SS. If there are errors, refer to Section 5, "Known Issues".

This patch now includes the OJVM Mitigation patch (Patch:19721304). If an OJVM PSU is installed or planned to be installed, no further actions are necessary. Otherwise, the workaround of using the OJVM Mitigation patch can be activated. As SYSDBA do the following from the admin directory:

SQL > @dbmsjdev.sql

SQL > exec dbms_java_dev.disable

至此，oracle软件的补丁安装完毕。

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

转载于:http://blog.itpub.net/31467250/viewspace-2140528/