下面以Oracle 11.2.0.3手动打11.2.0.3.5补丁为例:
下载p14727347_112030_Linux-x86.zip
上传至服务器,注意解压一定要用grid用户解压
查阅README.html,按照“You must use the OPatch utility version 11.2.0.3.0 or later to apply this patch. Oracle recommends that you use the latest released OPatch for 11.2 releases,”
检查$ opatch version,如果无法满足上述要求,则参考Use OPatch to install a patch,安装最新的OPatch工具。
逐个节点执行:
1:先停止本地节点的服务,若有DB在运行则先关闭该实例
<del>#关闭实例 su - oracle</del> $ORACLE_HOME/bin/srvctl stop instance -d <db_name> -i <inst_name _list> # #使用rootcrs.pl停止本节点的服务 su - root cd $GRID_HOME/crs/install ./rootcrs.pl -unlock
2:给GI HOME打补丁
AIX上: su – root; slibclean #清理slib,否则可能无法打上补丁
检查已打补丁状况
su - grid [grid@ocmrac1 ~]$ opatch lspatches There are no Interim patches installed in this Oracle Home.
先打grid补丁
[grid@ocmrac1 ~]$ opatch napply -oh $GRID_HOME -local /datafiles/32/11.2.0.3/11.2.0.3.5/14727310 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-05-26_22-09-48PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 Do you want to proceed? [y|n] y 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 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/11.2.0/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '13343438' to OH '/u01/app/11.2.0/grid' Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Verifying the update... Applying sub-patch '13696216' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Verifying the update... Applying sub-patch '13923374' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.network.listener, 11.2.0.3.0... Verifying the update... Applying sub-patch '14275605' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.network.client, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms.util, 11.2.0.3.0... Verifying the update... Applying sub-patch '14727310' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.deconfig, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Verifying the update... Composite patch 14727310 successfully applied. Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-05-26_22-09-48PM_1.log
检查已打补丁状况
[grid@ocmrac1 ~]$ opatch lspatches 14727310;Database Patch Set Update : 11.2.0.3.5 (14727310)
[grid@ocmrac1 ~]$ opatch napply -oh $GRID_HOME -local /datafiles/32/11.2.0.3/11.2.0.3.5/15876003/ 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-05-26_22-33-36PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 15876003 Do you want to proceed? [y|n] y 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 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/11.2.0/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '15876003' to OH '/u01/app/11.2.0/grid' Patching component oracle.crs, 11.2.0.3.0... Patching component oracle.usm, 11.2.0.3.0... Verifying the update... Patch 15876003 successfully applied. Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-05-26_22-33-36PM_1.log OPatch succeeded.
[grid@ocmrac1 ~]$ opatch lspatches 15876003;Grid Infrastructure Patch Set Update : 11.2.0.3.5 (14727347) 14727310;Database Patch Set Update : 11.2.0.3.5 (14727310)
查询具体已打补丁的状况
[grid@ocmrac1 ~]$ opatch lsinventory
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-05-26_22-47-03PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2013-05-26_22-47-03PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1): 
Oracle Grid Infrastructure                                           11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch  15876003     : applied on Sun May 26 22:39:51 CST 2013
Unique Patch ID:  15703425
Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.5 (14727347)"
   Created on 11 Jan 2013, 06:16:55 hrs PST8PDT
   Bugs fixed:
     15876003, 14275572, 13919095, 13696251, 13348650, 12659561, 13039908
     14277586, 13987807, 14625969, 13938166, 13825231, 13036424, 12794268
     13011520, 13569812, 12758736, 13000491, 13498267, 13077654, 13001901
     13550689, 13430715, 13806545, 13634583, 11675721, 14082976, 14271305
     12771830, 12538907, 13947200, 12996428, 14102704, 13066371, 13483672
     12594616, 13879428, 13540563, 12897651, 12897902, 13241779, 12896850
     12726222, 12829429, 12728585, 13079948, 12876314, 13090686, 12925041
     12995950, 13251796, 12650672, 12398492, 12848480, 13582411, 13652088
     12990582, 13857364, 12975811, 12917897, 13653178, 13082238, 12947871
     13037709, 13371153, 12878750, 10114953, 11772838, 13058611, 13001955
     14001941, 11836951, 12965049, 13440962, 12765467, 13727853, 13425727
     12885323, 14407395, 13965075, 13339443, 12784559, 14242977, 13332363
     13074261, 12971251, 13811209, 12709476, 14168708, 14096821, 13993634
     13460353, 13523527, 12857064, 13719731, 13396284, 12899169, 13111013
     12558569, 13323698, 12867511, 12639013, 10260842, 12959140, 13085732
     12829917, 10317921, 13843080, 12934171, 12849377, 12349553, 13924431
     13869978, 12680491, 12914824, 13789135, 12730342, 13334158, 12950823
     10418841, 12832204, 13355963, 13531373, 13776758, 12720728, 13620816
     13002015, 13023609, 13024624, 12791719, 13886023, 13255295, 13821454
     12782756, 14152875, 14100232, 14186070, 14569263, 13912373, 12873909
     13845120, 14214257, 12914722, 13243172, 12842804, 13045518, 12765868
     12772345, 12663376, 13345868, 14059576, 13683090, 12932852, 13889047
     12695029, 14588629, 13146560, 13038806, 14251904, 14070200, 13820621
     14304758, 13396356, 13697828, 13258062, 12834777, 14371335, 12996572
     13941934, 14711358, 13657366, 13019958, 12810890, 13888719, 14637577
     13502441, 13726162, 13880925, 14153867, 13506114, 12820045, 13604057
     12823838, 13877508, 12823042, 14494305, 13582706, 13617861, 12825835
     13263435, 13025879, 13853089, 14009845, 13410987, 13570879, 13637590
     12827493, 13247273, 13068077
Patch  14727310     : applied on Sun May 26 22:11:38 CST 2013
Unique Patch ID:  15669087
Patch description:  "Database Patch Set Update : 11.2.0.3.5 (14727310)"
   Created on 8 Jan 2013, 00:29:36 hrs PST8PDT
Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Bugs fixed:
     13566938, 13593999, 10350832, 14138130, 12919564, 13624984, 13588248
     13080778, 13804294, 14258925, 12873183, 13645875, 12880299, 14664355
     14409183, 12998795, 14469008, 13719081, 13492735, 12857027, 14263036
     14263073, 13742433, 13732226, 12905058, 13742434, 12849688, 12950644
     13742435, 13464002, 12879027, 13534412, 14613900, 12585543, 12535346
     12588744, 11877623, 12847466, 13649031, 13981051, 12582664, 12797765
     14262913, 12923168, 13612575, 13384182, 13466801, 13484963, 11063191
     13772618, 13070939, 12797420, 13041324, 12976376, 11708510, 13742437
     13026410, 13737746, 13742438, 13326736, 13001379, 13099577, 14275605
     13742436, 9873405, 9858539, 14040433, 12662040, 9703627, 12617123
     12845115, 12764337, 13354082, 13397104, 12964067, 13550185, 12780983
     12583611, 14546575, 13476583, 15862016, 11840910, 13903046, 15862017
     13572659, 13718279, 13657605, 13448206, 13419660, 14480676, 13632717
     14063281, 13430938, 13467683, 13420224, 14548763, 12646784, 14035825
     12861463, 12834027, 15862021, 13377816, 13036331, 14727310, 13685544
     13499128, 15862018, 12829021, 15862019, 12794305, 14546673, 12791981
     13503598, 13787482, 10133521, 12718090, 13399435, 14023636, 12401111
     13257247, 13362079, 12917230, 13923374, 14480675, 13524899, 13559697
     14480674, 13916709, 14076523, 13773133, 13340388, 13366202, 13528551
     12894807, 13343438, 13454210, 12748240, 14205448, 13385346, 15853081
     12971775, 13035804, 13544396, 13035360, 14062795, 12693626, 13332439
     14038787, 14062796, 12913474, 14841409, 14390252, 13370330, 14062797
     13059165, 14062794, 12959852, 13358781, 12345082, 12960925, 9659614
     13699124, 14546638, 13936424, 13338048, 12938841, 12658411, 12620823
     12656535, 14062793, 12678920, 13038684, 14062792, 13807411, 12594032
     13250244, 15862022, 9761357, 12612118, 13742464, 14052474, 13457582
     13527323, 15862020, 12780098, 13502183, 13705338, 13696216, 10263668
     15862023, 13554409, 15862024, 13103913, 13645917, 14063280, 13011409
Rac system comprising of multiple nodes
  Local node = ocmrac1
  Remote node = ocmrac2
--------------------------------------------------------------------------------
OPatch succeeded.
3:给ORACLE HOME
su - oracle cd /datafiles/32/11.2.0.3/11.2.0.3.5/15876003/custom/server/15876003/custom/scripts ./prepatch.sh -dbhome $ORACLE_HOME ./prepatch.sh completed successfully.
[oracle@ocmrac1 scripts]$ opatch napply -oh $ORACLE_HOME -local /datafiles/32/11.2.0.3/11.2.0.3.5/15876003/custom/server/15876003/ Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2/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/cfgtoollogs/opatch/opatch2013-05-26_22-58-49PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 15876003 Do you want to proceed? [y|n] y 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 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '15876003' to OH '/u01/app/oracle/product/11.2' Patching component oracle.rdbms, 11.2.0.3.0... Verifying the update... Patch 15876003 successfully applied. Log file location: /u01/app/oracle/product/11.2/cfgtoollogs/opatch/opatch2013-05-26_22-58-49PM_1.log OPatch succeeded.
[oracle@ocmrac1 scripts]$ opatch napply -oh $ORACLE_HOME -local /datafiles/32/11.2.0.3/11.2.0.3.5/14727310/ Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2/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/cfgtoollogs/opatch/opatch2013-05-26_23-00-59PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 Do you want to proceed? [y|n] y 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 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2' Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Verifying the update... Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2' Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Patching component oracle.sysman.console.db, 11.2.0.3.0... Patching component oracle.sysman.oms.core, 10.2.0.4.4... Verifying the update... Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2' ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.network.listener, 11.2.0.3.0... Patching component oracle.sysman.console.db, 11.2.0.3.0... Verifying the update... Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2' ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.network.client, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.precomp.common, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms.util, 11.2.0.3.0... Verifying the update... Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2' Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.deconfig, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Patching component oracle.sysman.console.db, 11.2.0.3.0... Patching component oracle.sysman.oms.core, 10.2.0.4.4... Verifying the update... Composite patch 14727310 successfully applied. Log file location: /u01/app/oracle/product/11.2/cfgtoollogs/opatch/opatch2013-05-26_23-00-59PM_1.log OPatch succeeded.
[oracle@ocmrac1 scripts]$ cd /datafiles/32/11.2.0.3/11.2.0.3.5/15876003/custom/server/15876003/custom/scripts [oracle@ocmrac1 scripts]$ ./postpatch.sh -dbhome $ORACLE_HOME Reading /u01/app/oracle/product/11.2/install/params.ora.. Reading /u01/app/oracle/product/11.2/install/params.ora.. Parsing file /u01/app/oracle/product/11.2/bin/racgwrap Parsing file /u01/app/oracle/product/11.2/bin/srvctl Parsing file /u01/app/oracle/product/11.2/bin/srvconfig Parsing file /u01/app/oracle/product/11.2/bin/cluvfy Verifying file /u01/app/oracle/product/11.2/bin/racgwrap Verifying file /u01/app/oracle/product/11.2/bin/srvctl Verifying file /u01/app/oracle/product/11.2/bin/srvconfig Verifying file /u01/app/oracle/product/11.2/bin/cluvfy Reapplying file permissions on /u01/app/oracle/product/11.2/bin/racgwrap Reapplying file permissions on /u01/app/oracle/product/11.2/bin/srvctl Reapplying file permissions on /u01/app/oracle/product/11.2/bin/srvconfig Reapplying file permissions on /u01/app/oracle/product/11.2/bin/cluvfy Reapplying file permissions on /u01/app/oracle/product/11.2/bin/diskmon.bin Reapplying file permissions on /u01/app/oracle/product/11.2/bin/lsnodes Reapplying file permissions on /u01/app/oracle/product/11.2/bin/osdbagrp Reapplying file permissions on /u01/app/oracle/product/11.2/bin/rawutl Reapplying file permissions on /u01/app/oracle/product/11.2/srvm/admin/ractrans Reapplying file permissions on /u01/app/oracle/product/11.2/srvm/admin/getcrshome Reapplying file permissions on /u01/app/oracle/product/11.2/bin/gnsd Reapplying file permissions on /u01/app/oracle/product/11.2/bin/crsdiag.pl Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libhasgen11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libclsra11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libdbcfg11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libocr11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libocrb11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libocrutl11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libuini11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/librdjni11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libgns11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libgnsjni11.so Reapplying file permissions on /u01/app/oracle/product/11.2/lib/libagfw11.so [oracle@ocmrac1 scripts]$
4:
su - root cd /u01/app/11.2.0/grid/rdbms/install ./rootadd_rdbms.sh
重启服务和修复权限等
/u01/app/11.2.0/grid/crs/install [root@ocmrac1 install]# ./rootcrs.pl -patch Using configuration parameter file: ./crsconfig_params CRS-4123: Oracle High Availability Services has been started.
检查服务是否正常
cd /u01/app/11.2.0/grid/bin [root@ocmrac1 bin]# ./crsctl check has CRS-4638: Oracle High Availability Services is online [root@ocmrac1 bin]# ./crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [root@ocmrac1 bin]# ./crsctl stat res -t
5:在2节点上重复执行以上步骤
全部执行好,检查下 各个节点补丁是否一致。
[oracle@ocmrac1 ~]$ opatch lspatches 14727310;Database Patch Set Update : 11.2.0.3.5 (14727310) 15876003;Grid Infrastructure Patch Set Update : 11.2.0.3.5 (14727347)
[grid@ocmrac2 11.2.0.3.5]$ opatch lspatches 15876003;Grid Infrastructure Patch Set Update : 11.2.0.3.5 (14727347) 14727310;Database Patch Set Update : 11.2.0.3.5 (14727310)
6:对现有的DB执行升级数据字典操作
cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply SQL> QUIT
—————————————————-
检查服务:
[root@ora11g1 u01]# crsctl check has
CRS-4638: Oracle High Availability Services is online
[root@ora11g1 u01]# crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@ora11g1 u01]# crsctl stat res -t
—————————————————–
打完补丁后,检查下,各个节点应该都是一直的
[grid@ora11g1 ~]$ opatch lspatches
15876003;Grid Infrastructure Patch Set Update : 11.2.0.3.5 (14727347)
14727310;Database Patch Set Update : 11.2.0.3.5 (14727310)