{"id":281,"date":"2013-01-12T16:08:29","date_gmt":"2013-01-12T08:08:29","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=281"},"modified":"2013-01-23T00:02:00","modified_gmt":"2013-01-22T16:02:00","slug":"oracle-10g-%e6%89%93%e8%a1%a5%e4%b8%81%e4%b8%80%e4%be%8b","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=281","title":{"rendered":"ORACLE 10G \u6253\u8865\u4e01\u4e00\u4f8b"},"content":{"rendered":"<p>ORACLE 10G \u6253\u8865\u4e01\u4e00\u4f8b<br \/>\n10g\u6253\u8865\u4e01p13343471<\/p>\n<p>--\u67e5\u770b\u5f53\u524d\u8865\u4e01\u60c5\u51b5<br \/>\n[oracle@rac1 OPatch]$ pwd<br \/>\n\/opt\/ora10g\/product\/database\/OPatch<br \/>\n[oracle@rac1 OPatch]$ .\/opatch lsinventory<br \/>\nInvoking OPatch 10.2.0.4.9<\/p>\n<p>Oracle Interim Patch Installer version 10.2.0.4.9<br \/>\nCopyright (c) 2009, Oracle Corporation. All rights reserved.<\/p>\n<p>Oracle Home : \/opt\/ora10g\/product\/database<br \/>\nCentral Inventory : \/opt\/ora10g\/oraInventory<br \/>\nfrom : \/etc\/oraInst.loc<br \/>\nOPatch version : 10.2.0.4.9<br \/>\nOUI version : 10.2.0.5.0<br \/>\nOUI location : \/opt\/ora10g\/product\/database\/oui<br \/>\nLog file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch2012-09-13_23-19-14PM.log<\/p>\n<p>Patch history file: \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch_history.txt<\/p>\n<p>Lsinventory Output file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/lsinv\/lsinventory2012-09-13_23-19-14PM.txt<\/p>\n<p>--------------------------------------------------------------------------------<br \/>\nInstalled Top-level Products (2):<\/p>\n<p>Oracle Database 10g 10.2.0.1.0<br \/>\nOracle Database 10g Release 2 Patch Set 4 10.2.0.5.0a<br \/>\nThere are 2 products installed in this Oracle Home.<\/p>\n<p>Interim patches (1) :<\/p>\n<p>Patch 12880299 : applied on Wed Sep 12 01:15:39 CST 2012<br \/>\nUnique Patch ID: 14803344<br \/>\nCreated on 3 May 2012, 20:16:10 hrs PST8PDT<br \/>\nBugs fixed:<br \/>\n12880299<\/p>\n<p>Rac system comprising of multiple nodes<br \/>\nLocal node = rac1<br \/>\nRemote node = rac2<\/p>\n<p>--------------------------------------------------------------------------------<\/p>\n<p>OPatch succeeded.<\/p>\n<p>--apply patch<br \/>\n[oracle@rac1 OPatch]$ cd \/tmp\/13343471\/<br \/>\n[oracle@rac1 13343471]$ pwd<br \/>\n\/tmp\/13343471<br \/>\n[oracle@rac1 13343471]$ \/opt\/ora10g\/product\/database\/OPatch\/opatch apply<br \/>\nInvoking OPatch 10.2.0.4.9<\/p>\n<p>Oracle Interim Patch Installer version 10.2.0.4.9<br \/>\nCopyright (c) 2009, Oracle Corporation. All rights reserved.<\/p>\n<p>Oracle Home : \/opt\/ora10g\/product\/database<br \/>\nCentral Inventory : \/opt\/ora10g\/oraInventory<br \/>\nfrom : \/etc\/oraInst.loc<br \/>\nOPatch version : 10.2.0.4.9<br \/>\nOUI version : 10.2.0.5.0<br \/>\nOUI location : \/opt\/ora10g\/product\/database\/oui<br \/>\nLog file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch2012-09-13_23-21-41PM.log<\/p>\n<p>Patch history file: \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch_history.txt<\/p>\n<p>ApplySession applying interim patch '13343471' to OH '\/opt\/ora10g\/product\/database'<br \/>\nApplySession failed: ApplySession failed to prepare the system.<\/p>\n<p>Patch 13343471 requires OPatch version 10.2.0.5.0.<br \/>\nThe OPatch version being used (10.2.0.4.9) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.<\/p>\n<p>System intact, OPatch will not attempt to restore the system<\/p>\n<p>OPatch failed with error code 73<br \/>\n[oracle@rac1 13343471]$ \/opt\/ora10g\/product\/database\/OPatch\/opatch version<br \/>\nInvoking OPatch 10.2.0.4.9<\/p>\n<p>OPatch Version: 10.2.0.4.9<\/p>\n<p>OPatch succeeded.<\/p>\n<p>--\u5347\u7ea7OPatch<br \/>\n[oracle@rac1 OPatch]$ .\/opatch version<br \/>\nInvoking OPatch 10.2.0.5.1<\/p>\n<p>OPatch Version: 10.2.0.5.1<\/p>\n<p>OPatch succeeded.<\/p>\n<p>--\u518d\u6b21apply patch<br \/>\n[oracle@rac1 13343471]$ pwd<br \/>\n\/tmp\/13343471<br \/>\n[oracle@rac1 13343471]$ \/opt\/ora10g\/product\/database\/OPatch\/opatch apply<br \/>\nInvoking OPatch 10.2.0.5.1<\/p>\n<p>Oracle Interim Patch Installer version 10.2.0.5.1<br \/>\nCopyright (c) 2010, Oracle Corporation. All rights reserved.<\/p>\n<p>Oracle Home : \/opt\/ora10g\/product\/database<br \/>\nCentral Inventory : \/opt\/ora10g\/oraInventory<br \/>\nfrom : \/etc\/oraInst.loc<br \/>\nOPatch version : 10.2.0.5.1<br \/>\nOUI version : 10.2.0.5.0<br \/>\nOUI location : \/opt\/ora10g\/product\/database\/oui<br \/>\nLog file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch2012-09-14_00-01-54AM.log<\/p>\n<p>Patch history file: \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch_history.txt<\/p>\n<p>ApplySession applying interim patch '13343471' to OH '\/opt\/ora10g\/product\/database'<\/p>\n<p>Running prerequisite checks...<br \/>\nPatch 13343471: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle.network.cman, 10.2.0.5.0 ]<br \/>\nProvide your email address to be informed of security issues, install and<br \/>\ninitiate Oracle Configuration Manager. Easier for you if you use your My<br \/>\nOracle Support Email address\/User Name.<br \/>\nVisit http:\/\/www.oracle.com\/support\/policies.html for details.<br \/>\nEmail address\/User Name:<\/p>\n<p>You have not provided an email address for notification of security issues.<br \/>\nDo you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y<\/p>\n<p>OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.<\/p>\n<p>This node is part of an Oracle Real Application Cluster.<br \/>\nRemote nodes: 'rac2'<br \/>\nLocal node: 'rac1'<br \/>\nelease shutdown Oracle instances running out of this ORACLE_HOME on the local system.<br \/>\n(Oracle Home = '\/opt\/ora10g\/product\/database')<\/p>\n<p>Is the local system ready for patching? [y|n]<br \/>\ny<br \/>\nUser Responded with: Y<br \/>\nBacking up files and inventory (not for auto-rollback) for the Oracle Home<br \/>\nBacking up files affected by the patch '13343471' for restore. This might take a while...<br \/>\nBacking up files affected by the patch '13343471' for rollback. This might take a while...<br \/>\nExecution of 'sh \/tmp\/13343471\/custom\/scripts\/pre -apply 13343471 ':<\/p>\n<p>Return Code = 0<\/p>\n<p>Patching component oracle.rdbms, 10.2.0.5.0...<br \/>\n... ...<br \/>\nPatching in rolling mode.<\/p>\n<p>The node 'rac2' will be patched next.<\/p>\n<p>Please shutdown Oracle instances running out of this ORACLE_HOME on 'rac2'.<br \/>\n(Oracle Home = '\/opt\/ora10g\/product\/database')<\/p>\n<p>Is the node ready for patching? [y|n]<br \/>\ny<br \/>\nUser Responded with: Y<br \/>\nUpdating nodes 'rac2'<br \/>\nApply-related files are:<br \/>\nFP = \"\/opt\/ora10g\/product\/database\/.patch_storage\/13343471_Dec_20_2011_19_32_16\/rac\/copy_files.txt\"<br \/>\nDP = \"\/opt\/ora10g\/product\/database\/.patch_storage\/13343471_Dec_20_2011_19_32_16\/rac\/copy_dirs.txt\"<br \/>\nMP = \"\/opt\/ora10g\/product\/database\/.patch_storage\/13343471_Dec_20_2011_19_32_16\/rac\/make_cmds.txt\"<br \/>\nRC = \"\/opt\/ora10g\/product\/database\/.patch_storage\/13343471_Dec_20_2011_19_32_16\/rac\/remote_cmds.txt\"<\/p>\n<p>Instantiating the file \"\/opt\/ora10g\/product\/database\/.patch_storage\/13343471_Dec_20_2011_19_32_16\/rac\/copy_files.txt.instantiated\" by replacing $ORACLE_HOME in \"\/opt\/ora10g\/product\/database\/.patch_storage\/13343471_Dec_20_2011_19_32_16\/rac\/copy_files.txt\" with actual path.<br \/>\nPropagating files to remote nodes...<br \/>\n... ...<br \/>\nThe node 'rac2' has been patched. You can restart Oracle instances on it.<\/p>\n<p>There were relinks on remote nodes. Remember to check the binary size and timestamp on the nodes 'rac2' .<br \/>\nThe following make commands were invoked on remote nodes:<br \/>\n'cd \/opt\/ora10g\/product\/database\/rdbms\/lib; \/usr\/bin\/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=\/opt\/ora10g\/product\/database<br \/>\ncd \/opt\/ora10g\/product\/database\/rdbms\/lib; \/usr\/bin\/make -f ins_rdbms.mk ioracle ORACLE_HOME=\/opt\/ora10g\/product\/database<br \/>\ncd \/opt\/ora10g\/product\/database\/plsql\/lib; \/usr\/bin\/make -f ins_plsql.mk iwrap ORACLE_HOME=\/opt\/ora10g\/product\/database<br \/>\ncd \/opt\/ora10g\/product\/database\/network\/lib; \/usr\/bin\/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=\/opt\/ora10g\/product\/database<br \/>\ncd \/opt\/ora10g\/product\/database\/precomp\/lib; \/usr\/bin\/make -f ins_precomp.mk proc ORACLE_HOME=\/opt\/ora10g\/product\/database<br \/>\ncd \/opt\/ora10g\/product\/database\/rdbms\/lib; \/usr\/bin\/make -f ins_rdbms.mk irman ORACLE_HOME=\/opt\/ora10g\/product\/database<br \/>\n'<\/p>\n<p>OPatch succeeded.<\/p>\n<p>--\u67e5\u770b\u8865\u4e01\u5b89\u88c5\u60c5\u51b5<br \/>\n[oracle@rac1 ~]$ cd \/opt\/ora10g\/product\/database\/OPatch<br \/>\n[oracle@rac1 OPatch]$ .\/opatch lsinventory<br \/>\nInvoking OPatch 10.2.0.5.1<\/p>\n<p>Oracle Interim Patch Installer version 10.2.0.5.1<br \/>\nCopyright (c) 2010, Oracle Corporation. All rights reserved.<\/p>\n<p>Oracle Home : \/opt\/ora10g\/product\/database<br \/>\nCentral Inventory : \/opt\/ora10g\/oraInventory<br \/>\nfrom : \/etc\/oraInst.loc<br \/>\nOPatch version : 10.2.0.5.1<br \/>\nOUI version : 10.2.0.5.0<br \/>\nOUI location : \/opt\/ora10g\/product\/database\/oui<br \/>\nLog file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch2012-09-14_00-15-26AM.log<\/p>\n<p>Patch history file: \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch_history.txt<\/p>\n<p>Lsinventory Output file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/lsinv\/lsinventory2012-09-14_00-15-26AM.txt<\/p>\n<p>--------------------------------------------------------------------------------<br \/>\nInstalled Top-level Products (2):<\/p>\n<p>Oracle Database 10g 10.2.0.1.0<br \/>\nOracle Database 10g Release 2 Patch Set 4 10.2.0.5.0a<br \/>\nThere are 2 products installed in this Oracle Home.<\/p>\n<p>Interim patches (2) :<\/p>\n<p>Patch 13343471 : applied on Fri Sep 14 00:06:40 CST 2012<br \/>\nUnique Patch ID: 14268542<br \/>\nCreated on 20 Dec 2011, 19:32:16 hrs PST8PDT<br \/>\nBugs fixed:<br \/>\n6402302, 10269717, 10327190, 11693109, 8865718, 10017048, 9024850<br \/>\n8394351, 8546356, 8224558, 13489660, 9360157, 9770451, 9020537, 9772888<br \/>\n8650138, 8664189, 8488233, 10091698, 10092858, 12551710, 7519406<br \/>\n13349665, 10132870, 8771916, 9109487, 7509714, 9171933, 10173237<br \/>\n9532911, 10139235, 10159846, 10068982, 8350262, 11792865, 7119382<br \/>\n7361418, 10306945, 8666117, 11724962, 11725006, 6157713, 10214450<br \/>\n9184754, 8966823, 8544696, 9320130, 9767674, 9323583, 7026523, 9399589<br \/>\n8277300, 9672816, 13343467, 9726739, 9499302, 8412426, 10165083, 10208905<br \/>\n12419392, 6651220, 9150282, 9145204, 9659614, 9949948, 11076894, 10327179<br \/>\n8882576, 7612454, 7111619, 7450366, 9711859, 11893577, 9714832, 9735237<br \/>\n8970313, 6011045, 11814891, 10162036, 10248542, 9952230, 9469117, 13359623<br \/>\n9952270, 9842573, 13343471, 8660422, 10324526, 11066597, 12419258<br \/>\n9322219, 8636407, 9713537, 12828105, 10010310, 9390484, 9824435, 12925532<br \/>\n9963497, 9032322, 12862186, 12551700, 12862187, 12551701, 10249537<br \/>\n12551702, 12551703, 9586877, 8211733, 12551704, 10076669, 6694396<br \/>\n9548269, 12551705, 12551706, 9337325, 12551707, 8354642, 7602341, 12551708<br \/>\n9308296, 12827745, 9072105, 8528171, 10157402, 12565867, 11737047<\/p>\n<p>Patch 12880299 : applied on Wed Sep 12 01:15:39 CST 2012<br \/>\nUnique Patch ID: 14803344<br \/>\nCreated on 3 May 2012, 20:16:10 hrs PST8PDT<br \/>\nBugs fixed:<br \/>\n12880299<\/p>\n<p>Rac system comprising of multiple nodes<br \/>\nLocal node = rac1<br \/>\nRemote node = rac2<\/p>\n<p>--------------------------------------------------------------------------------<\/p>\n<p>OPatch succeeded.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ORACLE 10G \u6253\u8865\u4e01\u4e00\u4f8b 10g\u6253\u8865\u4e01p13343471 &#8211;\u67e5\u770b\u5f53\u524d\u8865\u4e01\u60c5\u51b5 [oracle@rac [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[87],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/281"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=281"}],"version-history":[{"count":7,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/281\/revisions"}],"predecessor-version":[{"id":645,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/281\/revisions\/645"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=281"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}