oracle补丁6,oracle rac 打11.2.0.3.6补丁

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.4Copyright (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.4OUI version       :11.2.0.3.0Log 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.0There are1products installedinthisOracle Home.

Interim patches (1) :

Patch16056266: applied on Mon Jul2216:20:57CST2013Unique Patch ID:15962803Patch 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,1362498413588248,13080778,13914613,13804294,14258925,12873183,1364587514472647,12880299,14664355,14409183,12998795,14469008,1371908113492735,13496884,12857027,14263036,14263073,13732226,1374243316368108,16314469,12905058,13742434,12849688,12950644,1374243513464002,13534412,12879027,13958038,14613900,12585543,1253534612588744,11877623,13786142,12847466,13649031,13981051,1258266412797765,14262913,12923168,13384182,13612575,13466801,1348496314207163,11063191,13772618,13070939,12797420,13041324,1631446716314468,12976376,11708510,13680405,14589750,13026410,1374243713737746,14644185,13742438,13326736,13596521,13001379,1634487113099577,9873405,14275605,13742436,9858539,14841812,1171508416231699,14040433,12662040,9703627,12617123,12845115,1276433713354082,14459552,13397104,13913630,12964067,12983611,1355018513810393,12780983,12583611,14546575,13476583,15862016,1184091013903046,15862017,13572659,16294378,13718279,14088346,1365760513448206,16314466,14480676,13419660,13632717,14063281,1411027513430938,13467683,13420224,13812031,14548763,16299830,1264678413616375,14035825,12861463,12834027,15862021,13632809,1337781613036331,14727310,13685544,15862018,13499128,16175381,1358413012829021,15862019,12794305,14546673,12791981,13787482,1350359810133521,12718090,13399435,14023636,13860201,12401111,1325724713362079,14176879,12917230,13923374,14220725,14480675,1352489913559697,9706792,14480674,13916709,13098318,13773133,1407652313340388,13366202,13528551,12894807,13454210,13343438,1274824014205448,13385346,15853081,14273397,12971775,13582702,1024220213035804,13544396,16382353,8547978,14226599,14062795,1303536012693626,13332439,14038787,14062796,12913474,14841409,1439025216314470,13370330,13059165,14062797,14062794,12959852,1335878112345082,12960925,9659614,13699124,14546638,13936424,1333804812938841,12658411,12620823,12656535,14062793,12678920,1303868414062792,13807411,13250244,12594032,15862022,9761357,1261211813742464,14052474,13911821,13457582,13527323,15862020,1391042013502183,12780098,13705338,13696216,14841558,10263668,1586202316056266,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