p16056266_112030_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip (opatch)
两个节点都先把opatch更新,grid 和oracle下都要更新
检查是否可以滚动升级,一般看说明文档。
[grid@cqrac2 16056266]$ opatch query -is_rolling_patch
但如果这个补丁有多个目录,则会返回错误
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, 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.4
OUI version : 11.2.0.3.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-07-22_15-15-08PM_1.log
Failed to load the patch object. Possible causes are:
The specified path is not an interim Patch shiphome
Meta-data files are missing from the patch area
Patch location = /opt/11.2.0.3/16056266
Details = Input metadata files are missing.
Patch Location "/opt/11.2.0.3/16056266" doesn't point to a valid patch area.
二 停止dbconsole,升级步骤也很无聊,停一个节点,执行opatch,当提示要停一个节点时,启这个节点,再停第二个节点。
[oracle@rac1~] emctl stop dbconsole
su - root
解除锁定
[oracle@rac1~] srvctl stop instance -d cqrac -n cqrac1
$CRS_HOME/crs/install/rootcrs.pl -unlock
[root@cqrac1 16056266]# crsctl stop crs
su - grid
opatch napply -oh $GRID_HOME -local /home/oracle/tmp/16902043
由于这里用的是本地更新模式,第二个节点也得这么做,当然也可以不用本地模式,建议用。
su - oracle
[root@cqrac1 16056266]# opatch apply
Patchinginrolling mode.
The node'cqrac2'will be patched next.
Please shutdown Oracle instances runningoutofthisORACLE_HOME on'cqrac2'.
(Oracle Home='/u01/app/oracle/product/11.2.0/db_1')
Is the node readyforpatching?[y|n]
当出现这一步时,需要停掉第二个节点:
[grid@cqrac216056266]$ srvctl stop instance-d cqrac-n cqrac2当升级完成,出现:
The node 'cqrac2' has been patched. You can restart Oracle instances on it.
Composite patch 16056266 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2013-07-22_16-15-08PM_1.log[grid@cqrac2 16056266]$ srvctl start instance -d cqrac -n cqrac2
[grid@cqrac2 16056266]$ srvctl status database -d cqrac
Instance cqrac1 is running on node cqrac1
Instance cqrac2 is running on node cqrac2
在一个节点上
cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/
SQL> @catbundle.sql psu apply
SQL> QUIT最后可以检查下:select* from dba_registry_history;或者lsinventory,这里注意一下就是在第二个节点用此种方法看不到信息。[oracle@cqrac1 admin]$ opatch lsinventory
Oracle Interim Patch Installer version11.2.0.3.4
Copyright (c)2012, 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.4
OUI version :11.2.0.3.0
Log file location :/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2013-07-22_16-46-45PM_1.log
Lsinventory Output file location :/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-07-22_16-46-45PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g11.2.0.3.0
There are1products installedinthisOracle Home.
Interim patches (1) :
Patch16056266: applied on Mon Jul2216:20:57CST2013
Unique Patch ID:15962803
Patch description:"Database Patch Set Update : 11.2.0.3.6 (16056266)"
Created on12Mar2013,02:14:47hrs PST8PDT
Sub-patch14727310;"Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch14275605;"Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch13923374;"Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch13696216;"Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch13343438;"Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugsfixed:
13566938,13593999,10350832,14138130,12919564,13561951,13624984
13588248,13080778,13914613,13804294,14258925,12873183,13645875
14472647,12880299,14664355,14409183,12998795,14469008,13719081
13492735,13496884,12857027,14263036,14263073,13732226,13742433
16368108,16314469,12905058,13742434,12849688,12950644,13742435
13464002,13534412,12879027,13958038,14613900,12585543,12535346
12588744,11877623,13786142,12847466,13649031,13981051,12582664
12797765,14262913,12923168,13384182,13612575,13466801,13484963
14207163,11063191,13772618,13070939,12797420,13041324,16314467
16314468,12976376,11708510,13680405,14589750,13026410,13742437
13737746,14644185,13742438,13326736,13596521,13001379,16344871
13099577,9873405,14275605,13742436,9858539,14841812,11715084
16231699,14040433,12662040,9703627,12617123,12845115,12764337
13354082,14459552,13397104,13913630,12964067,12983611,13550185
13810393,12780983,12583611,14546575,13476583,15862016,11840910
13903046,15862017,13572659,16294378,13718279,14088346,13657605
13448206,16314466,14480676,13419660,13632717,14063281,14110275
13430938,13467683,13420224,13812031,14548763,16299830,12646784
13616375,14035825,12861463,12834027,15862021,13632809,13377816
13036331,14727310,13685544,15862018,13499128,16175381,13584130
12829021,15862019,12794305,14546673,12791981,13787482,13503598
10133521,12718090,13399435,14023636,13860201,12401111,13257247
13362079,14176879,12917230,13923374,14220725,14480675,13524899
13559697,9706792,14480674,13916709,13098318,13773133,14076523
13340388,13366202,13528551,12894807,13454210,13343438,12748240
14205448,13385346,15853081,14273397,12971775,13582702,10242202
13035804,13544396,16382353,8547978,14226599,14062795,13035360
12693626,13332439,14038787,14062796,12913474,14841409,14390252
16314470,13370330,13059165,14062797,14062794,12959852,13358781
12345082,12960925,9659614,13699124,14546638,13936424,13338048
12938841,12658411,12620823,12656535,14062793,12678920,13038684
14062792,13807411,13250244,12594032,15862022,9761357,12612118
13742464,14052474,13911821,13457582,13527323,15862020,13910420
13502183,12780098,13705338,13696216,14841558,10263668,15862023
16056266,15862024,13554409,13645917,13103913,13011409,14063280
Rac system comprising of multiple nodes
Local node=cqrac1
Remote node=cqrac2
--------------------------------------------------------------------------------
OPatch succeeded.
posted on 2013-07-22 17:47 snowhill 阅读(1465) 评论(1) 编辑 收藏 引用 所属分类: 数据库-oracle